>>>>Hi,
>>>>
>>>>When a client PC connects to SQL Server (EXPRESS) via remote TCP/IP protocol, what port on the server where SQL Server resides is being used?
>>>>
>>>>TIA.
>>>
>>>Take a look at answers to this question in MSDN
How to find port SQL Server listens to>>
>>I noticed that on my server the port no. entry is left blank. Do you think it means that the default (1433) is being used in this case?
>>
>>Also, I noticed that IPs (IP1, IP2, etc.) have Active set as yes but Enabled set as No. Do you know what is the difference?
>
>The port name you should find in the Error Messages (which you can find in the Event Viewer). Most likely it's the default (1433) port.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
