connecting to sql server

You shuld download sql driver files
place it in /ext folder in soapui installed folder
configure dns details

for more details refer to this post :http://forum.eviware.com/viewtopic.php?f=5&t=661&p=15131

I am very new to using SOAP UI tool by practising i have got some idea.. now i want to get somemore idea.. my question is that can i automatically run all my test suites at different times(morining, afternoon, evening) and generate reports not manually clicking can i schedule the time please help me.

Hi!

you will need to use an external scheduling tool, for example the windows task scheduler, to run your tests with the soapUI command-line tools.

regards,

/Ole
eviware.com

hi,

I have been trying to connect to sql server from soapui pro 3.6.1 with no success. Here are the details
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE;
sqljdbc jar file is in: C:\Program Files\eviware\soapUI-Pro-3.6.1\bin\ext
I also downloaded sqljdbc4.jar and placed in the same folder

I am getting following error:
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'username'.
However I am able to connect to the database using same username/password via management studio. No idea whats going wrong. Also checked the authentication mode which is Mixed(Windows and SQL), the login is enabled as well.

Every help is appreciated.
Thanks.

I was using machinename/instancename while connecting to sql server using management studio. However my connection string in soapui didnot include instancename, could connect successfully to sql server from soapui and management studio using just the machine name.

I have yet to figure out how to modify the connection string to have the instancename in the connection string.

I have been getting the same results as below.. I cannot seem to find any answers in the forums.

manik wrote:

hi, I have been trying to connect to sql server from soapui pro 3.6.1 with no success. Here are the details Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE; sqljdbc jar file is in: C:\Program Files\eviware\soapUI-Pro-3.6.1\bin\ext I also downloaded sqljdbc4.jar and placed in the same folder I am getting following error: Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'username'. However I am able to connect to the database using same username/password via management studio. No idea whats going wrong. Also checked the authentication mode which is Mixed(Windows and SQL), the login is enabled as well. Every help is appreciated. Thanks.

I am new to SOAPUI and using the open source version of it(SOAP4.5.1). Trying to establish connection to remote database and see error

Here is what I did......

Added a JDBC test step and the values are given as below

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE;
sqljdbc jar file is in: C:\Program Files\SmartBear\soapUI-4.5.1\bin\ext
I also downloaded sqljdbc4.jar and placed in the same folder

And when I tried to run the step, the RequestLog show the below error. Could someone please provide me a solution?

Error getting response; java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

if you use the sqljdbc4.jar file, remove sqljdbc.jar
does it work now?