Forum Discussion

sprice090161's avatar
sprice090161
Contributor
9 years ago

How do create a JDBC SQL connection using Windows Authentication?

I am running in a new environment where SQL Server no longer requires a usr/psw per Database as I used to provide for a typical DB connection string. Our new company environment allows me read access to all of our databases using Windows Authentication.

 

For example, if I launch SQL server Management Studio It accepts my computers Window login with no password:

DomainName\User Name

 

And of course I have to supply the server, DB, and port...

 

If I attempt to create a connection string in my new JDBC Test Step and provide the same data it fails to connect to the database.

 

Do I have to explicitly tell soapUI that I want it to use Windows Authentication, and if so how do I do that?

I've searched the test step, the local configuration option, the top level connection string option, and preferences.