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):
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.
on our MSSQL instance, we are using this syntax:
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".
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.
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...
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG