topic Re: Unable to connect SQL Server - &quot;Username not found error&quot; in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761142#M1583 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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).</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Fri, 09 Jan 2015 09:53:51 GMT jonathandienst 2015-01-09T09:53:51Z Unable to connect SQL Server - "Username not found error" https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761141#M1582 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><IMG alt="error1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/74954_error1.PNG" style="height: auto;" /><IMG alt="error.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74950_error.PNG" style="font-size: 10pt; line-height: 1.5em; height: 96px; width: 620px;" /><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P></P><P>I think its a very simple issue , but I really failed to find the reason for it!!</P></BODY></HTML> Fri, 09 Jan 2015 09:42:00 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761141#M1582 2015-01-09T09:42:00Z Re: Unable to connect SQL Server - "Username not found error" https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761142#M1583 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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).</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Fri, 09 Jan 2015 09:53:51 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761142#M1583 jonathandienst 2015-01-09T09:53:51Z Re: Unable to connect SQL Server - "Username not found error" https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761143#M1584 <HTML><HEAD></HEAD><BODY><P>Sorry I'm not exactly getting your point.&nbsp; 'We need to enter the SQL Server authentication user id and pwd in Qlikview 'right!!</P><P></P><P>(Note : I had mentioned- server IP address , sql authentication user name and pwd.)</P></BODY></HTML> Fri, 09 Jan 2015 10:01:42 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761143#M1584 2015-01-09T10:01:42Z Re: Unable to connect SQL Server - "Username not found error" https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761144#M1585 <HTML><HEAD></HEAD><BODY><P>Its working fine... I have connected SQL server through ODBC Connection using OLE DB service provider. It accepts SQL authentication. </P></BODY></HTML> Fri, 09 Jan 2015 11:00:10 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Unable-to-connect-SQL-Server-quot-Username-not-found-error-quot/m-p/761144#M1585 2015-01-09T11:00:10Z