Skip to main content

Return to Question

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

How to specify a port number in SQL Connection StringServer connection string?

I use the following connection string in SQL Server Management Studio, it. It failed to connect:

mycomputer.test.xxx.com:1234\myInstance1

But the following one is ok:

mycomputer.test.xxx.com\myInstance1

So how todo I specify a port number in a connection string?

Thanks.

How to specify a port number in SQL 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 to specify port number in a connection string?

Thanks.

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?

deleted 5 characters in body
Source Link
smwikipedia
smwikipedia
  • 65k
  • 98
  • 333
  • 519

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:1234\myInstance1com\myInstance1

So how to specify port number in a connection string?

Thanks.

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:1234\myInstance1

So how to specify port number in a connection string?

Thanks.

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 to specify port number in a connection string?

Thanks.

Source Link
smwikipedia
smwikipedia
  • 65k
  • 98
  • 333
  • 519

How to specify a port number in SQL 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:1234\myInstance1

So how to specify port number in a connection string?

Thanks.