Moving a WSUS 3.0 Database
Due to seemingly non-existant documentation on moving a WSUS 3.0 database to a new server, I figured i’d write up my experience.
Database configuration is all stored in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\UpdateServices\Server\Setup
The keys you’re interested in are SqlServerName and SqlInstanceIsRemote. Microsoft only officially support Windows authentication, so that’s what i’ll cover here.
You’ll be able to connect the the Windows Internal Database using Microsoft SQL Server management studio Express (a free download), detach the database and re-attach on your new SQL server.
Once that’s done, add the computer account of the WSUS server as a database login (e.g. nwtraders\LONDON$) and give it the dbowner role on the SUSDB.
The last step is to set the SqlServerName and SqlIsRemote values as mentioned earlier. Once done, restart IIS and the UpdateServices service. Job done.
[…] across a problem when upgrading to WSUS SP1 earlier today. If you’ve moved your WSUS database as per my post your upgrade will fail with the […]
Thank you!!!