When trying to start the Qlik Sense Repository Database you are getting
"The Qlik Sense Repository Database service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."
If you look at the Windows Event logs -> Application you will see an error from PostgreSQL "PANIC: could not open control file "global/pg_control": Permission denied"
This problem usually occurs when you change the service account running the Qlik Sense Repository Database service for a dedicated one.
This can also occur if the database files are marked as Read Only, which can happen as a result of permissions inheritance in the file system.
To fix this:
- On the database server navigate to the postgres directory (if installed with Qlik Sense it will be located at %ProgramData%\Qlik\Sense\Repository\PostgreSQL\9.6)
- Select all
- Click Properties
- Uncheck Read Only
- Click Apply
- Ensure Apply Changes to the selected items, subfolders and files is select
- Click OK
- Restart the Database service
The Qlik Sense Repository Database service needs to run with Local System account.
So you need to right click on the service -> Press Properties
-> Go to Log On
tab -> Select the box Local System Account
You should now be able to start the Qlik Sense Repository Database service