Skip to main content
Delphix

KBA1642 Verify Credentials Fails When Testing DB User On SQL Server During dSource Link

 

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.