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 |
|
yihua833
Starting Member
1 Post |
 Posted - 2003-07-14 : 19:49:10
|
| i have a MSDE 2000 installed on the Windows 2003. i use Enterpise Manager connect to it. only name pipe(Local server) can find the server. but i need to use TCP/IP register the server.it give me an error "sql server does not exist or access denied. connectionopen(connect())"please help! |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-15 : 14:59:55
|
I assume this is MSDE2000 SP3a. The default for an MSDE SP3a install is to disable network protocols as a security feature. Have a look at [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;814130[/url] quote:
There are two changes to the behavior of DISABLENETWORKPROTOCOLS in SP3a: The default when installing a new instance of SP3a is to disable network protocol support, making the instance more secure by default.You can specify that the network protocol support be turned off when upgrading an existing instance of MSDE 2000.
If you have not yet applied SP3a (SP3 is the minimum level supported on Windows 2003) then the network protocols will also be disabled. This is true of all installs on Windows 2003, the network protocols are disabled during install until SP3 is applied. Again this is a security feature.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
MSDE 2000 on Windows 2003