[MSSQL] Which port

Hi all,
I have the following problem.
I know that MSSQL resides under given IP adress but I do not know under
which port. Who konows how to determine this port number?
Best wihses,
Marek Powichrowski
Hi,
Open the SQL Server Error log and see which port SQL Server is using. By
default SQL Server default instance use the port 1433.
You could also use the Server network utility from SQL Server program groups
of SQL Server machine
and click properties in TCP/IP protocol to get the port number.
Thanks
Hari
SQL Server MVP
"news.task.gda.pl" <marek@.telbank.pl> wrote in message
news:d77u99$dgu$1@.korweta.task.gda.pl...
> Hi all,
> I have the following problem.
> I know that MSSQL resides under given IP adress but I do not know under
> which port. Who konows how to determine this port number?
> Best wihses,
> Marek Powichrowski
>
|||Uytkownik "Hari Prasad" <hari_prasad_k@.hotmail.com> napisa w wiadomoci
news:eDkDhevYFHA.1148@.tk2msftngp13.phx.gbl...
> Hi,
> Open the SQL Server Error log and see which port SQL Server is using. By
> default SQL Server default instance use the port 1433.
> You could also use the Server network utility from SQL Server program
> groups of SQL Server machine
> and click properties in TCP/IP protocol to get the port number.
Hari,
I know this but I want to know how to do this without network utility and
serwer error log. What I must send to SQL serwer and what resposne from
given port give me information that under given port resides MSSQL?
Best wishes,
Marek Powichrowski

[MSSQL] Which port

Hi all,
I have the following problem.
I know that MSSQL resides under given IP adress but I do not know under
which port. Who konows how to determine this port number?
Best wihses,
Marek PowichrowskiHi,
Open the SQL Server Error log and see which port SQL Server is using. By
default SQL Server default instance use the port 1433.
You could also use the Server network utility from SQL Server program groups
of SQL Server machine
and click properties in TCP/IP protocol to get the port number.
Thanks
Hari
SQL Server MVP
"news.task.gda.pl" <marek@.telbank.pl> wrote in message
news:d77u99$dgu$1@.korweta.task.gda.pl...
> Hi all,
> I have the following problem.
> I know that MSSQL resides under given IP adress but I do not know under
> which port. Who konows how to determine this port number?
> Best wihses,
> Marek Powichrowski
>|||Uytkownik "Hari Prasad" <hari_prasad_k@.hotmail.com> napisa w wiadomoci
news:eDkDhevYFHA.1148@.tk2msftngp13.phx.gbl...
> Hi,
> Open the SQL Server Error log and see which port SQL Server is using. By
> default SQL Server default instance use the port 1433.
> You could also use the Server network utility from SQL Server program
> groups of SQL Server machine
> and click properties in TCP/IP protocol to get the port number.
Hari,
I know this but I want to know how to do this without network utility and
serwer error log. What I must send to SQL serwer and what resposne from
given port give me information that under given port resides MSSQL?
Best wishes,
Marek Powichrowski

@loopback_detection

How do I determine if a subscription has loopback
detection enabled?
sp_helpsubscription publicationname and look for the value of
loopback_detection. A non zero value means its enabled.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:0f3e01c4a59a$3c36afa0$a601280a@.phx.gbl...
> How do I determine if a subscription has loopback
> detection enabled?