April 8, 2009 at 8:14 am
Good morning,
I am seeing these error messages in my production server event log.
Does anyone recognize these and could you explain them or point to a source to figure out what needs to be done?
Thanks.
1) SQL Server is not ready to accept new client connections.
2) SQLDVI
1)
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(4)
Event ID:17187
Date:4/8/2009
Time:6:17:03 AM
User:N/A
Computer:LONDON
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.241.110.244]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 23 43 00 00 10 00 00 00 #C......
0008: 07 00 00 00 4c 00 4f 00 ....L.O.
0010: 4e 00 44 00 4f 00 4e 00 N.D.O.N.
0018: 00 00 00 00 00 00 ......
2)
Event Type:Error
Event Source:SQLVDI
Event Category:None
Event ID:1
Date:4/8/2009
Time:6:16:51 AM
User:N/A
Computer:LONDON
Description:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=8756. Thread=8476. Client. Instance=. VD=Global\f9795121-9699-4acb-bffb-c6dbaf67c861_SQLVDIMemoryName_0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Tony
Things will work out. Get back up, change some parameters and recode.
April 8, 2009 at 9:22 am
Hi,
What is your SQL server edition and also how many connections did you define? Is it an express?
April 8, 2009 at 12:39 pm
Hello,
I am running SQL Server 2005. It is set at 0 for unlimited connections.
Tony
Things will work out. Get back up, change some parameters and recode.
April 8, 2009 at 1:28 pm
Hi,
Anything in the SQL error log. could you please post that please?
April 8, 2009 at 1:31 pm
WebTechie38 (4/8/2009)
Hello,I am running SQL Server 2005. It is set at 0 for unlimited connections.
Tony
Hi,
Please take a look at this, this is a known error message by microsoft and it offers a solution to apply a hot-fix to the sever. Follow this link:
April 9, 2009 at 9:04 am
Thanks for your help.
I believe our server is under a heavy load at times. We are currently at service pack 3. So this fix should already be on the server.
However, I will run profiler to see what is going on during these times.
Thanks again.
Tony
Things will work out. Get back up, change some parameters and recode.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply