sql 2005 express edition tcpip connections off by default

[anyweb]

can't connect to your SQL 2005 server ?

 

check the tcp/ip options

 

sql 2005 express edition that is secure out of the box. In sql 2005, the tcp/ip stack is disabled and remote connections are not allowed. Thats by default. So you first have to configure the sql 2005 express edition correctly, and take it from there.

 

 

Try bringing up the SQL server configuration tool. You don't have the icon, so run

 

C:\WINNT\system32\mmc.exe /32 "C:\WINNT\system32\SQLServerManager.msc"

 

 

Select the client protocols option and enable TCP/IP

[anyweb]

replace WINNT with WINDOWS (or whatever you called the windows directory) above, otherwise you'll get an error message. Restart the SQL service after making any changes.

 

cheers

anyweb