How to specify a port number in SQL Server connection string

Question

I use the following connection string in SQL Server Management Studio  It failed to connect   mycomputer test xxx com 1234 myInstance1  But the following one is ok   mycomputer test xxx com myInstance1  So how do I specify a port number in a connection string

User · Answer

For JDBC the proper format is slightly different and as follows   jdbc microsoft sqlserver   mycomputer test xxx com 49843   Note the colon instead of the comma

User · Answer

The correct SQL connection string for SQL with specify port is use comma between ip address and port number like following pattern  xxx xxx xxx xxx yyyy

User · Answer

Use a comma to specify a port number with SQL Server   mycomputer test xxx com 1234  It s not necessary to specify an instance name when specifying the port   Lots more examples at http   www connectionstrings com   It s saved me a few times

[sql-server] How to specify a port number in SQL Server connection string?

Examples related to sql-server