Page History

...

1. Start SQL Query Analyzer, and then connect to the SQL Server instance.
2. Run the following Transact-SQL statement in SQL Query Analyzer:
   

   Code Block
   language sql
   Use master Go Xp_readerrorlog

3. In the Results pane, locate the following text:
   SQL server listening on X.X.X.X: Y
   Where X.X.X.X is the IP address of the SQL Server instance and Y is the TCP/IP port on which SQL Server is listening.
   For example, if SQL server is listening on 10.150.158.246: 1433, 10.150.158.246 is the IP address of the SQL Server and 1433 is the TCP/IP port on which the SQL Server instance is listening.

...