Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anilguptaopera
Partner - Contributor II
Partner - 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.

1 Solution

Accepted Solutions
Colin-Albert

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.

View solution in original post

5 Replies
Colin-Albert

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.

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Your service account needs access to the MSSQL database also.

anilguptaopera
Partner - Contributor II
Partner - Contributor II
Author

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

Colin-Albert

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
Partner - Contributor II
Partner - Contributor II
Author

OLE DB works with the local MSSQL credentials. ]

Thanks mate.