Forum Discussion
Check this article if you are using Windows authentication.
Ensure that sqljdbc_auth.dll is in the correct directory, \bin directory.
How to configure SoapUI Pro JDBC Datasource with SQL Server that uses windows authentication
Also, TCP/IP is disabled by default in Microsoft SQL Server 2014
Follow the steps to enable the TCP/IP protocol
I'm having similar trouble with a serverName/instanceName scenario connecting to a MS SQL database. Going via the ready api GUI, it appears to strip off the slash from the name. I've tried shortcutting by inserting the connection string directly into the settings.xml, but no luck.
I've also tried added the instance name as a property to the connection string, also no luck.
Crucially - I had to bypass the Database setup UI and author a connection string directly that EXLUDES the port number ( ms sql with intances don't utilise port numbers as areference point). The ReadyAPI GUI appears to default to 1433 if you leave the port field blank...I inserted a connection string directly into a JDBC Request test step instead of creating a Database reference object.
- Vighnesh8 years agoNew Contributor
Hi All,
I was able to connect to Microsoft SQL server local db 2014 using open source soap UI version with below configurations
Driver - com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String - jdbc:jtds:sqlserver://./DatabaseName;instance = "your dabase base instance name";namedPipe = true
You will get the instance name by typing " sqllocaldb info MSSQLLocalDb " in command prompt. Please use Instance Pipe name in connection string.