WSUS install fails on OEM SBS 2003

Error message: "Microsoft Windows Server Update Services could not create the database"

First read http://umich2.com/archives/2005/08/25/wsus-on-an-oem-install-of-sbs2003/ to see how to get the WMSDE installed.

Then, if like me, your SBS isn't all on one Disk and you want the WMSDE database to be where WSUS was going to put it, use this (modified from How to move WSUS MSDE database files to another drive using OSQL)

Copy this to a batch file or to a command line.  This makes the assumptions:

  • WMSDE install is in default location, and instance was named WSUS
  • You want to move the DB to the default directory that WSUS would have used on "E:" drive, E:\WSUS\MSSQL$WSUS\Data

If these are not true you need only tweak the commands below to match your end goal.


net stop "update services"
net stop w3svc
cd "C:\Program Files\Microsoft SQL Server\MSSQL$WSUS\Binn"
osql -E -S %computername%\wsus -Q "exec sp_detach_db 'SUSDB'"
MD E:\WSUS\MSSQL$WSUS\Data
move "C:\Program Files\Microsoft SQL Server\MSSQL$WSUS\Data\SUS*.*" E:\WSUS\MSSQL$WSUS\Data
osql -E -S %computername%\wsus -Q "exec sp_attach_db @dbname=N'SUSDB', @filename1=N'E:\WSUS\MSSQL$WSUS\Data\SUSDB.mdf', @filename2=N'E:\WSUS\MSSQL$WSUS\Data\SUSDB_log.ldf'"
net start "update services"
net start w3svc


* Note - If you're trying to move any other MSDE database, you need to know the name. 

    osql -E -S %computername%\wsus -Q "sp_databases"

Will output this information for you.

 

If you found this document useful, please let me know - drop me a quick email.

Last updated 09/12/2005