MS SQL Server - Connection String with Named Instance and Port?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Connection String with Named Instance and Port?

bradwiseathome@hotmail.com

2006-03-24, 7:25 am

I am trying to create a SQL Server 2000 and 2005-friendly connection
string that will allow me to connect to a named instance on a
non-standard port. I can't get the syntax right, can anyone show an
example?

Thanks.

Sue Hoegemeier

2006-03-26, 8:23 pm

For data source, use YourServer\YourNamed
Instance then a
comma followed by the port number - e.g.
Data Source=YourServer\Na
medInstance,1433;

-Sue

On 23 Mar 2006 06:38:16 -0800, bradwiseathome@hotma
il.com
wrote:

>
>I am trying to create a SQL Server 2000 and 2005-friendly connection
>string that will allow me to connect to a named instance on a
>non-standard port. I can't get the syntax right, can anyone show an
>example?
>
>Thanks.

Sponsored Links