changing sa password

hi everyone
i am planning to change sa password in my Development server as too many
people know the password. I am trying this first time.
Can someone please let me know any impacts of changing sa password?
or I can change the password as normal way to changing password.
Thank you
syed
*** Sent via Developersdex http://www.codecomments.com ***Hi
If you have an application that connected to the SQL Server wit a Mixed Mode
, so you will have to change the password there. As well as Linked Servers
that was defined by providing username and password. And finally , if you
was connected to the EM by an old password the error will be thrown.
"Syed Hussain" <syedkhalidhussain@.gmail.com> wrote in message
news:Ofr8Ux%23mFHA.420@.TK2MSFTNGP09.phx.gbl...
> hi everyone
> i am planning to change sa password in my Development server as too many
> people know the password. I am trying this first time.
> Can someone please let me know any impacts of changing sa password?
> or I can change the password as normal way to changing password.
> Thank you
> syed
> *** Sent via Developersdex http://www.codecomments.com ***|||Hi,
To Add on to Uri;
Execute sp_who in frequent intervals and identify the users / application
who are using SA user to access sql server. Then send out an
email to all of them intimating that you are going to change the password
for SA.
Give them some time to change and after that do below:-
1. Change the Applcation connection strings to use new user
2. Change the Linked server security credentials if SA is used
3. EM registrations if you store password ( Avoid storing passwords)
Thanks
Hari
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eZGrB0%23mFHA.3288@.TK2MSFTNGP09.phx.gbl...
> Hi
> If you have an application that connected to the SQL Server wit a Mixed
> Mode , so you will have to change the password there. As well as Linked
> Servers that was defined by providing username and password. And finally ,
> if you was connected to the EM by an old password the error will be
> thrown.
>
>
> "Syed Hussain" <syedkhalidhussain@.gmail.com> wrote in message
> news:Ofr8Ux%23mFHA.420@.TK2MSFTNGP09.phx.gbl...
>|||And once you've changed the password, stop using sa to log in to SQL Server.
You
should create logins for people who really need sysadmin privileges so that
you
don't get this problem again.
Don
On Mon, 8 Aug 2005 16:46:40 +0530, "Hari Prasad" <hari_prasad_k@.hotmail.com>
wrote:

>Hi,
>To Add on to Uri;
>Execute sp_who in frequent intervals and identify the users / application
>who are using SA user to access sql server. Then send out an
>email to all of them intimating that you are going to change the password
>for SA.
>Give them some time to change and after that do below:-
>1. Change the Applcation connection strings to use new user
>2. Change the Linked server security credentials if SA is used
>3. EM registrations if you store password ( Avoid storing passwords)
>Thanks
>Hari
>SQL Server MVP
>
>"Uri Dimant" <urid@.iscar.co.il> wrote in message
>news:eZGrB0%23mFHA.3288@.TK2MSFTNGP09.phx.gbl...
>|||If you have scripts which hardcoded sa password, then it will be a problem.
Eric King
AgileInfoSoftware
http://www.agileinfollc.com
"Syed Hussain" <syedkhalidhussain@.gmail.com> wrote in message
news:Ofr8Ux%23mFHA.420@.TK2MSFTNGP09.phx.gbl...
> hi everyone
> i am planning to change sa password in my Development server as too many
> people know the password. I am trying this first time.
> Can someone please let me know any impacts of changing sa password?
> or I can change the password as normal way to changing password.
> Thank you
> syed
> *** Sent via Developersdex http://www.codecomments.com ***