Unable to load database

[Anonymous]

I am establishing OLE DB connection to SQL DB using windows authentication..

1. Test connection - successful

2. Load DB - Successful and able to select DB.

But...

When tried using a different credentials after changing the connection stings's integrated security value as False...

1. Test Connection - Successful.

2. Load DB - It was just revolving and nothing happening even after 1 hour. Unable to select the DB as a result.

I have tried in both QV 11 and Qlik Sense. Suggestions please.

[Anonymous]

Hi,

- Please open SSMS  and check if the user has appropriate privileges.

            WHILE USING OLEDB :

            -to login with sqlserver authorization using valid credentials.

            -not to change any settings (eg: true-> false)

            ...

If you still get a problem, he can test the same by using some ODBC connection.

Regards

Allu