Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Unable to connect SQL Server - "Username not found error"

I connected to database through OLE DB service provider using SQL Client 10. Connection with DB shown as Successful but it throws me an error msg stating 'The user is not trusted to the SQL Server' (failed to server authentication) I clueless about this issue...Why its failed!! I used the same authentication with SQL Server it works well.

error1.PNGerror.PNG

I think its a very simple issue , but I really failed to find the reason for it!!

1 Solution

Accepted Solutions
Not applicable

Re: Unable to connect SQL Server - "Username not found error"

Its working fine... I have connected SQL server through ODBC Connection using OLE DB service provider. It accepts SQL authentication.

3 Replies
MVP
MVP

Re: Unable to connect SQL Server - "Username not found error"

Hi

They don't look like the same credentials - the test is with an explicit user name, while the QV model is trying to use a trusted connection (using your network login).

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Unable to connect SQL Server - "Username not found error"

Sorry I'm not exactly getting your point.  'We need to enter the SQL Server authentication user id and pwd in Qlikview 'right!!

(Note : I had mentioned- server IP address , sql authentication user name and pwd.)

Not applicable

Re: Unable to connect SQL Server - "Username not found error"

Its working fine... I have connected SQL server through ODBC Connection using OLE DB service provider. It accepts SQL authentication.

Community Browser