SQL Server frozen

  • My Server froze and I got this fatal error 823 message

    SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...

    Any suggestion as to what can be the cause and how to solve this rpoblem will be greatly appreciated.

  • That message is from SQL server AGENT stopping because it was told to. So I guess something or someone told the service to shut down, either via the services applet, NET STOP on a command line, the command shutdown to Sql Server or similar.

    You can use the sevices applet to chek if is runningand restart it.

    HTH

    Mike

  • Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply