Unable to connect to SQL Server Database from JChem Manager

I am unable to connect to my database through JChem Manager, although all my SQL database credentials are right. There is a simple message it displays at the bottom "Connecting to database..please wait'  This message doesnt change for upto a day.  Is there a log file or is there any other way I can find what the issue may be?

 

Dear Priya,

I've moved your topic to the appropriate forum.
My colleagues will answer you soon.

Best regards,
Peter

Hi Priya,

Unfortunately, in JChem, there is no logging of the connection process, but you could look at the log of the SQL server, or try to
connect to the database - using the same connection parameters - with an
other application like SQL Workbench, ..., and be sure that remote
connection to the server is permitted on the server.

Please let us know if the problem persists using JChem Manager.

Best regards,

Krisztina

I have made some expreiments with different erroneous settings, but could not reproduce the endless connection process, although it took quite long to get the error messages below.

 

• Erroneous IP address:
  
  

  Invalid database URL. The TCP/IP connection to the host 10.0.0.16, port 1433 has failed. Error: "No route to host. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

  
  


• Erroneous database name:
  
  

  Invalid database URL. Cannot open database "JC" requested by the login. The login failed.

  
  

 

If the user / password is not correct then the error message appears almost immediately:

Invalid database URL. Login failed for user 'test1'.

Added DB parameter logging at DEBUG level, this will be available in JChem 5.12.1.

You can enable this logging by setting this line in your simplelog.properties file:

org.apache.commons.logging.simplelog.log.chemaxon.jchem.connection.ConnectionModel = DEBUG

assuming you have simple logging enabled in commons-logging.properties:

org.apache.commons.logging.Log = org.apache.commons.logging.impl.SimpleLog

Note, that both commons-logging.properties and simplelog.properties should be
placed in a directory in your CLASSPATH.

Hi,

(1) Were you logged into the SQL Server with its administration tool ?

I have vague memories of some issues in the past when I had to disconnect for some reason (all being local).

(2) Also, even if you start JChemManager via a desktop icon on Windows, it opens a command-prompt in the background.

It would be intereting to see if any error message appears there.

Best regards,

Szilard