Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

ODBC Connection to SQL Server

Hi all,

I'm Trying to connect from my Local Machine to SQLServer database  (Which is located in another server) using another ActiveDirectory ID.

When Creating DSN's , i think we can't edit the AD Account Details .

Let me know is there a way to Connect

Thanks in Advance

Capture.JPG

Tags (2)
3 Replies
MVP
MVP

Re: ODBC Connection to SQL Server

Hi

I don't think you need to (or can) set the AD account on a DSN. The AD option uses a trusted connection, which is your account (or if the DSN is used from a service - such as QVS - the service account). So it is unnecessary to set the account because the account is determined by the calling context, not the DSN.

The options that are grayed out are for SQL Server authentication (and are not AD related).

If you cannot connect to the server, then you need to change the login permissions for the account on the SQL server.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: ODBC Connection to SQL Server

Thanks Jonathan,

But I can't login using my NT ID, as i'm logging through Remote ,

I have to use their Id/ Password to access the Server and database.

Any suggestions on how to connect  ?

Thanks

MVP
MVP

Re: ODBC Connection to SQL Server

Trusted connection will use the credentials that you logged into the remote computer. The DSN is not affected, but the SQL Server must permit access to the remote login credentials.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser