Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
pradeepvaddirbc
New Contributor

OLEDB connection error in Windows 2012 SR2 Server QlikView

Hi Greetings,

While connecting to SQL server from Qlikview 11.2 Windows 2012 SR12  getting below error, and help me to resolve it.

Error: ErrorSource: Microsoft OLE DB Driver for SQL Server, ErrorMsg: The server principal "qlikview" is not able to access the database "Client_Submission" under the current security context.

Attached the error screenshot. 

Thanks in advance.

/PR

2 Replies
Highlighted
Support
Support

Re: OLEDB connection error in Windows 2012 SR2 Server QlikView

Hi @pradeepvaddirbc 

 

This is not a QLik product related issue, have you tried to connect to the DB from another client?

I found this article, hope it helps:

 

https://blogs.technet.microsoft.com/mdegre/2010/08/28/the-server-principal-sqlloginname-is-not-able-...

 

Kind Regards.

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
Highlighted
Digital Support
Digital Support

Re: OLEDB connection error in Windows 2012 SR2 Server QlikView

Pradeep, Nadia was correct in her post, were you able to sort out the root cause?  If so, please consider posting what it was, and you can then mark that as the solution as well using the Accept as Solution button after you post things to let others know what it was.  

Based upon the screenshot, it would appear things were wanting a secure connection, and I am guessing there was a missing client certificate etc. that was needed to be installed on the machine from which you were trying to make the connnection...

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.