Skip to main content
R
Rocky_XYZZY
Inspiring
August 31, 2016
Answered

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

  • August 31, 2016
  • 2 replies
  • 1483 views

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?

This topic has been closed for replies.
Correct answer Rocky_XYZZY

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.

2 replies

A
Community Expert
AmebrCommunity Expert
Community Expert
November 30, 2021

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

 

M
metro5E8A
Known Participant
December 1, 2021

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.

A
Community Expert
AmebrCommunity Expert
Community Expert
December 1, 2021

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

M
Adobe Employee
mdsameer87
Adobe Employee
September 1, 2016

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

R
Rocky_XYZZYAuthorCorrect answer
Inspiring
September 1, 2016

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.

M
metro5E8A
Known Participant
November 30, 2021

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 ! 

 

 

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices