Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-02-12 07:36 AM

Unable to load database

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.

355 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2015-03-16 08:59 AM
Author

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

251 Views
0 Likes