topic Re: Selected database is not a Publisher database - QV11SR1 in QlikView

Selected database is not a Publisher database - QV11SR1

Mon, 26 Jan 2026 18:19:17 GMT

I have just stood up QV11SR1 within our environment. I am trying to migrate from the XML repository to the SQL Server repository in order to alleviate performance constraints due to the number of publishers we have in our environment. The SQL server version is 2008 (10.0.4000).

After setting up the connection information and clicking the "migrate" check box I receive this error: Selected database is not a Publisher database. I then have to restart QMC on the publisher box and everything reverts back to the XML repository.

I have been able to connect directly to the SQL server from the QV Publisher server and have been able to connect using the service account for QV successfully.

Any thoughts or ideas would be appreciated.

Charlie

Re: Selected database is not a Publisher database - QV11SR1

Miguel_Angel_Baeyens — Wed, 05 Sep 2012 07:25:50 GMT

Hi,

Is the user running QlikView or assigned to QlikView services granted permissions to create databases, tables and so in the SQL Server? Does the SQL Server Windows Authentication enabled?

Hope that helps.

Miguel

Re: Selected database is not a Publisher database - QV11SR1

Wed, 05 Sep 2012 13:09:29 GMT

I spoke with Bill Britt at QlikView about this issue and apperantly QlikView has to create the database itself rather than use a pre-defined database.