Posted by Dan Guzman on 11/16/06 02:53
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.
>
>
Navigation:
[Reply to this message]
|