topic Unable to load database in QlikView

Unable to load database

Anonymous — Thu, 12 Feb 2015 12:36:49 GMT

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 — Mon, 16 Mar 2015 12:59:25 GMT

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