Reset SA password

I have a need to reset the SA password on our SQL 2000 SP4 Server. Only one
production database is on this server and I've confirmed with the vendor
that the database is not using the SA account for anything.
Under Security, login, I see that I can r/c on SA and change the password
there.
Is that OK to do?
What's the impact of changing the SA password?
Anything else that I'm not thinking of'
Thank you!
RandyHi
Take a look atv sp_password stored procedure in the BOL
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Hi Randy
If you are 100% sure that, none of your application or users are using sa
password then you can change it.
You can use sol profiler to trace wheather some one is using it or not
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Not sure what that means...sql n00b here...
but thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2O%23aEFqHHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi
> Take a look atv sp_password stored procedure in the BOL
>
>
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>|||Thanks, I will use profiler to check that out.
If no one or nothing is using SA, changing the password during production
hours won't affect anything?
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>|||I guess that I'm looking for SA in the LoginName or NTUserName Column?
I've been running it for five minutes, and never saw SA scroll by . . .
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>|||Hi Randy
It should be ok to change the SA password as you've suggested (I believed
from the Enterprise Manager?), as long as you are doing it using another
user with the sys admin permission on the SQL Server. As far as the impact,
I believe that as long as the sa account is not being used for any jobs or
application (which it should not as part of best practice), then I can't see
it have any major impact.
Thank you
Lucas
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Thank you for the input!!
I plan to change the password today.
Thanks again!
"Lucas Kartawidjaja" <luke_k@.hotmail.com> wrote in message
news:uSlN2AeqHHA.4100@.TK2MSFTNGP06.phx.gbl...
> Hi Randy
> It should be ok to change the SA password as you've suggested (I believed
> from the Enterprise Manager?), as long as you are doing it using another
> user with the sys admin permission on the SQL Server. As far as the
> impact, I believe that as long as the sa account is not being used for any
> jobs or application (which it should not as part of best practice), then I
> can't see it have any major impact.
> Thank you
> Lucas
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>