Sunday, March 11, 2012

Changing sa SQL 2005

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