Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
pritamb89
Contributor

SQL DB access via OLE DB Connection

Dear all,

I am facing a problem regarding access to SQL Server via OLE DB connection string.

I am able to run the applicaion manually using the service account. It has the read access to SQL Server DB.

But after deployment the access is denied when running the application from QMC.

There are some threads available on this topic but I found no solution.

Do I need to provide any other permission to my service account? Right now It has read access.

Below is the error lines.

2019-04-12 16:05:36 0020 OLEDB CONNECT32 TO *** (XPassword *** ***)
2019-04-12 16:06:40 Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
2019-04-12 16:06:40 ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
2019-04-12 16:06:40 Execution Failed
2019-04-12 16:06:40 Execution finished.

Please help. Thanks in Advance.

Labels (1)