Uninstall SQL from Principal Server

Problem:

After you migrate Pharos database out of Uniprint Principal server, you need to uninstall SQL server from the Principal server. However, removing SQL server components cause Pharos Database Server service to not start up.

Environment:

Uniprint 9.1 and older.

Solution:

1. Open Windows Service Console
2. Open Properties of Pharos Database Server service.
3. Click Dependencies tab and verify that the SQL Server is no longer a dependency from Pharos Database Server service.

If the SQL server dependency is shown as in the screenshot above, follow steps below to remove it:

1. Open Windows Registry.
2. Browse to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PSDatabaseSvr
   
3. Right click on DependOnService and click Modify.
4. Delete the highlighted line shown in screen shot below.

*MSSQL$SQLEXPRESS for SQL Express version
*MSSQLServer for Standard SQL Server version