Connecting to Remote Database

[dlstrawn]

so i got the DB connection setup, now it is timing out when connecting... database name is erased when it times out, apparently...

screenshot.png

[robert.swanson]

Is it possible your network is prohibiting the connection attempt? You can activate JDBC logging and possibly glean some useful information from the log file.

Per the Valence Guide:
"In the event you encounter connectivity issues with a remote database server, you can glean troubleshooting information by activating JDBC logging for the Valence instance. This is achieved by going into Portal Admin > Settings > Hidden Settings and checking the "Log all JDBC activity related to remote database connections" checkbox. Once activated, detailed logging activity will be placed into an automatically created log file located in the IFS. Look for a file that begins with "vvjavaremote.log" in path /java/remotedb within the appropriate Valence directory (i.e., /valence-6/java/remotedb/vvjavaremote.log.0)."

[dlstrawn]

the log says:

SEVERE: ERROR OCCURRED
java.sql.SQLException: Login failed for user '#dstrawn'.

I can log into the remote server with that User ID from Remote Desktop...

[robert.swanson]

Not sure what to make of that... Could you send the entire log file to support at cnxcorp.com so we can look it over? Also, what version of SQL Server are you running there?