Re: changing sa password
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/08/05
- Next message: Hari Prasad: "Re: Get the owner of a table in SQLServer"
- Previous message: Uri Dimant: "Re: Get the owner of a table in SQLServer"
- In reply to: Uri Dimant: "Re: changing sa password"
- Next in thread: Don Kiely: "Re: changing sa password"
- Reply: Don Kiely: "Re: changing sa password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 8 Aug 2005 16:46:40 +0530
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...
>> 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.developersdex.com ***
>
>
- Next message: Hari Prasad: "Re: Get the owner of a table in SQLServer"
- Previous message: Uri Dimant: "Re: Get the owner of a table in SQLServer"
- In reply to: Uri Dimant: "Re: changing sa password"
- Next in thread: Don Kiely: "Re: changing sa password"
- Reply: Don Kiely: "Re: changing sa password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
