sql server connect: 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


[quoted text, click to view]

U¿ytkownik "Hari Prasad" <hari_prasad_k@hotmail.com> napisa³ w wiadomo¶ci
news:eDkDhevYFHA.1148@tk2msftngp13.phx.gbl...
[quoted text, click to view]

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