Forum Discussion
Nullius
13 years agoOccasional Contributor
Just for future references (been looking online for a few hours!):
The MS driver DOES support integrated security (windows authentication).
Download the latest driver from http://www.microsoft.com/download/en/de ... n&id=21599
Unpack, copy 'sqljdbc.jar' or 'sqljdbc4.jar' (copying both resulted in a could not connect exception) to <soapui_dir>/bin/ext
Then, copy 'sqljdbc_auth.dll' to <soapui_dir>/bin
Use following connection string if using named instances:
jdbc:sqlserver://<SERVER>;instanceName=<INSTANCE>;databaseName=<DATABASE>;integratedSecurity=true;
Use following connection string if using server port:
jdbc:sqlserver://<SERVER>:<PORT>;databaseName=<DATABASE>;integratedSecurity=true;
The MS driver DOES support integrated security (windows authentication).
Download the latest driver from http://www.microsoft.com/download/en/de ... n&id=21599
Unpack, copy 'sqljdbc.jar' or 'sqljdbc4.jar' (copying both resulted in a could not connect exception) to <soapui_dir>/bin/ext
Then, copy 'sqljdbc_auth.dll' to <soapui_dir>/bin
Use following connection string if using named instances:
jdbc:sqlserver://<SERVER>;instanceName=<INSTANCE>;databaseName=<DATABASE>;integratedSecurity=true;
Use following connection string if using server port:
jdbc:sqlserver://<SERVER>:<PORT>;databaseName=<DATABASE>;integratedSecurity=true;