January 25, 2005 at 4:31 pm
I have instaled MSDE2000 on Windows 2000 workstation. I'm trying to register it from another machine with SQL Server 2000 and no matter what I can not connect (Sql server does not exist). I can connect locally to localhost, but not from another machine on the same domain. Not with WindowsAuthentication, not with sa and password I've given upon installation.
I know Sql server is running on that machine (SQL Server agent too), I checked into Registry and TCP is part of ProtocolList.
Any idea? Thanks in advance
ej
January 25, 2005 at 4:41 pm
I found the answer from another guy's question. Run "SVRNETCN.exe" to enable TCP/IP and it works great.
Thanks to whoever posted that reply.
January 27, 2005 at 4:23 pm
Yep, that is definitly a way to fix the problem. MS changed the install defaults with MSDE Rlease A. Previous versions allowed other machines to access the MSDE by default. Release A, by default, does NOT allow other machines to query it.
You can specify the DISABLENETWORKPROTOCOLS=0 switch on the command line when you install it, and it will then allow other machines to access the DB. If you leave the switch off when installing it, then you need to do what you did above; run the SVRNETCN.exe program.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply