newbie: telnet localhost 1433 fails

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.plwrote in message
news:ejeg8o$oiv$1@.news.onet.pl...

Quote:

Originally Posted by

>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.netnapisal w
wiadomosci news:wLE6h.7391$6t.4871@.newssvr11.news.prodigy.com ...

Quote:

Originally Posted by

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.plwrote in message
news:ejfqcn$42h$1@.news.onet.pl...

Quote:

Originally Posted by

>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.netnapisal w
wiadomosci news:wLE6h.7391$6t.4871@.newssvr11.news.prodigy.com ...

Quote:

Originally Posted by

>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.netnapisal w
wiadomosci news:yoQ6h.6288$IR4.968@.newssvr25.news.prodigy.net ...

Quote:

Originally Posted by

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

Quote:

Originally Posted by

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.plwrote in message
news:ejh2j5$lao$1@.news.onet.pl...

Quote:

Originally Posted by

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.netnapisal w
wiadomosci news:yoQ6h.6288$IR4.968@.newssvr25.news.prodigy.net ...

Quote:

Originally Posted by

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

>
>