Products
Webtrends Analytics 8.x
Webtrends Analytics 9.x
Issue
A Webtrends installation using Microsoft SQL Server as the system database was uninstalled but the Services snap-in still lists the MSSQLSERVER or SQLSERVER(MSSQLSERVER) service when it should no longer be present.
Resolution
The SQL instance is populated in Services via the registry. Follow the steps below to remove these registry keys:
1. Go to Start > Run > and type “regedit” to open the registry editor.
2. Locate and delete the following keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper
The three registry keys that follow correspond to the default instance of Microsoft SQL Server 2000. Named instances appear similar to those listed, along with $instance_name, because instance_name is the name given to that particular instance. After locating the correct keys for the instance to be removed, select those keys and then delete them.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper
For 8.7d+, the instance name will be WTSYSTEMDB. Use F3 to search the registry for that value and remove the folders.
How to remove all known instances of SQL Server
http://support.microsoft.com/kb/290991#4