Discussion Board for collaboration on QlikView Management.
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.
Go to Solution.
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.
Your service account needs access to the MSSQL database also.
Unfortunately i am runnig the services from a local account and my MSSQL server account not able to see this local account.
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.
OLE DB works with the local MSSQL credentials. ]