Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think its a very simple issue , but I really failed to find the reason for it!!
Its working fine... I have connected SQL server through ODBC Connection using OLE DB service provider. It accepts SQL authentication.
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
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.)
Its working fine... I have connected SQL server through ODBC Connection using OLE DB service provider. It accepts SQL authentication.