Contributions
Re: How to connect to Microsoft SQL server 2014 local DB from Open source soap UI version?
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.6.1KViews0likes0CommentsRe: How to connect to Microsoft SQL server 2014 local DB from Open source soap UI version?
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.6.3KViews0likes4CommentsHow 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 - (localdb)\mssqllocaldb Instance Name -LOCALDB#DCD9BDD9 Credentials - WindowsAuthentication I'm using below Driver and Connection String in Soap UI JDBC step. Driver -com.microsoft.sqlserver.jdbc.SQLServerDriver Connection String -jdbc:sqlserver://(localdb)\mssqllocaldb\LOCALDB#DCD9BDD9;databaseName=test;integratedSecurity=true I'm getting below error Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host (localdb)mssqllocaldb, named instance localdb#dcd9bdd9 failed. Error: "java.net.UnknownHostException: (localdb)mssqllocaldb". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. Could you please help me out what's going wrong with my connection string or with driver?6.3KViews0likes6Comments