#9 Connection to SQL SERVER 2019 in error

[Anonymous]

Hi,

We have an error "login failed for user sa" when we tried to connect to our database under sql server 2019 with Jailer with sa user
We use the url : jdbc:sqlserver://instance:1433;encrypt=true;databaseName=dbname;

What we don't understand that the user "sa" is working with the same password with SSMS.

Would you help us to fix this bug please ?

Thanks in advance
Best regards

[Anonymous]

Hi,

There is something strange,
On SQL Server 2019 It works on some instances, but not on others. I don't find the root cause.
Would you help me to fix it please ?

A R
DBA

[Ralf Wisser]

the communication between jailer and the mssql database is controlled and managed by the mssql-jdbc driver. if you have problems with this, please contact the people responsible for the driver. you can find them here: https://github.com/microsoft/mssql-jdbc

[Anonymous]

Hi,
I already use the last version of JDBC : lib\mssql-jdbc-12.2.0.jre8.jar but it's not working

[Anonymous]

Finally I tested also with : lib\sqljdbc_12.10.1.0_fra\sqljdbc_12.10\fra\jars\mssql-jdbc-12.10.1.jre11.jar but it's not working : "Cannot open database xxx requested by the login. The login failed".

It's strange that it's working when the database is master