Connect to MS SQL Database using AD username

Last activity on October 1, 2023 - 11:21 33.6k Views 2 Replies MashZone

FD

Fred Duc on August 28, 2013

Hello,

In a Data feed, I would like to use MS SQL database as a data source.

I have installed the JDBC MS SQL driver (Microsoft JDBC Driver 4.0 for SQL Server) in [mashzone installation folder]/jdbcdrivers.

This works fine, I can connect to databases using local SQL users as credentials.

My issue is that I can't use Active Directory user as credential (NTLM or Kerberos authentification). I have tried various solution :

[domain name]\[username] OR [username]@[domain name]

The error is attached to this post.

Would anyone know how to proceed on this issue ?

Many thanks,

Fred

Sign in or register to reply.

Notify Moderator

2 Replies

Helmut Barro on August 30, 2013

Have you tried following the approach described by Microsoft?

http://msdn.microsoft.com/en-us/library/gg558122.aspx

The important points:

- use Microsoft JDBC Driver 4.0 for SQL Server

- add "integratedSecurity=true" to your URL

- reference the "sqljdbc_auth.dll" correctly

Please note that this functionality is not something specific for MashZone, and hence not officially supported. But it could work out of the box.

Like

Sign in
or register to reply.

Notify Moderator
FD

Fred Duc Author on September 11, 2013

Hello,

Thanks for the post..

I've did the two points your mentioned:

- use Microsoft JDBC Driver 4.0 for SQL Server

- add "integratedSecurity=true" to your URL

For now, I’ve added the JDBC driver in [mashzone]\jdbcdrivers which works.

Nevertheless, I don't really understand how to reference the sqljdbc_auth.dll for Mashzone. I’ve added in [mashzone]\system\tomcat\bin . Tried to run “tomcat6w.exe “ to declare the dll but I’m prompted with this error “The specified service does not exist as an installed service”. There is probably a conflict between x64 and x86 version. The server runs x64.

Taking in consideration mashzone environment, would you know how can I correctly reference this dll ?

Thanks,

Fred

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.

Sign in

Reset Password