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

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!