topic ODBC Connection to SQL Server in QlikView

ODBC Connection to SQL Server

Thu, 08 Nov 2012 04:08:52 GMT

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

Re: ODBC Connection to SQL Server

jonathandienst — Thu, 08 Nov 2012 06:15:23 GMT

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

Re: ODBC Connection to SQL Server

Thu, 08 Nov 2012 14:47:59 GMT

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

Re: ODBC Connection to SQL Server

jonathandienst — Thu, 08 Nov 2012 14:53:15 GMT

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