Tuesday, March 6, 2012

[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

No comments:

Post a Comment