Re-installing Monitoring on Small Business Server 2003 Sp2

I had to re-install WSUS 3.) Sp2 and Monitoring on my SBS 2003 server after it broke when I tried to upgrade WSUS fro version 3.0 Sp1 to 2.0 Sp2.

These are the steps I followed:

Steps to Re-install SBS Monitoring

1. Control Panel -> Add Remove Programs -> Windows Small Business Server 2003 -> Change Remove ->
Set Server Tools to Maintenance. Set Monitoring to Remove and continue the setup process.

2. Control Panel -> Add Remove Program -> Microsoft SQL Server Desktop Engine (SBSMonitoring) -> Remove.

3. Delete IIS Virtual Directory

Open IIS, expand servername, Web Sites, Default Web Site
Deleted Monitoring. Backed up files in the virtual directory first.

4. Renamed the C:\program files\Microsoft SQL Server\MSSQL$SBSMONITORING Folder.

5. Deleted the registry keys relating to Monitoring

A. Deleted HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Monitoring
B. Deleted HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL

6. Reboot the server.

7. Control Panel -> Add Remove Program -> Windows Small Business Server 2003.
Set Server Tools to Maintenance. Set Monitoring to Install and continue the setup process. I had an error message that

the system was unable to install MS SQL SP4. An error showed up on the install option.

8. 6. Rebooted the server.

9. 7. MSSQL$SBSMONITORING and SQLAgent$SBSMONITORING services started up on reboot.

10. 8. In Server Management Console -> Monitoring and Reporting: run the “Set Up Monitoring Reports and Alerts wizard”

Monitoring is now running but I have two errors relating to it in my system log file.

These are:

Event ID 120

The report server cannot decrypt the symmetric key. Most likely, the service account or password has changed. To continue, run rsconfig.exe to update the report server account information.\r\n
Event ID 140

The application domain WindowsService_5 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.KeyStateNotValidException: The report server cannot access the private key for the service account. This key is used to decrypt the symmetric key that protects content in the report server database. This condition might occur after the password is reset for the report server service account. You must either restore a backup key or delete all encrypted content. —> System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at RSManagedCrypto.RSCrypto.ExportPublicKey() at Microsoft.ReportingServices.Diagnostics.DataProtection.PreparePublicKey(Boolean repair) at Microsoft.ReportingServices.Library.ConnectionManager.<GetEncryptionKey>b__2() — End of inner exception stack trace — at Microsoft.ReportingServices.Library.ConnectionManager.<GetEncryptionKey>b__2() at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state) at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state) at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback) at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart).

I tried using the RSKeyMgmt tool but it just could not find the instance of MS SQL server on my machine. i.e <severname>\SBSMonitoring If any one has some bright ideas, I’d be happy to hear from them.

WSUS 3.0 SP2 installed without any problems after this.