Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

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

More
21 Jul 2016 09:49 #1 by Prashant.Sangle
Connect to SQL server database using windows Authentication / AD authentication in stambia was created by Prashant.Sangle
Hi Sir,

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

Thanks and Regards,
Prashant Sangle
More
21 Jul 2016 17:28 #2 by Cyril Dussud
Replied by Cyril Dussud on topic Connect to SQL server database using windows Authentication / AD authentication in stambia
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 ?
More
28 Jul 2016 13:18 #3 by Prashant.Sangle
Replied by Prashant.Sangle on topic Connect to SQL server database using windows Authentication / AD authentication in stambia
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
Attachments:
More
29 Jul 2016 08:55 #4 by Prashant.Sangle
Replied by Prashant.Sangle on topic Connect to SQL server database using windows Authentication / AD authentication in stambia
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
More
29 Jul 2016 09:38 #5 by Cyril Dussud
Replied by Cyril Dussud on topic Connect to SQL server database using windows Authentication / AD authentication in stambia
Hi,

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

Thanks
More
29 Jul 2016 10:06 #6 by Prashant.Sangle
Replied by Prashant.Sangle on topic Connect to SQL server database using windows Authentication / AD authentication in stambia
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