sql server connect: (CrossPost: microsoft.public.opsmgr.sql, =
microsoft.public.sqlserver.connect, microsoft.public.sqlserver.server)

I installed SQL Server 2005, then i reboot the server (w2k3 r2 std ed), =
then i saw the following event:
Actually i reformated my sql server because of this event, and now it's =
again here :(

This SQL Server 2005 is for Operations Manager 2007, but we think SCOM =
does not work stable because of this SQL Server event.

Does anybody know why i get this error, and what is the solution?

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17187
Date: 8/28/2007
Time: 2:06:23 PM
User: N/A
Computer: MOMDBSERVER
Description:
SQL Server is not ready to accept new client connections; the connection =
has been closed. 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>]

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: 0c 00 00 00 4d 00 4f 00 ....M.O.
0010: 4d 00 44 00 42 00 53 00 M.D.B.S.
0018: 45 00 52 00 56 00 45 00 E.R.V.E.

Hi Seth,


I saw about this in a forum, this error occurs when a remote connection =
is made before SQL Server finishes its openning process.

--=20
Ekrem =D6nsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT



[quoted text, click to view]
(CrossPost: microsoft.public.opsmgr.sql, =
microsoft.public.sqlserver.connect, microsoft.public.sqlserver.server)

I installed SQL Server 2005, then i reboot the server (w2k3 r2 std =
ed), then i saw the following event:
Actually i reformated my sql server because of this event, and now =
it's again here :(

This SQL Server 2005 is for Operations Manager 2007, but we think SCOM =
does not work stable because of this SQL Server event.

Does anybody know why i get this error, and what is the solution?

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17187
Date: 8/28/2007
Time: 2:06:23 PM
User: N/A
Computer: MOMDBSERVER
Description:
SQL Server is not ready to accept new client connections; the =
connection has been closed. 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>]

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: 0c 00 00 00 4d 00 4f 00 ....M.O.
0010: 4d 00 44 00 42 00 53 00 M.D.B.S.
0018: 45 00 52 00 56 00 45 00 E.R.V.E.