Find IP

Question

Hello,

On a Windows 2008 server how can I find which IP and port is assigned to the SQL server?

I know in my Windows 2008 hosting VPS service the SQL Server has its own IP. How can I find it?

Thanks,
Miguel

Answer 1

For a standalone SQL installation, the SQL instance listens on the IP Address assigned to the host machine. If you want to find out which IP Address the SQL instance is listening on, then you could look into the SQL Errorlog and look for the following lines:

Server is listening on [ 'any' <ipv4> 1435].

If you have configured SQL to listen only on a particular IP Address using your SQL Configuration Manager, then you will find the IP Address instead of "any". The number after that is the Port Number.

SQL Server Errorlogs are normally located @

<install directory>:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG\

This can also be found out by executing sp_readerrorlog from a Query Window in Management Studio or Query Analyzer.

Ref:
http://msdn.microsoft.com/en-us/library/ms177440.aspx
http://support.microsoft.com/default.aspx/kb/823938

---

This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL