Archive for the 'WSUS' Category

Migrate WSUS Database from Domain Controller to SQL 2005

Okay, so I had made a newbie mistake when installing WSUS into our environment about a year ago. This may occur if you have a limited number of machines for running a small network.

I installed WSUS on top of a domain controller. Everything seemed to work fine in this configuration; however, I wanted to move the database to another SQL Server so that I could better automate reporting of which systems have which updates, etc. Turns out, that it is not very straight forward on how to move the database from a domain controller to another SQL server.

Here is my solution.

I followed the instructions here, but had to modify them slightly.

Migrate WSUS from Local SQL  to Remote SQL Server

The first modification was to ATTEMPT to install SQL Server database services. This install sqlcmd.exe which will be needed for the procedure listed above. Since it is on a domain controller, the SQL Server install will fail.

Once you get to the message above, just hold your horses and switch to a command prompt after having stopped Windows Update Services and the IIS Admin service.

Execute the command listed in the Microsoft article.

Reattach the database on the remote system.

Add the machine account in SQL Server (e.g., DOMAINAME\machinename$) to the SUSDB. Make sure the role is as the Microsoft article suggested.

Next edit the registry as the article suggested. I added my remote server name, and there was one additional key that I changed to a 1. The key was named something like ServerIsRemote with a value of 0. I changed that to a 1.

Rebooted the front end WSUS server and everything worked like a champ after that.