Solved Connect to SQL server database using windows Authentication / AD authentication in stambia

Hi Sir,

How can use SQL Server metadata using windows authentication/ AD authentication?

Thanks and Regards,
Prashant Sangle

Hi,

The Microsoft SQL JDBC drivers allows that through some manipulation and a specific JDBC URL that looks like this:
jdbc:sqlserver://localhost;integratedSecurity=true;

The procedure is explained here
msdn.microsoft.com/en-us/library/ms37842...Connectingintegrated

Can you have a look at it and follow the steps described by Microsoft ?

Hi,

I have tried what suggested but getting attached error.

I have downloaded latest version of sqljdbc connector i.e. sqljdbc_6.0

Please suggest. Client want It in high priority

Thanks and Regards,
Prashant Sangle

Hi Sir,

I am successfully able to connect Remote SQL server database using windows Authentication / AD login in stambia .

Thanks for support.

Thanks and Regards,
Prashant Sangle

Hi,

Nice, good news!
If possible, can you explain what was wrong ?
This could help in case over people are facing this issue.

Thanks

Yes sure sir,

for windows authentication required sqljdbc_auth.dll file

1: placed sqljdbc.jar driver in "c:/program files/java/jre/lib" folder
2: placed sqljdbc_auth.dll file in "c:/program files/java/jre/bin" folder and "C:\Windows\System32" folder.

Restart stambia and used below url
jdbc:sqlserver://<servername>;integratedSecurity=true;

Note : Required sqljdbc_auth.dll file as per java version installed in machine i.e. 32 bit or 64 bit.

Thanks and Regards,
Prashant Sangle