Microsoft SQL Server Express Java Connection

41 views Asked by At

I installed on proxmox a SQL Server Express and now I want connect with a Java program to it, to write and read data. But no matter what I do, I don't get a connection. I tested different types of code for the connection URL, I find some different about the last years. So does anybody now what type of URL I have to use? Maybe somebody can write a example program. PS: I can connect to the SQL Server via SQL Server Management Studio, so the connection it self work

Thanks for help

I tried different types of URL input:

String url = "jdbc:sqlserver://192.168.178.42:1433"
            + "database=test;"
            + "user=ftm-server;"
            + "password=test;"
            + "encrypt=true;"
            + "trustServerCertificate=false;"
            + "loginTimeout=30;";
String connectionUrl = "jdbc:sqlserver://192.168.178.42:1433;databaseName=test;user=ftm-server;password=test";
0

There are 0 answers