June 10, 2010 at 2:12 pm
what are impacts if i change the sa password ?
June 10, 2010 at 2:18 pm
There shouldn't be any impact, because no one should be using 'sa'. But if anything is using 'sa', it will fail.
When I first started at this company, 'sa' was used in several applications and several users also knew the password. We had to change the applications before I could change the password.
June 10, 2010 at 2:24 pm
Unfortunately as Homebrew said, if any apps are using it you will need to change the apps first.
Despite the fact that it is bad practice to use SA for everything, it is a very common practice. I have seen sa used in applications at every job I have had as a dba. I have had to fight in each instance to get it changed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 10, 2010 at 2:46 pm
thanks for the information.
so many jobs running under the owner as SA, will it be any problem if i change the sa password?
I have created a login with sysadmin role. is it equal to Sa login?
June 10, 2010 at 2:48 pm
charipg (6/10/2010)
thanks for the information.so many jobs running under the owner as SA, will it be any problem if i change the sa password?
I have created a login with sysadmin role. is it equal to Sa login?
You can leave the jobs as-is. Changing the sa password will not impact the execution of a job. You only need to be concerned about external connections being made into the database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply