Re: changing sa password
From: Don Kiely (donkiely_at_computer.org)
Date: 08/09/05
- Next message: Dandy Weyn [Dandyman]: "Re: Limiting access to SQL Server 2000 for our junior developers"
- Previous message: bcrenshaw99_at_yahoo.com: "Re: Limiting access to SQL Server 2000 for our junior developers"
- In reply to: Hari Prasad: "Re: changing sa password"
- Next in thread: John King: "Re: changing sa password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 08 Aug 2005 22:11:13 -0800
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...
>> 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: Dandy Weyn [Dandyman]: "Re: Limiting access to SQL Server 2000 for our junior developers"
- Previous message: bcrenshaw99_at_yahoo.com: "Re: Limiting access to SQL Server 2000 for our junior developers"
- In reply to: Hari Prasad: "Re: changing sa password"
- Next in thread: John King: "Re: changing sa password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
