SQL Server connection strings
1. jdbc:sqlserver://192.168.10.220\ northstar ;databaseName=Northstar The server\instance name syntax used in the server option is the same for all SQL Server connection strings. northstar is a instance name. each instance match a port of TCP . 2. jdbc:sqlserver://192.168.10.220： 1433 ;databaseName=Northstar (Provider=SQLOLEDB.1;Password=*;Persist Security Info=True;User ID=sa;Initial Catalog= Northstar ;Data Source=192.168.10.220 ,1433 ) 1433 is the default port for SQL Server, can be dynamically assigned, such as 1863, 1875... netstat -aon | findstr 1433 * A .udl file can be used to set connection string at client side. Creating and Configuring Universal Data Link (.udl) Files * svrnetcn.exe at server side sets port. * netstat command displays protocol statistics and current TCP/IP network connections. (netstat -an) Ref: https://www.connectionstrings.com/sql-server/ http://support2.microsoft.com/?id=832017 This article contains several references to the defau