Michael Della Bitta-2 wrote > On Thu, Jan 24, 2013 at 11:34 AM, O. Olson <
> olson_ord@ > > wrote: >> >> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The server >> SQLEXPRESS is not configured to listen with TCP/IP. > > > That's probably your problem... > > > Michael Della Bitta > > ------------------------------------------------ > Appinions > 18 East 41st Street, 2nd Floor > New York, NY 10017-6271 > > www.appinions.com > > Where Influence Isn’t a Game ============================ Good call Michael. I did have to enable TCP (http://msdn.microsoft.com/en-us/library/hh231672.aspx for others who have the same problem), but I did not still not get this to work. I then tested my Driver, JDBC URL & SQL Query in a plain old Java class. This showed me that it was almost impossible to get integrated authentication to work in Java. I finally went with specifying the usename and password literally. (I hope this useful to others): public static void main(String[] args) throws Exception { String url = "jdbc:sqlserver://localhost\\SQLEXPRESS;database=Amazon;user=solrusr;password=solrusr;"; String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; Connection connection = null; try { System.out.println("Loading driver..."); Class.forName(driver); System.out.println("Driver loaded! Attempting Connection ..."); connection = DriverManager.getConnection(url); System.out.println("Connection succeeded!"); ResultSet RS = connection.createStatement().executeQuery("SELECT ProdID, Descr FROM Table_Temp"); try { while(RS.next() != false) { System.out.println(RS.getString(1) + " " + RS.getString(2)); } } finally { RS.close(); } // Success. } catch (SQLException e) {} finally { if (connection != null) try { connection.close(); } catch (SQLException ignore) {} } } Hence, I modified my db-data-config.xml to <dataConfig> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=Amazon;user=solrusr;password=solrusr;"/> <document> <entity name="Product" query="SELECT ProdID,Descr FROM Table_Temp"> <field column="ProdID" name="ProdID" /> <field column="Descr" name="Descr" /> </entity> </document> </dataConfig> This worked for me. Thanks again Michael & Shawn. O. O. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-SQL-Express-Integrated-Security-Unable-to-execute-query-tp4035758p4036056.html Sent from the Solr - User mailing list archive at Nabble.com.
