Forum Discussion

Xour's avatar
Xour
Occasional Contributor
8 years ago

[Solved] [JDBC] Cannot connect to a MS SQL database

Hello. I'm having issues connecting to a MS SQL database with JDBC. I went to the JDBC drivers page and saw that there isn't a download link for MS SQL driver. So I went to the Microsoft website and ...
JDBC
MSSQL
  • PaulMS's avatar
    PaulMS
    8 years ago

    The driver is missing an r at the end (again the JDBC Driver List page is wrong) and you don't need MSSQL(MicrosoftDriver)/ at the start.
    Try
    com.microsoft.sqlserver.jdbc.SQLServerDriver

    Also copy sqljdbc4.jar to C:\Program Files\SmartBear\SoapUI-5.2.1\bin\ext

divergentor's avatar
divergentor
Occasional Contributor
8 years ago

Hello.

 

I have the same problem and I still could not solve it. Maybe you can help me.

 

1) I have downloaded Microsoft JDBC Driver 6.0 for SQL Server.

2) From this folder I took file sqljdbc.jar and copy paste it to the folders 

C:\Program Files\SmartBear\SoapUI-5.2.1\bin\ext

and

C:\Program Files\SmartBear\SoapUI-5.2.1\lib

3) I configured my JDBC step as

Driver

MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDrive

 

Connection String

jdbc:sqlserver://localhost\sqlexpress;databaseName=DataVision;user=admin;password=admin

 

After check connection I see the error as you

 

com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDrive], connectionString [jdbc:sqlserver://localhost\sqlexpress;databaseName=DataVision;user=admin;password=admin]

 

 

this is scr with my example

Could you please push me to the right may. 

Thx in advance.

  • Xour's avatar
    Xour
    Occasional Contributor
    8 years ago

    I'll try for sure.

     

    This is the current configuration for my JDBC step:

     

    - Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

    - Connection String: jdbc:sqlserver://HOSTNAME\sqlexpress;databaseName=MYDB;username=USER;password=PASS

    - Driver File: C:\Program Files\SoapUI-5.2.1\bin\ext\sqljdbc4.jar

     

    And that's it!

     

    Let me know if it works

    • wujianyy's avatar
      wujianyy
      Contributor
      8 years ago

      Another solution is to use groovy script.  You can use Windows Authentication to access sql server database. 

       

      Notice of extra jar and dll: 

      1 The files of JDBC driver(MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDrive) isn't distributed with SoapUI Free version. .jar and .dll must be copied into the folder of Soapui folder.

      - sqljdbc_auth.dll must be copied to ..\SoapUI-5.2.1\bin\
      - sqljdbc42.jar must be copied to ..\SoapUI-5.2.1\lib\.

      2 JDBC driver link https://www.soapui.org/jdbc/reference/jdbc-drivers.html

      3 sqljdbc42.jar can be used in jdk 1.8

      • Xour's avatar
        Xour
        Occasional Contributor
        8 years ago

        Why would you want to use a script instead of  JDBC step? This is an honest question!

  • PaulMS's avatar
    PaulMS
    Super Contributor
    8 years ago

    The driver is missing an r at the end (again the JDBC Driver List page is wrong) and you don't need MSSQL(MicrosoftDriver)/ at the start.
    Try
    com.microsoft.sqlserver.jdbc.SQLServerDriver

    Also copy sqljdbc4.jar to C:\Program Files\SmartBear\SoapUI-5.2.1\bin\ext