Forum Discussion

itaykaldi's avatar
itaykaldi
Contributor
12 years ago

[Resolved] Can't connet to MSSQL

Hey,
i have last SoapUI Pro version, i choose driver com.microsoft.sqlserver.jdbc.SQLServerDriver
when i tried Test Connection i got the following exception:

Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid..


how can i connect to SQl Server?

5 Replies

  • itaykaldi's avatar
    itaykaldi
    Contributor
    12 years ago
    Its actulyy not SQL server
    Its SQL Database service, provided by Azure.
    So i cant know witch version.

    How can i use jTDS driver with SoapUI?
  • itaykaldi's avatar
    itaykaldi
    Contributor
    12 years ago
    I have try to register jTDS driver... but it seems connection sting is wrong.

    connection string: jdbc:jtds:<server_type>://<server>[:<port:1433>][/<database>][;<property>=<value>[;...]]
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    12 years ago
    This is just a template connection string. You have to fill in values that match your environment. Here's an FAQ page describing the connection string format, under the question "What's the URL format used by jTDS?":

    http://jtds.sourceforge.net/faq.html

    For instance, if your server is prod-db and your database is production, the connection string may be something like

    jdbc:jtds:sqlserver://prod2-db/production;ssl=request

    Kind regards,
    Manne Fagerlind
    SmartBear Sweden