February 14, 2003 at 1:59 pm
I am having an issue with a specific database on a server that contains several databases. When I looked at it today, the service was stopped and I was not able to re-start it. I looked at the Event Viewer and found two messages, which were the same but at differnt time.:
1. The SQLServerAgent service depends on the MSSQLServer service which failed to start because of the following error: %%0
2. The SQLServerAgent service depends on the MSSQLServer service which failed to start because of the following error: %%0
Does anyone have any ideas on what may be causing this, or where to look? Thank you in advance.
February 14, 2003 at 4:43 pm
Anything else in either system or application log? You might look in the SQL log folder, see what is in the error log. Probably next step if nothing found there is to try to start in single user mode (sqlservr -c -m from the command line).
Andy
February 17, 2003 at 1:08 pm
I was able to resolve this issue by running regrebld.exe from the binn directory. Once I did this, the service started up and everything was in working order.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply