One of my friend got the below error in our SQL Server 2005 environment.
000016bc.000009f4::2011/03/02-00:46:48.840 ERR SQL Server <SQL Server (DWHCI01)>: [sqsrvres] StartResourceService: StartService (MSSQL$DB1) failed. Error: 422
000016bc.000009f4::2011/03/02-00:46:48.840 ERR SQL Server <SQL Server (DWHCI01)>: [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 422)
000016bc.000009f4::2011/03/02-00:46:48.840 ERR SQL Server <SQL Server (DWHCI01)>: [sqsrvres] OnlineThread: Error 422 bringing resource online
Application logs is showing similar errors.
Resolution
Found that SQL Server service is in Disabled status. Made the same to Manual and bring the resource online.
thnx
ReplyDelete