RoboHelp Server 10 Users: Have you configured an external db using JDBC?

[Rocky_XYZZY]

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.

• I think I've created a correct database URL
• I think I've specified the correct JDBC driver class
• I'm using a database username and password that I created in SSMS, so I know it's correct
• I'm rather certain I've specified the correct path to the sqljdbc_4.1.jar file

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?

[mdsameer87]

Hi Rocky,

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:

   Field Example

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

Thanks,

Mohd Sameer

[Rocky_XYZZY · Accepted solution]

I finally succeeded in this. The problem was two things:

• The user credentials did not have the correct permissions on the SQL Server instance
• The database URL was needlessly complex. All that was required was jdbc:sqlserver://localhost (specifying a databaseNAME property actually prevented it from working, for some reason)

Correcting these two issues solved the problem and I was able to successfully connect to the server.

[metro5E8A]

Hi team, 

I'am currently trying to migrate our RH application from v9 to v10 ! We backed-up and restored our prod DB on a test environnement, we installed RH10 on a win2019 server and also SQL2014 on same server ! 

When trying to test the connection to the local database it's not working ! Always we get a Connection Failed error message ! 

What is surprising is that we got connection successful to the same sql express DB by using TestDatabase.udl application. 

We also followed the recommendation mentionned above on this discussion but no chance : 

Database URL  ----- >      jdbc:sqlserver://localhost

Database User Name ------>      <your username>

Database Password           ------>      <your pwd>

JDBC Driver Class           ------>      com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Driver Path           ------>      "C:\Program Files\Apache Software Foundation\Tomcat 8.5\lib\mssql-jdbc-9.4.0.jre8.jar"

Any suggestion please ? I asked the support for assistance but it's taking a long time and no answer for the moment ! 

[Amebr]

I can't help with your question, and most of us here aren't IT people. But if you used the regular support chat box on the Adobe site, try using the email address on the following page instead. That will get to specialist Robohelp support people.

See the following page for support contact options:
https://helpx.adobe.com/contact/enterprise-support.other.html#robohelp

[metro5E8A]

Hi Amebr, Thank you. For sure i'am already dealing with adobe support and i was here to try to enlarge my chance to solve my issue. Will keep you posted.

[Amebr]

Just confirming you used the email address and not the regular chat support? The chat box people often don't know anything about Robohelp.

[metro5E8A]

Hi, i posted my solution here if someone is interested : 

Re: RoboHelp Server 10 : Test Connection to local ... - Adobe Support Community - 12561308