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
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.
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