Forum Discussion

prajakta2500's avatar
prajakta2500
Occasional Contributor
7 years ago

I am facing problem while connecting MSSQL connection in Soapui free version.

I am facing problem while connecting MSSQL connection in Soapui free version. I need to fetch data from database table and use as request data for another request. On click on test connection showing...
  • JHunt's avatar
    JHunt
    7 years ago

    Hi,

     

    You need to get the MS SQL JDBC driver from the Microsoft site. I couldn't get the version 6 working in SoapUI, but version 4 worked perfectly.

     

    https://www.microsoft.com/en-us/download/details.aspx?id=54670

     

    • Put the sqljdbc41.jar into your SoapUI folder under ./bin/ext (and restart SoapUI)
    • Since you're using SQL Server Login instead of Windows Authentication, you don't need the sqljdbc_auth.dll at all.
    • The driver name is
    com.microsoft.sqlserver.jdbc.SQLServerDriver
    • The connection string looks like:
    jdbc:sqlserver://myhost.mydomain.com:9999;username=apawar;password=mypass123

     

JHunt's avatar
JHunt
Community Hero
7 years ago

Hi,

 

You need to get the MS SQL JDBC driver from the Microsoft site. I couldn't get the version 6 working in SoapUI, but version 4 worked perfectly.

 

https://www.microsoft.com/en-us/download/details.aspx?id=54670

 

  • Put the sqljdbc41.jar into your SoapUI folder under ./bin/ext (and restart SoapUI)
  • Since you're using SQL Server Login instead of Windows Authentication, you don't need the sqljdbc_auth.dll at all.
  • The driver name is
com.microsoft.sqlserver.jdbc.SQLServerDriver
  • The connection string looks like:
jdbc:sqlserver://myhost.mydomain.com:9999;username=apawar;password=mypass123