Export (0) Print
Expand All

Change passwords for SQL Server services (Windows SharePoint Services)

Office 2007

Updated: April 19, 2007

Applies To: Windows SharePoint Services 3.0

 

Topic Last Modified: 2007-05-09

Use this procedure to change the password for the following Microsoft SQL Server 2005 services used by Windows SharePoint Services 3.0.

  • SQL Server (MSSQLSERVER) service   Used to run SQL Server. If the service is using a domain account, the password information might expire and SQL Server 2005 will not run.

  • SQL Server Agent (MSSQLSERVER) service   Used by Windows SharePoint Services 3.0 to truncate residual Windows SharePoint Services 3.0 session state information that can accumulate and affect SQL Server performance. It is also used by various other applications, including SQL Server 2005. If the service is using a domain account, the password information might expire and these applications cannot run these tasks in SQL Server 2005.

NoteNote:
These procedures can be performed only after the password has been changed on the domain controller. The credentials entered are checked against those on the domain controller. If you enter the new password before the password has been changed on the domain controller, an error will result and the settings will not be changed.
NoteNote:
To save the changes, you must restart the SQL Server service. This will cause the services that the SQL Server service provided to be momentary unavailable while the SQL Server service restarts.
NoteNote:
SQL Server 2005 services accounts and passwords are linked to Microsoft Windows user accounts and passwords. Changes in one location might require changes in the other.
ImportantImportant:
You should not change the passwords for any of the SQL Server service accounts when a failover cluster node fails or is offline. If you have to do this, you will need to reset the password again by using Configuration Manager when all nodes are back online.
ImportantImportant:
Membership in the Administrators group on the local computer, or equivalent, is required to complete the following procedures.
Change the password for the SQL Server (MSSQLSERVER) service
  1. In the Services snap-in in the Microsoft Management Console (MMC), right-click the SQL Server (MSSQLSERVER) service and then click Properties.

  2. In the Properties dialog box, on the Logon tab, type the new password in the Password and Confirm password boxes.

  3. You must restart the service for the changes to be saved. On the General tab, under Service status, click Stop to stop the service.

  4. When the service has stopped, click Start to start the service.

  5. Click OK to save the changes.

Change the password for the SQL Server Agent (MSSQLSERVER) service
  1. In the Services snap-in in the Microsoft Management Console (MMC), right-click the SQL Server Agent (MSSQLSERVER) service and then click Properties.

  2. In the Properties dialog box, on the Logon tab, type the new password in the Password and Confirm password boxes.

  3. You must restart the service for the changes to be saved. On the General tab, under Service status, click Stop to stop the service.

  4. When the service has stopped, click Start to start the service.

  5. Click OK to save the changes.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft