SQL Server account connection setup failing with multiple error

Hello Community,

We are trying to setup SQL server account in Snaplogic, however, getting below error

  1. Invalid username password- Able to login with windows authentication in microsoft sql management studio

Failed to validate account: Failed to retrieve a database connection. Cause: Login failed for user ‘\empid’. ClientConnectionId:27dc1f0c-b783-4327-8d10-c77c82f6c198 (Reason: Login failed for user ‘\empid’. ClientConnectionId:27dc1f0c-b783-4327-8d10-c77c82f6c198; Resolution: Ensure credentials are valid, multiple attempts with invalid credentials may result into account getting locked)

  1. If we use domainname/instancename in HOSTNAME, getting below error
    Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host /, port 1433 has failed. Error: “/. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”. (Reason: The TCP/IP connection to the host /, port 1433 has failed. Error: “/. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.; Resolution: Address the reported issue.)

version - 13.0.5

Here are our account settings -
Hostname: abc.bot.com/mydatabase
port:1433
DBname:emp_name
username: abc\123
password:<>

sql-url-settings

Also, Please share sample account settings for our reference.

Thank you in advance.

1 Like

hi @pvsharish9 ,

Is the user emp added to the DB where you trying to connect to? with the right password?
If Yes,

Which JDBC Jars are you using have you tried this?
JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

And maybe try also only with this Url properties:

  • selectMethod : cursor
    Or do you need those other properties?

Advanced properties:

Regards

Jens

1 Like