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