Skip to main content

Return to Revisions

3 of 3
deleted 16 characters in body; edited tags; edited title; deleted 5 characters in body
Michael Petrotta
Michael Petrotta
  • 61.1k
  • 27
  • 153
  • 181

How to specify a port number in SQL Server connection string?

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?

smwikipedia
  • 65k
  • 98
  • 333
  • 519