password change

[John M]

We have a need (for security purposes) to change the Admin password on our
Server 2000 machines. The question is will the password change have any
affect on SQL 2000? In the past with older machines (we are not a very
advanced company) once we change the adminpassword, sql would not start.

 

[Dave Patrick]

Only if you're starting up some of these sevices with local administrator
account. The articles below may also help.


SQL Server (MSSQLSERVER) -
SQL Server Active Directory Helper - NT AUTHORITY\NetworkService
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Services (MSSQLSERVER) - Local System
SQL Server Browser - Local System
SQL Server FullText Search (MSSQLSERVER) - Local System
SQL Server Integration Services - NT AUTHORITY\NetworkService
SQL Server Reporting Services (MSSQLSERVER) - Local System



Service Account Types Supported for SQL Server Agent
http://msdn.microsoft.com/en-us/library/ms345380(SQL.90).aspx

http://support.microsoft.com/kb/283811

http://msdn.microsoft.com/en-us/library/ms143504(SQL.90).aspx



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

 

[Dave Patrick]

"start with the O/S"

I don't know what this means. If you mean start with the local administrator
account then you must also change the service start password.

For SQL Server 2000
Start|Run|services.msc

For SQL Server 2005 (or later)
Start|Run|SQLServerManager.msc




--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect