FD

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

by Helmut Barro
Posted on Fri, 08/30/2013 - 11:26

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.

0
by Fred Duc Author
Posted on Wed, 09/11/2013 - 14:13

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

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock