I have changed my sa password on the database SQL 2005. I have also changed the DOMAIN\Account account from our Active Directory.
Then I went into SQL Server Configuration Manager and changed the SQL Server Broswer to the new DOMAIN\Account and I also changed the SQL Server Agent (MSSQLSERVER) to the new DOMAIN\Account.
Now I think I got everything covered. But my jobs are failing. Even though the Owner of the Job is DOMAIN\Account i get a
".. Description: System.Runtime.InteropServices.COMException (0x80040E4D): Login failed for user 'sa'. ..."
thank you
Check the job to see if it is running as sa and if it is make sure that the password is the same as the password you selected for sa when you changed it.
HTH,
-Steven Gott
SDE/T
SQL Server
No comments:
Post a Comment