PostgreSQL Repository user contains capital letters

If during the Qlik Sense installation we set up a repository user that contains capital letters then the installation will not work and we will no be able to access the QMC and HUB.
Plus, we will see an error on the application Event Viewer logs like:

FATAL:  password authentication failed for user "QlikTest"
DETAIL:  Role "QlikTest" does not exist.
    Connection matched pg_hba.conf line 82: "host    all             all             ::1/128                 md5"

 

The PostgreSQL converts the username introduced during the installation to a one which only uses lowercase letters. So, as the string uses the one with capital letters the connection does not work and we can not access the QMC and HUB.

Change the username used in the connection string from the current one (with capital letters) to the same one, but only using lowercase letters. In our example, from QlikTest to qliktest.

In order to change the connection string following the next steps:
 

Open the QlikSenseUtil.exe application (C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe, by default)   Hit on the "Connection String Editor" and "Read". In this example we would see:   <connectionStrings>     <add name="QSR" connectionString="User ID=QlikTest;Host='localhost';Port='4432';Database=QSR;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;Password='password';" providerName="Devart.Data.PostgreSql" />     <add name="postgres" connectionString="User ID=postgres;Host=localhost;Port=4432;Database=postgres;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;" providerName="Devart.Data.PostgreSql" /> </connectionStrings> Change the User ID to a lowercase one: <connectionStrings>     <add name="QSR" connectionString="User ID=qliktest;Host='localhost';Port='4432';Database=QSR;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;Password='password';" providerName="Devart.Data.PostgreSql" />     <add name="postgres" connectionString="User ID=postgres;Host=localhost;Port=4432;Database=postgres;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;" providerName="Devart.Data.PostgreSql" /> </connectionStrings> Hit "Save Value in config file encrypted". After saving the change, restart the Qlik Sense services.