AnsweredAssumed Answered

Unable to connect to MSSQL server 2008 db

Question asked by mounika.jayanthi042656 on Jul 21, 2016
Latest reply on Feb 7, 2017 by Srinivas Chandrakanth Vangari

Hello Team,

We  are trying to connect to MSSQL server 2008.We added the sqljdbc 4.2 jar  to the atom's path <atom install directory>/userlib/database directory and restarted the atom as well.We are facing issue  while connecting to this Database.We are unable to import the profile ,getting the error as Unable to extract database metadata.null.

As per the community forum post   Use Custom JDBC drivers ;we put the following configurations:

  • Data base Type:Custom
  • Connection url: jdbc:custom://hostname:1433/databaseName
  • Class name: com.microsoft.sqlserver.jdbc.SQLServerDriver

Note:Reason for using SQLJDBC 4.2 jar is Our atom runs on JAVA 1.8

 

Could you please suggest whether the configurations are  correct? Jar files for the respective 2008 and java 8 are correct ? If both are correct why are we getting  "Unable to extract database metadata.null."And what can else can we check to make this work

Outcomes