February 10, 2006 at 6:25 am
Hi Friends,
I am trying to connect MS SQL Server 2000 Through SQL Analyzer but it is giving me this error.
Unable to connect to server XYZ
[Microsoft][ODBC SQL Server Driver][DBNETLIB] server does not exist or acces denied
But i am able to connect the same server using enterprise manager. Please help me regarding same.
Thanking you.
February 10, 2006 at 6:41 am
Hello Joshi,
First ping the SQL Server from your machine.
Next, check whether the username and password you have used to register the Server in Enterprise Manager are one and the same you are using in SQL Query Analyzer.
Is it a default instance or a named instance?
Thanks and have a nice day!!!
Lucky
February 10, 2006 at 6:47 am
Hi Lucky,
Thanks for quick respose.
1. I checked it already. It's pinging.
2. username and password is same for both.
3. And it is named instance even i was using it with sql analyzer but now it is giving this error.
Please suggest some solution.
February 10, 2006 at 7:13 am
Hello Joshi,
For named instance, you need to add the server in Client Network Utility.
Go to Start ->Programs->Microsoft SQL Server->Client Network Utility
In the Alias tab, click on Add button and give the server name as <computername>\<instancename> in the connection parameters but the server alias will look like <computername>
Check the tcp/ip radio button.
You can check the help in Books Online
Named Instances->Working with Named and Multiple Instances of SQL Server 2000
Hope this helps you.
Lucky
February 10, 2006 at 7:54 am
Hi Lucky,
This configuration is already there. Dont know why it is not allowing me to connect through SQL Analyzer.
February 10, 2006 at 7:58 am
Firewall? I had a problem connecting to one of my servers and then noticed that i had Zonealarm was running, I shut that down and then everything worked fine. Obviously its best to configure the firewall but if you want a quick answer...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply