Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
murthyspd
Starting Member
1 Post |
Posted - 2011-05-25 : 09:53:00
|
HiI need to take training on SQL server. For that, I have installed sql server 2005 express on my laptop and want others to access the instance. I have done the following things :1. Enable TCP/IP2. Enable Browser service3. Have added the user to Security\LoginsIs there anything else I need to do RegardsMurthy |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-05-25 : 10:26:57
|
Not very familiar with the Express edition, but you may want to check if remote connections are enabled. It would be in SQL Server Surface Area configuration tool under Database Engine -> Remote connections. |
 |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-05-27 : 17:40:27
|
Also you may need to add the SQL port (1433) to the exception list of the firewall.Couple of notes; if you have named instance then you must specify name of the instance along with the name of your computer e.g. on remote machine 192.168.0.1\SQLNamedInstance or ComputerName\SQLNamedInstance would be the server names, If it is the default instance name then you can just type in the computer name/IP as the server.CheersMIK |
 |
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-06-01 : 05:22:09
|
Check that remote connections are enabled in surface area configurations this is always turned off my default. |
 |
|
|
|
|