Tuesday, November 20, 2012

Moving WSUS WID Database in Windows Server 2012

I can not guarantee this will work for you, but here is what I did when a coworker installed the WSUS database to the wrong drive. This post also assumes you know what you are doing, and are able to use SQL Management Studio 2012.


  1. Install SQL Server Management Studio 2012 (You can try Management Studio for 2008 or 2008 R2 I recieved an error when I tried initially)
  2. Run SQL Management Studio 2012 as Administrator
  3. Connect to Server Name \\.\pipe\Microsoft##WID\tsql\query (old versions used to be \\.\pipe\Microsoft##SSEE\sql\query this has changed in Server 2012 WSUS 4)
  4. Select Windows Authentication and login
  5. Expand Databases
  6. Right Click SUSDB
  7. Hover over Tasks
  8. Select Detach (Management Studio for 2008 might give you an error here)
  9. Select the Drop Connections checkbox
  10. Click OK
  11. Move the SUSDB.mdf and the SUSDB_log.ldf to the new location.
  12. Back in SQL Server Management Studio right click on Databases
  13. Select Attach
  14. Click Add
  15. Navigate to the new SUSDB.mdf location and select the mdf that is in the new location.
  16. Verify the mdf and the ldf are showing in their location properly.
  17. Click OK
  18. Verify the SUSDB database has attached and is not read-only, (if it is listed as SUSDB (Read-Only), verify the permissions on the folder and files you moved are the same as the permissions of its original location).
  19. Once reattached you should now be good to go. If things look iffy, restart Update Services/IIS Admin/WID Services, or reboot.

http://technet.microsoft.com/en-us/library/hh852349.aspx

Thursday, November 8, 2012

Installing Office 2013 Key Management Service Host on Server 2012

This installation is documented for installation using the Office Professional Plus 2013 Key Management Service Host ISO provided though the Volume Licensing Service Center, also assuming that the Volume Activation Services have been properly installed and configured on Windows Server 2012.

  1. Download the Office Professional Plus 2013 Key Management Service Host ISO from the Microsoft Volume Licensing Service Center.
  2. Copy it to the 2012 KMS server.
  3. Right click the ISO and select Mount.
  4. Run PowerShell as Administrator and navigate to the mounted ISO's root directory.
  5. Run cscript kms_host.vbs
  6. While it runs, it will open Volume Activation Tools
  7. Click Next at the Volume Activation Tools introduction screen.
  8. Select your Activation Method, enter in the FQDN if required and click Next.
  9. Click the radio option to Install your KMS host key and enter in your KMS host key.
  10. Click Commit
  11. At the info box click yes to install the new product key.
  12. Verify Activate Product is selected and click Next
  13. In the Select Product drop down you will see Office 15, VOLUME_KMS channel selected already.
  14. Choose your Activation method and click Commit.
  15. Click Yes at the This will activate the KMS host info box.
  16. View the configuration, verify it has succeeded, and click Next.
  17. If there are any options you would like to change in the configuration do so and click Commit.
  18. Click Yes to overwrite existing KMS configurations.
  19. It will then restart the Software Protection licensing service.
  20. If you are done click Close.
  21. Verify the PowerShell window indicates a successful completion, press ENTER to close.