Verify Credentials Fails When Testing DB User On SQL Server During dSource Link (KBA1642)
Issue
If the validate credentials fails when attempting to link a SQLServer dSource with an error of "Verification Failed", the debug logs will show this type of error:
com.delphix.appliance.server.dco.events.enums.ConnectivityExceptions$ValidationFailed:
exception.connectivity.validation.failed {Failed to connect to source database "master" over JDBC.
Error: The TCP/IP connection to the host UKFIL323WIN, port 49362 has failed. Error: "null.
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.".|
Make sure the database is accepting remote connections over TCP, the database is not using a dynamic TCP port, and the
SQL login "Delphix_Source" has privileges to connect to the source database.
Then refresh the environment and try again.|fil_dba_tools}
Troubleshooting
First check if the hostname added for the environment is a FQDN or simple. If simple then ask what the domain network name is for the Source host and compare it with the domain we have stored for the Delphix engine DNS configuration.
From a support logs this can be determined with the command
phinfo | grep DNS
Resolution
If the domain is not shown then the issue can be resolved by the following options
1: Add the extra domain/s to the engine DNS configuration with:
ssh sysadmin@<delphix_engine> delphix_engine> service delphix_engine service > dns delphix_engine service dns > update delphix_engine service dns update *> set domain=<domain1>,<domain2>,... delphix_engine service dns update *> commit
2: Change the hostname in the Source environment to the FQDN
Then test the validate credentials again.