Changing NT Passwords used by SQL Server

Dear All,
Our Server department would like to change the passwords
of our Domain User accounts used by SQL Server and SQL
Server Agent Accounts.
Can anyone tell me the impact of this and whether we need
to do anything at the SQL end.
Regards
Peter
Hi,
After changing the password of the domain os user account, you need to
change the password entry in
control panel -- Admin tools -- services -- MSSQL server (double click
miuse) -- go to "Log on" tab-- type the new password and restart the MSSQL
server service
Do the same for SQL Agent service as well.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter
|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#hkuRfBYEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After changing the password of the domain os user account, you need to
> change the password entry in
> control panel -- Admin tools -- services -- MSSQL server (double click
> miuse) -- go to "Log on" tab-- type the new password and restart the
MSSQL
> server service
I am not completely sure but I do not think that you have to restart
MSSQL server service.

> Do the same for SQL Agent service as well.
>
> --
> Thanks
> Hari
> MCDBA
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:2511801c46015$9f076c20$a401280a@.phx.gbl...
>
|||To get to the SQL AGent login in SEM right click SQL Agent and go to
properties...
I have heard of an issue with changing the password on the full text index
search service, that requires special attention, but I do not remember the
details... It seems like as long as you set the login/password via SEM
things worked, but if you did it via windows services, there was a
disconnect somehow... You might want to google it.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter
|||Thanks for all your responses, you have told me what I
need to know.
Peter

>--Original Message--
>Dear All,
>Our Server department would like to change the passwords
>of our Domain User accounts used by SQL Server and SQL
>Server Agent Accounts.
>Can anyone tell me the impact of this and whether we need
>to do anything at the SQL end.
>Regards
>Peter
>.
>