This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

SQL Server account connection setup failing with multiple error

pvsharish9
New Contributor

โ€Ž04-28-2022 06:56 AM

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 REPLY 1

JensDeveloper
Contributor II

โ€Ž04-29-2022 04:47 AM

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:
image

Regards

Jens