January 4, 2011 at 2:44 am
Hi,
In one of our application users were facing problem connecting to SQL server. I checked the eventvwr and SQL log during that time. The messages are given below respectively.
Can anyone please tell me what is the likely reason for this?
SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]
Message
[165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
Ryan
//All our dreams can come true, if we have the courage to pursue them//
January 4, 2011 at 3:12 am
Sumanta,
Are you able to connect to this instance using SSMS?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 4, 2011 at 4:30 am
The problem was only for half an hour. Now I can connect using SSMS and application is also able to connect. I am trying to find what was the reason for this problem.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
January 4, 2011 at 4:35 am
Please check if the SQL Server instances was starting up when you saw the error message. You can go through the Event Viewer/SQL Server Error Log.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 4, 2011 at 7:21 am
During the time period check the following
-Can you connect to SQL Server on the server using management studio
-can you connect using management studio or with an ODBC from a workstation
-Also compare server load and processes from the time period the of the connect issue.
It could even be something maxing out the server and not allowing the connection (such as a scheduled backup, AV scan, ...)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply