Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Highlighted
anilguptaopera
New Contributor II

MSSQL Data Import

I am importing data from an MSSQL table, which i connect using the System DSN.

Everything looks good, i am able to update the sheet with relevent data. But when i try to reload the data using the Reload option in Task Publisher. It gives an error.

Error: SQL##f - SqlState: 28000, ErrorCode: 18452, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.

30/01/2015  2:53:06 AM:       General Script Error

30/01/2015  2:53:06 AM:       Execution Failed

30/01/2015  2:53:06 AM:      Execution finished.

Please help.

Tags (2)
1 Solution

Accepted Solutions

Re: MSSQL Data Import

The account running the QlikView Distribution Service does not have permission to access your database.

Either add the service account with permissions to your database, or if your server has mixed mode authentication, create a new SQL login and use that login to connect.

I would recommend using ADO (OLEDB) to connect to MSSQL rather than ODBC as the connection details are embedded in the QV app, and you do not need to create a separate DSN.

5 Replies

Re: MSSQL Data Import

The account running the QlikView Distribution Service does not have permission to access your database.

Either add the service account with permissions to your database, or if your server has mixed mode authentication, create a new SQL login and use that login to connect.

I would recommend using ADO (OLEDB) to connect to MSSQL rather than ODBC as the connection details are embedded in the QV app, and you do not need to create a separate DSN.

Partner
Partner

Re: MSSQL Data Import

Your service account needs access to the MSSQL database also.

anilguptaopera
New Contributor II

Re: MSSQL Data Import

Unfortunately i am runnig the services from a local account and my MSSQL server account not able to see this local account.

Re: MSSQL Data Import

You need to ask your DBA to grant the service account permission to read the database.

The server is reloading data using the service account credentials, not your credentials.

Otherwise change the server DSN to use a login that has permission to the database.

anilguptaopera
New Contributor II

Re: MSSQL Data Import

OLE DB works with the local MSSQL credentials. ]

Thanks mate.