Connect to MS SQL Database using AD username

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