Re: SQL Server 2000 and Service Account Password



Bill
Yes , you are going to restart the service after changing the password

"Bill" <Bill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB582621-5806-45B7-A0D5-E8DA7E3A3860@xxxxxxxxxxxxxxxx
Hello,

We have several SQL 2000 servers running on Windows 2000 and Windows
2003 with the same AD account. We have been requested to change the AD
account password.

We were planning on changing the AD account password and then going to
each server and changing the SQL Service and SQL Agent service password
using
Enterprise Manager. Do we need to restart SQL Server after we change the
password. Will it stop running at some point if the account it is running
under has a different password then the AD password. Or does it not
matter
and it only takes the password into affect when you restart the services.
This is important because I need to know if we need to let the users we
will
have a down time since we may have to restart the services after password
change. In either case, can anyone point me to some documenation so that
I
can use that.

Thanks,
Bill



.



Relevant Pages

  • Re: SQL Server and Reboot SBS
    ... The server only restarts when trying to start SQL after a manual stop/start ... A critical system process, C:\WINDOWS\system32\lsass.exe, failed with status ... The process winlogon.exe has initiated the restart of computer SBS on behalf ...
    (microsoft.public.windows.server.sbs)
  • Re: Scheduled Backup for SQL Database
    ... and the service does restart ok. ... >> For some reason the SQL agent under server management does not restart ... Only problem is when the SQL server ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Update failures
    ... The initial release of SQL Server 2005 Service Pack 2 contained an ... you may have to restart your computer. ... this morning my SQL Server would not respond - the server was up but ... I restarted the server and noticed critical updates ...
    (microsoft.public.windowsupdate)
  • Re: ssl renewal questions
    ... Just on the server which I guess explains the clients being able to ... the certificate is invalid ... >> but connections continue to be encrypted and restarts of sql ... >>> appears that I had to stop and restart the sql process to get certs ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)