February 14, 2011 at 5:25 am
Hi all,
On one of the servers the password for 'sa' must be changed and I'm trying to figure out possible impacts this can cause on the system.
I suppose if the application has been set up to use this account (that should not be the case of course) then the password must be changed also there. Besides, I'm not sure whether the Agent Jobs under owner 'sa' will succeed in the future... Any ideas, please? Thank you.
__________________________
Allzu viel ist ungesund...
February 14, 2011 at 5:45 am
Agent jobs that run as sa don't use the password (or at least, they shouldn't), but yes, if you have apps that are dependent on the SQL 'sa' login, they will have to be updated.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 6:04 am
Wat abt maintanence plans running under user 'sa'?
Regards,
Sushant
Regards
Sushant Kumar
February 14, 2011 at 6:11 am
SKYBVI (2/14/2011)
Wat abt maintanence plans running under user 'sa'?Regards,
Sushant
Those are usually running from SQL Agent and should not be an issue. If you call them in other ways, all bets are off.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 16, 2011 at 6:10 am
Thanks very much for your response!
__________________________
Allzu viel ist ungesund...
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply