Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm troubleshooting an issue with importing data to Apache Solr from a MS SQL Server database via a JDBC connection. Solr is hosted on a CentOS linux machine, and SQL Server is (of course) on a seperate Windows Server box.

I can see the login attempt on SQL Server, but it stops at a single Audit Login event, and Solr never completes the query, and never throws an exception. The same SQL user works fine when connecting directly; leading me to suspect either a network issue or (possibly) a SQL configuration issue. What's more, the production Solr box successfully queries the QA database.

What basic CLI utility can I run from the Solr/Linux box to connect to SQL Server, using the same JDBC driver and parameters, to test if I'm able to perform basic SQL queries?

share|improve this question

I would use Squirrel SQL or DBVis both are Java based and need a JDBC driver, so you can use the same one. Great tools.

share|improve this answer
Thanks! I forgot to specify that this is a command-line only server, but I'll see if by chance I can run it remotely over xming – STW Dec 16 '11 at 14:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.