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.
This question would be best answered by your SQL Server Database Administrators, as they are the experts here and should know if you need additional configuration on the SQL side to allow connection from the service account running as a service. When things run as a 'service', this can require additional security configuration in the SQL side, but again, the DBA's would know that for sure. Hope this helps you get things resolved if you have not figured it out at this point.
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.