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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Sql server 2005 express

Author  Topic 

murthyspd
Starting Member

1 Post

Posted - 2011-05-25 : 09:53:00
Hi
I 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/IP
2. Enable Browser service
3. Have added the user to Security\Logins
Is there anything else I need to do

Regards
Murthy

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.
Go to Top of Page

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.

Cheers
MIK
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -