August 24, 2010 at 3:44 am
Good Day,
We use Windows 2003 and SQL Server 2005 and use a Domain Account as a startup account for the SQL Server Agent Service . The manual restart of the service was successful . When the server is rebooted the service does not restart and logs a "failed login " error in the eventlog . Any ideas why the account does not authenticate ?
Regards.
Ps. We could not add the "Logon as a Service" permission to the account using the group policy menu , the add button was greyed out , although I have the correct permissions .
August 24, 2010 at 4:31 am
may be the password for the Id has got expired.Try to update the password and try with new password.
Even if does'nt work check for server name and update it in registry.
Add server's name as value in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent\ServerHost and restart SQL server agent services..
Hope it will resolve the issue.
August 24, 2010 at 4:46 am
Use your result of SELECT @@servername to put in the Registry Key.
August 25, 2010 at 4:42 am
Yes, most likely the password got expired or reset. Please check
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 4:51 am
Good Day,
the password has not expired .
August 25, 2010 at 1:04 pm
Please check the System Event Log at the time of this issue. Most likely there will be some errors related to Active Directory not being reachable.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply