SQL Server Agent on SQL Server 2000 not started.
There are One SQL Server Service account and one connection setting for the serivce account this need to be checked for any password change and accont change if not windows authentication
It almost relevant of "http://support.microsoft.com/default.aspx?scid=kb;en-us;237604".
From Event Viewer
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Service Control
Event ID: 103
Date: 30/07/2005
Time: 4:01:50 PM
User: N/A
Computer: AAUNSW047
Description:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
Output on SQL Agent when tries "SQLAgent -c -v " from the command prompt
2005-07-30 16:01:50 - ? [094] SQLServerAgent started from command line
2005-07-30 16:01:50 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
2005-07-30 16:01:50 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2005-07-30 16:01:50 - ? [098] SQLServerAgent terminated (normally)
Tuesday, August 02, 2005
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment