SQL server ERROR

[suhasingale]

Hello Friends,

I am getting the error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied in my SQL server. The SQL server is running and everything is fine i mean all the services are running. Same coding and script was running fine till date and also i have not changed any settings. Kindly help me in solving the problem.

[rajesh]

Hope this helps

http://support.microsoft.com/default.aspx?kbid=328306

[::cyborg::]

r u using sql 2000

[vinaypatel]

what ur serverce manager says

try to login in sql query analyser

try to use sql authentication

or uninstaall and instal it in mix mode

[suhasingale]

I rebooted the server and the problem was solved.

[royal]

if u r accessing SQL Server from a client machine , then sometimes u need to "connect" to the server from the client machine before u connect to SQL Server

for e.g. u can go to Start> Run and type //Server and press enter then login to Server with userid and password (assuming name of ur server is "Server")...

this has helped me ... hope it also helps u