Forum Discussion

Vighnesh's avatar
Vighnesh
New Contributor
8 years ago

How to connect to Microsoft SQL server 2014 local DB from Open source soap UI version?

Hello,   I'm trying to connect to Microsoft sql server 2014 local Db from Soap UI open version, However it's not working. Below are the details :- SQL server 2014 Express Local DB ServerName - (...
Julio's avatar
Julio
Occasional Contributor
Spoiler
 

I suspect it is the instance name - can you use the server name and the port instead.  That worked for me.i.e.

 

 

The web (https://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx) recommended:
jdbc:sqlserver://SERVERNAME;instanceName=INSTANCENAME;databaseName=DB;user=test;password=PASS_VALUE

 
But use

use jdbc:sqlserver://SERVERNAME:PORT;databaseName=DB;user=test;password=PASS_VALUE

 

i.e. your instance should be using a port other than the default 1433.

Vighnesh's avatar
Vighnesh
New Contributor
8 years ago

Hi Julio,

 

Thanks for your reply.

 

However my server name is = "(localdb)\mssqllocaldb" and as its Microsoft sql server 2014 local db its not running on any port. Please correct me if I'm wrong. Right now I'm not able to find out my local db port number on which it is running so, I taken another way which is of instance name.

 

Could you please give me clear idea how I can create my connection string using my server name , instance name and windows authentication?

 

I tried with the port number 1433 and even with other port numbers it giving me below exception - 

 

Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host mssqllocaldb, port 1434 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

 

I checked the TCP/IP connection all the things are working fine however still I'm not able to connect to my database.

 

    • andrewsaunders's avatar
      andrewsaunders
      Occasional Contributor
      8 years ago

      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.

      • Vighnesh's avatar
        Vighnesh
        New Contributor
        8 years ago

        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.