I am getting a connection fail error while connecting to MSSQLserver.

[SANTOSH1657711471]

I am getting a connection fail error while connecting to MSSQLserver.

I have entered the database name, Server Name, port number, Username and left the scheme and password column blank since I have not set any password . When tested the connection, it s throws error. you must change the database settings

[Anonymous]

Hello,

Could you please change the Db version to 'Open source JTDS' as the below to see if it work?

[SANTOSH1657711471]

I have tried to Open source JTDS, but still it throws an error that change the database settings​

[Anonymous]

so, maybe your db settings are not correct, regarding to your snapshot, your input user is 'Administrator', I guess it's a windows username and you want to use the sql-server windows authenticate? if yes, then that's the problem, here it should be a Sql-server Authenticate, so please input the correct login/password , thanks

[SANTOSH1657711471]

Yes, Its my windows Authentication. The SQL server uses windows Authenticate to log on, therefore I have used the same setting to configure it.

I have tried using SQL server Authentication, however it fails to connect to the server with a msg " that I have not entered the password for the default user name "sa" . I am able to connect to the server using windows Authentication by using MSSQL server management studio.

[SANTOSH1657711471 · Accepted solution]

The issue is resolved now after corrected settings. Thanks ​