Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
Able to login through NT ID,but not through loginid and password into sql server database!
i'm getting the folowing error " Test connection failed because of an error in intializing provider login failed for user xxxx(user loginid)"
could u p[ls help any one!!!
thx
I think this is not a qlikview problem. You will need to ask your database administrator for help to resolve this issue. Possibly the SQL Server does not allow login by user/password, but only allows Windows authentication mode. Perhaps you need to tell the oledb driver to use integrated security. Put Integrated Security=true; in the connection string (if you didn't select that option when setting up the connection).
I think this is not a qlikview problem. You will need to ask your database administrator for help to resolve this issue. Possibly the SQL Server does not allow login by user/password, but only allows Windows authentication mode. Perhaps you need to tell the oledb driver to use integrated security. Put Integrated Security=true; in the connection string (if you didn't select that option when setting up the connection).