Skip to main content

Qlik

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: 
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: 
Not applicable
‎2012-10-10 02:49 AM

ODBC connection with different user

Hi all,

hope someone can help me on this topic.

I have a windows 7 server and created a ODBC connection to a sql-server.

For the login into Windws we have to use a different user than for using the ODBC connection. The windows user has no rights to connect to the sql-server.

therefore I have to use a different user for the ODBC connection.

Is it possible to integrate a user in the Qlikview ODBC connection ?

Many thanks in advance for your help.

Best regards

Markus

4,162 Views
0 Likes
1 Reply
Miguel_Angel_Baeyens
Employee
Employee
‎2012-10-10 04:01 AM

Hi Markus,

QlikView calls Windows when you click on the Connect or Select button and ODBC is selected, so it all depends on how you OS is configured. If you set up any DSN, you can specify the username and password within the DSN, so the users don't need to know them. But if you mean you are connecting to a MS SQL Server using integrated Windows Authentication, in the ODBC Wizard you cannot set which user you want to use, so credentials used are those from the user actually logging on to the computer.

Hope that helps.

Miguel

EDIT: Reviewed

1,164 Views