SOAPUI Database connection

SOAP UI TOOL DATABASE CONNECTION

  Hi Guys,
        I'm providing the details below to connect the database through the SOAPUI tool.

        1.Right click on the test case -> Insert Step -> JDBC request

        2. Enter JDBC Request -->; Click OK

3.Create name for JDBC connection -> Enter JDBC connection -> 

Click OK                                                               

4. In Database configuration window

5. SelectMSSQL Driver from drop down -> Click OK

6. Enter user name,password,database name -> Check for test connection -> Click OK

Connection string-(jdbc:sqlserver://127.0.0.1:1433;databaseName=MYTEST;user=test; password=PASS_VALUE)

*MyTEST is the database name 

* user is the username

* password is the password for accessing database.

*  1433 is port name

7. Write sql query    ->   run the query  -> check the response