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";