Configuring database that uses an instance name within PocketQuery

Hello,

 

We are trying to test out the PocketQuery plugin for Confluence. We aren’t able to set up our database though. We use an instance name and can’t seem to get it to work. These are the URL’s we have tried so far (it is a SQL 2008 Server):

 

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com:1433/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER:1433/LANDMARKS

jdbc:jtds:sqlserver://SQLEXPRESS.ad.here.com:1433/LANDMARKS

jdbc:jtds:sqlserver://SQLEXPRESS:1433/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com:1433\SQLEXPRESS/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER:1433\SQLEXPRESS/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER\SQLEXPRESS:1433/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com\SQLEXPRESS:1433/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com;instanceName=SQLEXPRESS:1433/LANDMARKS

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com:1433/LANDMARKS;instance=SQLEXPRESS

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com:1433/LANDMARKS;instanceName=SQLEXPRESS

jdbc:jtds:sqlserver://SQL-SERVER.ad.here.com;instanceName=SQLEXPRESS;databaseName=LANDMARKS;

 

The servername is “SQL-Server.ad.here.com”. The Instance is “SQLEXPRESS”. And the database name is “LANDMARKS”. Do you have any suggestions?  We just keep getting timeout errors or cannot connect to the database errors.

 

Thanks

Lisa

1 answer

Hi Lisa,

on our MSSQL instance, we are using this syntax:
jdbc:jtds:sqlserver://hostname:1433/dbname;useLOBs=false

If this doesn't work, there must be some credential or network issue. For further inspection, can you please add a DEBUG log entry at ConfluenceAdmin > Logging and Profiling for de.scandio.confluence.plugins.pocketquery ? Please test the connection again and send us the log files, if that's possible.

Also, if you have remote access to the server, try to ping the SQL server in CMD with "ping SQL-SERVER.ad.here.com".

Regards, Felix

By the way: also make your the MSSQL driver (e.g. ) is in your Confluence install directory as mentioned in the PocketQuery documentation:

PocketQuery requires the correct JDBC driver you reference in the admin section to reside in your confluence-install/confluence/WEB-INF/lib directory. Putting it there requires a Confluence restart.

Hi there,

Sorry it took so long to respond. We figured out that the SQL server is restricted so that is why our confluence server can't see it. We are working on opening up the ports on the firewall.  I will let you know if we continue to have problems.

 

Lisa

Great. Just let us know if you have further questions smile

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Published Apr 19, 2018 in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

366 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you