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?