Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
cmorri1988
Creator
Creator

Change of Server Name - Restore RootAdmin Role on QS July / PostgreSQL

Recently I was required to change the server/computer name of an AWS instance.

The instance was using simple Windows authentication.

As the directory name is generated from the server name, the RootAdmin role was lost to the old directory name.

NEWSERVERNAME\Administrator and not NEWSERVERNAME\Administrator

To restore this I completed the following steps:

1. Remote connect to the server hosting Qlik Sense

2. Download pgAdmin4 from here:

https://www.postgresql.org/ftp/pgadmin/pgadmin4/v1.0/windows/

3. Install and launch pgadmin4

4. From the home screen, click on 'Add New Server' and populate with the connection details shown.

    Please include a database password if this was added during the installation.

pgAdmin.PNG

5. Go to:

  • Servers > Qlik Sense (or whatever you called the connection in step 4) > Databases > QSR > Schemas > public > Tables and double click on the table Users
  • right click on "View Data" > "View All Rows"

pgAdmin_tables.PNG

6. Find the user you wish to add RootAdmin rights too.

   Click on the RolesStringtext box within that user row.

   Type 'RootAdmin' and click save. Also click the floppy disk icon on the menu bar highlighted.

RootAdmin.PNG

7. Restart the repository service.

---------------------------------------------

N.B. If you are having issues connecting the QMC and Hub prior to this step,

1. Stop the repository services

2. Delete your certificates in MMC

3, Ensure the string within host.cfg file stored at C:\ProgramData\Qlik\Sense (once decrypted using base 64 here: https://www.base64decode.org/) shows the correct and current server name.

4. Perform a repair from the program list and Qlik Sense on your server, and restart all Qlik Sense services.

Hope this helps,

Carmelle

0 Replies