Connection error to MSSQL DB

0
Hi I’m trying to connect to a MSSQL DB but got some problems in Mendix with that. In a little c# tool I’m able to connect to the DB and to get some Data. This is in c# my conection string : ‘’’ con = new SqlConnection(@"Server=SE-56********\MYSQLSERVER;Database=ExternalDB;User Id=TestUser;Password=abcd1234;");’’’   And thats what i put in the jdbc url: jdbc:sqlserver://SE-56********\MYSQLSERVER;database=ExternalDB; When i start the Mendix Application and try to load the data, this is my error i get:     I could imagine that my Jdbc Url is wrong.
asked
1 answers
1

Generally, the SQL SERVER JDBC URL will be in this format.

the default port is 1433

Get your Servername  properly

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

 

Reference: https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16

answered