Administrator Guide

• SQL Server (SQLIN01)
• SQL Server (SQLIN02)
• SQL Server Agent (SQLIN01)
• SQL Server Agent (SQLIN02)
Figure 53. SQL instances
e Open the properties for each service, select the Log On tab, change the password, and click OK.
f Once the password has been changed for each service, open Failover Cluster Manager, and then connect to the SQL cluster,
< Prex >SQLCL.
g Select Nodes, right-click on the rst node, <Prex>SQL01, and select Pause > Drain Roles.
h Restart the node, and once it is back in a paused state you can proceed to right-click on the node, and select Resume > Fail
Roles Back.
i Continue with the next node, < Prex >SQL01, from step c onward.
3 Reset the VMM service account password, as follows:
a Launch Active Directory Users and Computers , and locate the SQL service account, < Prex >-SVC-VMM.
b Right-click and select Reset Password to open a dialog where you can type a new password. Deselect User must change
password at next logon before clicking OK.
c Open the Services console (services.msc), and connect to the VMM server, < Prex >VMM01.
d Locate the System Center Virtual Machine Manager service.
Figure 54. System Center Virtual Machine Manager service
e Open the properties for the service, select the Log On tab where you can change the password, and then click OK.
f Right-click once more, and select Start to start the VMM service.
4 Reset the System account password in Active Directory, Service Management Automation (SMA), and VMM by doing the following:
a Launch Active Directory Users and Computers, and locate the System service account, < Prex >-System.
b Right-click and select Reset Password to open a dialog where you can type a new password. Deselect User must change
password at next logon before clicking OK.
c Next, run the Set-SmaCredential cmdlet to set the matching password in SMA.
Set-SmaCredential -Name "<Prefix>-System" -Value (Get-Credential) -WebServiceEndpoint
https://<endpoint>
For example, where < Prex > equals IPS, and <endpoint> equals < Prex >APA01, the command is as follows:
Set-SmaCredential -Name "IPS-System" -Value (Get-Credential) -WebServiceEndpoint https://
IPSAPA01
d When prompted for credentials, enter the System service account username, and enter the password that you used in step b.
e Next, open the VMM management console, and connect to the VMM server, < Prex >VMM01.
f In the Settings workspace, expand Security, and then select Run As Accounts.
Security
119