Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to reboot Sql server
Message
 
To
05/07/2002 11:01:14
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00675633
Message ID:
00676138
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform