Hi, I am using the /example-DIH in the Solr 4.0 download. The example worked out of the box using the HSQLDB. I then attempted to modify the files to connect to a SQL Express instance running on my local machine. A http://localhost:8983/solr/db/dataimport?command=full-import results in
org.apache.solr.common.SolrException log SEVERE: Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: SELECT [ProdID],[Descr] FROM [Amazon].[dbo].[Table_Temp] Processing Document # 1 at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:273) … I first copied sqljdbc4.jar (from Microsoft) to /example/example-DIH/solr/db/lib. I have the following db-data-config.xml: <dataConfig> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;databaseName=Amazon;integratedSecurity=true;"/> <document> <entity name="Product" query="SELECT [ProdID],[Descr] FROM [Amazon].[dbo].[Table_Temp]"> <field column="ProdID" name="ProdID" /> <field column="Descr" name="Descr" /> </entity> </document> </dataConfig> I have adjusted my schema.xml file accordingly. Is there anyway I can debug this problem? I want to use Integrated Security/Authentication, am I doing this correctly? Thank you for all the help. O. O. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-SQL-Express-Integrated-Security-Unable-to-execute-query-tp4035758.html Sent from the Solr - User mailing list archive at Nabble.com.