Using DB Tool with Microsoft SQL Server Integrated Security or Using Windows System Credentials

venkatavenkata Posts: 6
edited January 20 in SOAtest

Hello Everyone,

If you are a Microsoft shop and using SQL Server for Database, And the users are enabled with only integrated security for connecting to Databases. You must be wondering how to use the Parasoft DB tool.

Follow the Steps: 1-4 on your windows machine.

1)Download and Install Microsoft JDBC Driver X.X for SQL Server on the same machine where you are using SOATest
2)Copy the sqljdbc_auth.dll file from C:\Program Files\Microsoft JDBC Driver X.X for SQL Server\sqljdbc_7.2\enu\auth\x64
3)Paste sqljdbc_auth.dll in CC:\Program Files\Parasoft\Test\9.10 for SOAtest & Virtualize\plugins\com.parasoft.xtest.jdk.eclipse.core.win32.x86_64_1.8.0.102\jdk\bin
4)In the DB tool, provide Driver, URL and No Username and the Password is required. it automatically takes the windows system credentials


Comments

  • benken_parasoftbenken_parasoft Posts: 814 ✭✭✭

    In case this helps anyone, I happened to notice that Microsoft now publishes both the mssql-jdbc.jar and sqljdbc_auth.dll to Maven Central. This can be handy for automation, where Maven could be used to pull these down automatically prior to running soatestcli, for example.

Sign In or Register to comment.