Cannot Connect to MSDE 2000 database across the network
Posted on 2004-09-12
I have MSDE 2000 installed.
I just installed the latest version yesterday from Microsofts website (so it is the latest)
Along with this, I have SQL Server 2000 developer edition installed for management of the engine.
I have it running just fine on my local machine.
I used these setup parameters when installing
setup instancename ="instancename" sapwd="mypassword" securitymode=sql
This works fantastic as long as i am connecting to the instance on the local machine.
I was inexperienced at the setup of MSDE prior to today and so when installing I left off the
disablenetworkprotocols=0 switch in the setup command line statement.
So I have effectively disabled my network support.
I am not able to connect to the instance of MSDE now across the network and I need this fixed.
Can anyone tell me how to do this paaalease?
I have ran the svrNetCN.exe utility located in C:\program files\microsoft sql server\80\Tools\Binn and enabled TCP/IP
Support on the default port (thought this would solve my issue but did not)
I stopped and restarted the service multiple times and it still does not work.
I do not have sql client tools installed on the client so i cannot try to connect using the sql client tools to the database.
Internet connection firewall is disabled on both PCs and both PCS are within 10 feet of each other (XP Pro and XP Home peer to peer)