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.
