How to get the IP Address of the connected SQL Server?

On 01 May, 2015

MS SQL DBA

By : Charith Silva

No Comments

You might need to know the IP Address and the TCP Port of the currently connected SQL Server; this simple SQL Script will help you to find the Server IP Address. This script only works for connections that are using the TCP/IP protocol.

(Note: this script only works on or above SQL 2008 version)

SELECT 
SERVERPROPERTY(N'MachineName') AS [Server Name],
@@SERVERNAME AS [SQL Server Instance],
CONNECTIONPROPERTY('local_net_address') AS [Server IP Address], 
CONNECTIONPROPERTY('local_tcp_port') AS [Server TCP Port]

SELECT

SERVERPROPERTY(N'MachineName') AS [Server Name],

@@SERVERNAME AS [SQL Server Instance],

CONNECTIONPROPERTY('local_net_address') AS [Server IP Address],

CONNECTIONPROPERTY('local_tcp_port') AS [Server TCP Port]

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva