Out of the box, Qlik Sense installs the Qlik Sense Repository Database to store the meta-data content used by Qlik Sense to function. As a site matures, the architectural needs may shift and instead customers may opt to run Qlik Sense from a stand-alone PostgreSQL (https://community.qlik.com/t5/Knowledge-Base/How-to-move-Qlik-Sense-database-to-standalone-PostgresS...). After making this change, there will still be a Qlik Sense Repository Database Service. This article outlines how to remove that service from the Windows OS.
Environment:
Qlik Sense Enterprise on Windows any version
Resolution:
Start a command prompt with elevated administrator permissions.
Execute the following:
sc config QlikSenseRepositoryDatabase depend= /
sc config QlikSenseRepositoryService depend= /
After these two steps start the Qlik Repository service without starting the Qlik Repository Database Service and see if all is working as expected. To delete the Database Service run the following command:
sc delete QlikSenseRepositoryDatabase
If you delete the QlikSenseRepositoryDatabaseService you need to prevent it from comming backing back in a future upgrade, you need to rename C:\ProgramData\Qlik\Sense\Repository\PostgreSQL to e.g. C:\ProgramData\Qlik\Sense\Repository\oldPostgesSQL.
Please note that the last step is optional, it is also possible to just set the startup type of the service to manual, so you have a fallback option if you want to move back from the standalone database to the internal one.
sc config "QlikSenseRepositoryDatabase" start=demand
