June 3, 2008 at 8:07 pm
hi,
our server was down n no transactions are happening n users are not able access the server.
then we restarted the server. After restarting the server also many commands are in awaiting state (sp-who2 results).We are trying to investigate why the server is down n I found one error messege in the error log as
Date6/3/2008 9:47:42 PM
LogSQL Server (Current - 6/3/2008 9:47:00 PM)
Sourcespid51
Message
Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
Could you please tell me about this error?
June 3, 2008 at 8:29 pm
I had this problem when I reinstalled sql server on a different drive. Check your SQLAGENT.OUT log file and see if you have any errors starting any of the subsystems.
June 3, 2008 at 8:37 pm
where can I see this SQLAGENT.OUT logfile?
June 3, 2008 at 8:41 pm
The default directory is C:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply