Start a new topic

I can't connect to MS SQL DB

Hello. I'm trying to establish a connection to the MSSQL SERVER database. I use a Windows domain account to connect. I'm using a connection string


jdbc:sqlserver://core-m3s-prd-2:1433;databaseName=HRData_SQL_Export_MDM;integratedSecurity=true;encrypt=false


I receive an error message


"Failed to create the connection

Failed to establish a TCP/IP connection to the core-m3s-prd-2 server on port 1433. Error: "null. Check the connection properties."


With the specified connection string I successfully connect from the DBeaver application.

I tried to update the component for accessing MS SQL server databases, but nothing helps.

1 Comment

Hi Tomind !

Can you confirm that your module MSSQL on your built-in runtime has the same jar libraries and other files as your DBeaver MSSQL definition ?

You can check the jar file used for your connection in Dbeaver in Edit connection -> Driver Settings :

image


Login to post a comment