Posted by Dan Guzman on 11/17/06 01:25

> If I have named instance, shall I have to change my connection string
> every time I run Windows?

You don't need to hard-code the port in the connection string if you enable
the SQL Browser service. This will allow clients to discover the port
dynamically based in the instance name.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@poczta.onet.pl> wrote in message
news:ejh2j5$lao$1@news.onet.pl...
> Thank you I found.
> Some application I need uses SQL Server 2005. I need to provide connection
> string (that's why I need port number).
> If I have named instance, shall I have to change my connection string
> every time I run Windows?
> /RAM/
>
> Uzytkownik "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> napisal w
> wiadomosci news:yoQ6h.6288$IR4.968@newssvr25.news.prodigy.net...
>> You should have a log entry like the example below if the server is
>> listening on TCP/IP:
>>
>> 2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
>> 10489].
>>
>> In this case, the port is 10489.
>
>

[Back to original message]