topic Re: MSSQL Data Import in QlikView

MSSQL Data Import

anilguptaopera — Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: MSSQL Data Import

Colin-Albert — Tue, 03 Feb 2015 07:23:32 GMT

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.

Re: MSSQL Data Import

jerrysvensson — Tue, 03 Feb 2015 07:24:55 GMT

Your service account needs access to the MSSQL database also.

Re: MSSQL Data Import

anilguptaopera — Tue, 03 Feb 2015 07:28:06 GMT

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

Colin-Albert — Tue, 03 Feb 2015 07:33:11 GMT

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.

Re: MSSQL Data Import

anilguptaopera — Tue, 03 Feb 2015 07:49:35 GMT

OLE DB works with the local MSSQL credentials. ]

Thanks mate.