• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

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

Explorer ,
Aug 31, 2016 Aug 31, 2016

Copy link to clipboard

Copied

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?

Views

926

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Explorer , Sep 01, 2016 Sep 01, 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.

Likes

Translate

Translate
Adobe Employee ,
Sep 01, 2016 Sep 01, 2016

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Sep 01, 2016 Sep 01, 2016

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 30, 2021 Nov 30, 2021

Copy link to clipboard

Copied

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 ! 

 

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 30, 2021 Nov 30, 2021

Copy link to clipboard

Copied

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

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 01, 2021 Dec 01, 2021

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 01, 2021 Dec 01, 2021

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 13, 2021 Dec 13, 2021

Copy link to clipboard

Copied

LATEST

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

 

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
RoboHelp Documentation
Download Adobe RoboHelp