>We have one SQL server 6.5 run on the Window NT 4.0 server. It has some problems. Every 4-7 days we need to reboot that server, because users can not make connection to it. Enterprise Manager can not make connection with it either. After reboot, every thing is OK.
>
>In the Nt Event Viewer. I found 2 events relative to it. Following are event detail of those.
>
>1.Source: Perflib Event: 2002
>The open procedure for service "MSSQLServer" in DLL "SQLCTR60.DLL" has taken longer than the established wait time to complete. The wait time in milliseconds is shown in the data.
>
>2.Source: SQLCTR60 Event: 8
>DB-LIBRARY error - SQL Server connection timed out.
>
>Please help.
>
>
>Jim
Doing a google search turned this up... you may want to do a more general search there if it does not help -
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q227662
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown