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,

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

Thanks.

Cokey