Hi,
Please see the steps as below:
1) Click Start, point to Programs, point to Administrative Tools, and then click Services.
2) Right-click on the SMS_EXECUTIVE server and click Stop.
3) Right-click on the SMS_SITE_COMPONET_MANAGER and click Stop.
4) Right-click IIS Admin Service, and then click Stop.
5) Right-click Update Services, and then click Stop.
6) On the old SQL server, DETACH the SUSDB database.
7) Copy the database files (MDF and LDF) from the old SQL server to the new SQL server. (Make a backup copy of these files as well.)
8) Attach the database files as SUSDB to the new SQL server.
a. Verify permissions on the SQL Server instance. In SQL Server Management Studio, open the instance and select Security, then Logins. The NT AUTHORITY\NETWORK
SERVICE account should be listed as a login. If it is not, it should be added.
b. Verify permissions on the database. Right-click the database, select Properties and then click Permissions. The NT AUTHORITY\NETWORK SERVICE account
should be listed as a login. If it is not, it should be added.
c. Verify members of the webService role. Under the WSUS database, select Roles, then right-click webService and select Properties. The NT AUTHORITY\NETWORK
SERVICE account should be listed as a member of this role. If it is not, it should be added.
9) Back on the WSUS server, open the registry editor: Click Start, click Run, type regedit, and then click OK
10) Browse to HKLM\SOFTWARE\Microsoft\UpdateServices\Server\Setup\SqlServerName, and in the Value box, type [ServerName]\[InstanceName],and then click
OK. If the instance name is the default instance, then simply type [ServerName].
9) Click Start, point to Programs, point to Administrative Tools, and then click Services.
11) Right-click IIS Admin Service, and then click Start.
12) Right-click Update Services, and then click Start.
13) Right-click on the SMS_SITE_COMPONET_MANAGER and click Start.
14) In Administrative Tools click Microsoft Windows Server Update Services 3.0 SP1 to open the WSUS console.
15) Verify that you can synchronize updates through SCCM.
Regards,
Sabrina
This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question.
This can be beneficial to other community members reading the thread.
