I'm trying to configure a new installation of Server 10 with SQL Server 2014 Standard Edition but I can't get past the RoboHelp Server Configuration Manager.
And when I click "Test Connection," all I'm getting is "Connection failed."
Calling the RoboHelp Server 10 docs on this subject "sparse" would be generous. Are there additional undocumented steps that I need to do first?
Has anyone out there even gotten this to work?
Since you can connect to DB using SSMS i am sure you are using correct login credential. Just make sure you are providing other details for connection set-up in specified format. Below is example for the same:
Database URL ----- > jdbc:sqlserver://NEON-I:1440;databaseName=RHSSQL12
Database User Name ------> <your username>
Database Password ------> <your pwd>
JDBC Driver Class ------> com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Driver Path ------> C:\Users\labuser\Desktop\sql41.jar
I finally succeeded in this. The problem was two things:
Correcting these two issues solved the problem and I was able to successfully connect to the server.