May 15, 2009 at 11:56 am
Hi,
Every time I restarted the Sql service, Iam getting following error in the error log and also in the event viewer.
Please tell me what is the reason for this?
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(4)
Event ID:17187
Date:5/14/2009
Time:10:49:29 AM
User:N/A
Computer:ABC
Description:
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: 10.10.10.10]
regards
Ram
May 15, 2009 at 1:33 pm
rambilla4 (5/15/2009)
Hi,Every time I restarted the Sql service, Iam getting following error in the error log and also in the event viewer.
Please tell me what is the reason for this?
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(4)
Event ID:17187
Date:5/14/2009
Time:10:49:29 AM
User:N/A
Computer:ABC
Description:
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: 10.10.10.10]
regards
Ram
This is just plain normal and it happens because only after all SQL Server initialization is done no client can connect to it.
You are not supposed to be rebooting your server too often anyway
* Noel
May 15, 2009 at 8:21 pm
Since you have posted this article under sql 2005 then I am assuming we are talking about this version.
Question: what is the service version installed on this server?
Cheers,
John Esraelo
May 16, 2009 at 10:14 pm
Sql server 2005 32 bit with SP3
May 16, 2009 at 10:23 pm
I am not sure if the link in below is 100 percent relevant to your situation, but, I just found it and I was about to read it.
http://support.microsoft.com/kb/929376
Even if it is not exactly what you were looking for, it could have some useful information.
lets see what happens.. 🙂
Cheers,
John Esraelo
May 17, 2009 at 4:01 am
I believe that this message is pefectly normal and nothing to be worried about (like a lot of the messages that appear in the SQL Server log, it is for informational purposes only).
I think it is merely telling you that a client tried to connect to SQL Server before SQL Server had fully started.
I have this same message in the log files of several of my servers as well.
March 21, 2012 at 4:43 am
I have this error message on one of my servers.
I ran Kaspersky antivirus as well which is dependent on SQL.
Every time the server is rebooted Kaspersky fails and cant run all of the components until I re-install the application.
I've tried the hot fix mentioned above but the version of SQL I am running is a higher version than the one provided KB article.
Any suggestions will be greatly appreciated.
EP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply