I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")
Please help. Thank you.
/RAM/

Since this is a named instance, the port is not 1433. The SQL Server error
log will list the listening network protocols, interfaces and ports.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@poczta.onet.pl> wrote in message
news:ejeg8o$oiv$1@news.onet.pl...
>I don't understand why.
> My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert
> (administrator)
> account on Windows XP Professional. I use Windows Authentication. Remote
> connections are switched on ("Using both TCP/IP and names pipes.")
> Please help. Thank you.
> /RAM/
>

I see no port number in C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG.
Could you help me please?

Uzytkownik "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> napisal w
wiadomosci news:wLE6h.7391$6t.4871@newssvr11.news.prodigy.com ...
> Since this is a named instance, the port is not 1433. The SQL Server
> error log will list the listening network protocols, interfaces and ports.

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.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@poczta.onet.pl> wrote in message
news:ejfqcn$42h$1@news.onet.pl...
>I see no port number in C:\Program Files\Microsoft SQL
>Server\MSSQL.1\MSSQL\LOG.
> Could you help me please?
>
> Uzytkownik "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> napisal w
> wiadomosci news:wLE6h.7391$6t.4871@newssvr11.news.prodigy.com ...
>> Since this is a named instance, the port is not 1433. The SQL Server
>> error log will list the listening network protocols, interfaces and
>> ports.
>
>

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.

> 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.
>
>