Change SA Password

Been asking about changing the SA password, and still have another question.
I have confirmed that our production database is not using SA for anything.
I need to change the SA password.
After I change the SA password, do I need to restart SQL? or any services to
verify that SQL is going to work after the password change?
TIA
RandyH wrote:
> Been asking about changing the SA password, and still have another
> question.
> I have confirmed that our production database is not using SA for anything.
> I need to change the SA password.
> After I change the SA password, do I need to restart SQL? or any
No

> services to verify that SQL is going to work after the password change?
Unless the SQL Agent uses sa (not the best idea anyway,) no.
|||Thank you, just making sure I don't break anything before I do this.
"Yura Shalak" <yuras@.nospam.nospam> wrote in message
news:ublBITRqHHA.3372@.TK2MSFTNGP03.phx.gbl...
> RandyH wrote:
> No
>
> Unless the SQL Agent uses sa (not the best idea anyway,) no.
|||Thank you, just making sure I don't break anything before I do this.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:%23%23F5eTRqHHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi
> to change the sa password
> use sp_password or you can do it through EM
> After I change the SA password, do I need to restart SQL? or any services
> to
> verify that SQL is going to work after the password change?
> NO
>
> Regards
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:FA60C602-ABF6-4503-AB48-8BCF64CF4CC3@.microsoft.com...
>
|||No need to restart sql server. Since SA username is not used internally by
SQL Server for any thing there is no need to verify anything. But
make sure that all the applications connecting to sql server which used the
SA user name and password needs to be updated and tested.
Thanks
Hari
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:FA60C602-ABF6-4503-AB48-8BCF64CF4CC3@.microsoft.com...
> Been asking about changing the SA password, and still have another
> question.
> I have confirmed that our production database is not using SA for
> anything.
> I need to change the SA password.
> After I change the SA password, do I need to restart SQL? or any services
> to verify that SQL is going to work after the password change?
> TIA
|||Thanks Hari!
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OYPhu2WqHHA.3356@.TK2MSFTNGP03.phx.gbl...
> No need to restart sql server. Since SA username is not used internally by
> SQL Server for any thing there is no need to verify anything. But
> make sure that all the applications connecting to sql server which used
> the SA user name and password needs to be updated and tested.
> Thanks
> Hari
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:FA60C602-ABF6-4503-AB48-8BCF64CF4CC3@.microsoft.com...
>