SoapUI Pro, Windows 7 64 bit, MS SQL Integrated Security

Hi,

I've just finished installing SoapUI Pro 3.6.1 (Windows 64-bit installer (no JRE)) on a Windows 7 box (64-bit) and have been trying to get MS SQL JDBC Integrated Security working. I've had this working under Windows XP, but have had no luck in getting this to work under Windows 7 thus far. I've downloaded the latest Microsoft SQL Server JDBC Driver 3.0 and have tried using the following file: Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\auth\x64\sqljdbc_auth.dll.

Things I have tried (restarting SoapUI Pro each time):

1) Placing the file in C:\Program Files\eviware\soapUI-Pro-3.6.1\bin\ext
2) Placing the file in C:\Program Files\eviware\soapUI-Pro-3.6.1\bin
3) Placing the file in C:\Program Files\Java\jre6\bin

My connection string is in the following format:

Note: I've replaced the server, port and database names with generic strings for this post

jdbc:sqlserver://${#Project#XXServerNameXX}:${#Project#XXServerPortXX};databaseName=XXDbNameXX;integratedSecurity=true;

Each time I try a simple JDBC test connection, I get the following error.

Failed to init connection for drvr [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://XXserverNameXX:1522;databaseName=XXDbNameXX;integratedSecurity=true;]

Here is the exceptions I see in the SoapUI error log:

Mon Apr 11 11:34:40 EDT 2011:ERROR:java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:50)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.testDatabaseConnection(SourceFile:226)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.testDatabaseConnection(SourceFile:211)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.testDatabaseConnectionAt(SourceFile:204)
at com.eviware.soapui.impl.wsdl.panels.project.JdbcConnectionPanel$TestConnectionAction.actionPerformed(SourceFile:225)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Mon Apr 11 11:34:40 EDT 2011:ERROR:com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://sqa-contact04:1522;databaseName=Pending;integratedSecurity=true;]
com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://sqa-contact04:1522;databaseName=Pending;integratedSecurity=true;]
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:62)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.testDatabaseConnection(SourceFile:226)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.testDatabaseConnection(SourceFile:211)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.testDatabaseConnectionAt(SourceFile:204)
at com.eviware.soapui.impl.wsdl.panels.project.JdbcConnectionPanel$TestConnectionAction.actionPerformed(SourceFile:225)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Any help in getting this resolved would be greatly appreciated.

Thanks,
Chris