SQL Server account connection setup failing with multiple error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2022 06:56 AM
Hello Community,
We are trying to setup SQL server account in Snaplogic, however, getting below error
- 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)
- 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:<>
Also, Please share sample account settings for our reference.
Thank you in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Regards
Jens
