Focal Point
[SOLVED] ism windows authentication for MS SQL with JDBC

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6737042276

August 18, 2014, 05:24 PM
cokeyng
[SOLVED] ism windows authentication for MS SQL with JDBC
I need to set up connection to a ms sql server with windows authentication and have the following questions:
1. would the username in the connection be the account used to start the iWay SM service?
2. it seems like I need to set up the java.library.path to include "C:\Java\mssqljdbc_4.0\sqljdbc_4.0\enu\auth\x64". Where can I include the path for it? or I should set it up as an environment variable in the windows server ?

Thanks

Cokey

iWay SM 6.1.10

This message has been edited. Last edited by: Tamra,


iWay 5.5, 6.01
Windows
all output (Excel, HTML, PDF)
August 19, 2014, 04:36 AM
Srii
Answers to your questions:
1 - Yes
2 - java.library.path maps to 'PATH' environment variable on Windows. Add it there?

Do not forget to add 'integratedSecurity=true' on the connection URL.

-
Srii
August 19, 2014, 12:04 PM
cokeyng
Thanks.

Cokey


iWay 5.5, 6.01
Windows
all output (Excel, HTML, PDF)