all groups > sql server connect > may 2004 >
You're in the

sql server connect

group:

SQL Server Login Error


SQL Server Login Error SqlJunkies User
5/27/2004 7:26:17 AM
sql server connect:
Could you provide explanation of the following error message, and what I need to do to rectify it?



Connection failed:
SQL State: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
SQL Server does not exist or access denied.

Thanks,

CC

---
Posted using Wimdows.net NntpNews Component -

Re: SQL Server Login Error Hari
5/27/2004 8:15:53 PM
Hi,

This is not Login issue. This error will come because of below reason:-

1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong server name.

If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.

Thanks
Hari
MCDBA


[quoted text, click to view]
supports Post Alerts, Ratings, and Searching.

Re: SQL Server Login Error bekwong
6/9/2004 12:40:25 AM

[quoted text, click to view]

Dear Hari

I do encounter similar problem every now and then, the problem occur
when I am running a scrip half way and the Query Analyzer get hang.
Once this occurs, I can't get into the SQL server any more. I have t
wait for the next day before everything is back to normal.

What is the cause


-
bekwon
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message716065.htm
Re: SQL Server Login Error SqlJunkies User
7/21/2004 7:04:46 AM
I have run into this error as well. This usually occurs when there has been a period of poor network connectivity. Here is the solution that has worked for me:

Backup the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERY

Then search for entries related to the connection that is not working (I usually delete all entries found in this portion of the registry). The connection should again work after this has been completed.

See the Microsoft Article:

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


I hope this helps.

Erik

---
Posted using Wimdows.net NntpNews Component -

AddThis Social Bookmark Button