Unable to connect to SQL Server 2005 - with 'Data Source' using JDBC

Common error messages that may occur when you try to connect to your SQL server:
java.sql.SQLException: [Microsoft][SQLServer Driver for JDBC][SQLServer]Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection.

This error message occurs if the SQL Server authentication mode is set to Windows Authentication mode. The Microsoft SQL Server driver for JDBC does not support connecting by using Windows NT authentication. You must set the authentication mode of your SQL Server to Mixed mode, which permits both Windows Authentication and SQL Server Authentication.

You have already copied .JAR file & Driver is also okay. Now you need to change only Connection string. It should be
jdbc:sqlserver://SystemName:1433;Database=DBName;userName=;password=;

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Is there any way to connect SQL server with windows authentication mode ?
I dont right to chnage database properties .

Let me know id we can have some other friver in SOAPUI 3.0.1 which is able to do this....

Thanks
Archana

You may be able to use the jTDS driver (http://jtds.sourceforge.net). You need to place the [tt:3ut1vmzf]ntlmauth.dll[/tt:3ut1vmzf] file into the soapUI bin directory.

Note: I am using 3.5.1 so I am not certain this will work.

I switched to soapUi 3.5.1 but still I am not able to connect to database.
I have copied the Jtds driver zip to ext folder.When I give connection string for it it gives me error as
"Not able init the driver Jtds:.....

Any idea why this is happening
Please reply its very urgent

I don't think just dropping the .zip will do it.

Put the following files in these locations:

ntlmauth.dll in C:\Program Files\eviware\soapUI-Pro-3.5.1\bin
jtds-1.2.5.jar in C:\Program Files\eviware\soapUI-Pro-3.5.1\bin\ext

Register the driver properties in soapUI preferences (I called it "JTDS Trusted"); replace yourdomain with your domain:

jdbc:jtds:sqlserver://<HOST:127.0.0.1>:<PORT:1433>/<DB>;domain=yourdomain;trusted_connection=yes

Does this help?

Hey Thanks Very much.
Its working like a magic .....
You have solved my big problem

Hi,

I am Bale to connect to the data base and able to access the tables but when I check for stored procedures
while building a query it gives me error like
Invalid Procedure Number(0) must be between 1 and 32767

I am not able to access the stored procedures.

Let me know if you know how to solve it ..
thanks in advance .... :-)

I don't have any experience with stored procs in soapUI, but

1) Do you have permissions to execute stored procs?
2) Are you trying to call a function instead of a procedure? I think the JDBC request might be expecting a result set.

Hi ,

I am successfully connected to the SQL 2008 using jtds driver.
But when I migrated those configuration on my test environment,
The driver registered fine and query is getting executed.
But I am getting following exception

Thu Sep 16 17:52:08 IST 2010: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:48)
at com.eviware.soapui.impl.wsdl.support.connections.DatabaseConnectionWizard$TestConnectionAction.actionPerformed(SourceFile:323)
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.pumpEventsForFilter(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at java.awt.Window.setVisible(Unknown Source)
at java.awt.Dialog.setVisible(Unknown Source)
at com.eviware.soapui.impl.wsdl.actions.project.SimpleDialog.setVisible(SimpleDialog.java:103)
at com.eviware.soapui.impl.wsdl.support.connections.DatabaseConnectionWizard.configure(SourceFile:342)
at com.eviware.soapui.impl.wsdl.support.connections.DatabaseConnection.configureConnectionDetalis(SourceFile:136)
at com.eviware.soapui.impl.wsdl.support.connections.DefaultDatabaseConnectionContainer.configureDatabaseConnection(SourceFile:183)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.JDBCConnectionDataSource$ConfigureDataConnectionAction.actionPerformed(SourceFile:517)
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)

Please let me know the reason for it.
Also I have some other query as -

My test suites has 122 testcases overall.
The soapUi is running on 8GB RAM Machine with 3 Processors but still when I am trying to execute completed testsuite it gives OUT of memory error all time .

I have done all changes as referred by follwoing link but had bad luck in avoiding this error ..

http://www.soapui.org/Working-with-soapUI/improving-memory-usage.html

If you have any idea please respond ASAP. It urgant ...