---
title: "SQL - Query to get server's IP address"  
description: "SQL - Query to get server's IP address"  
author: "Anonymous User"  
published: 2013-04-16  
updated: 2013-04-16  
canonical: https://www.mindstick.com/forum/767/sql-query-to-get-server-s-ip-address  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# SQL - Query to get server's IP address

Hi All!\
Is there a [query in SQL](https://www.mindstick.com/forum/160921/help-with-writing-a-recursive-query-in-sql-server) [Server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over) 2005 I can use to get the server's IP or [name](https://yourviews.mindstick.com/view/87450/how-to-generate-a-brand-name-using-linkedin-comprehensive-guide)?\
Thanks in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)!

## Replies

### Reply by AVADHESH PATEL

Hi Jeet!\
You can get server name as below\
SELECT @@SERVERNAME;\
IP Addresss or Name as below\
SELECT SERVERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SERVERNAME')) ,LOCAL_NET_ADDRESS AS 'IPAddressOfSQLServer' ,CLIENT_NET_ADDRESS AS 'ClientIPAddress' --, NETBIOS = CONVERT(NVARCHAR(128),SERVERPROPERTY('COMPUTERNAMEPHYSICALNETBIOS')) --, [MAXDOP] = (SELECT VALUE_IN_USE FROM SYS.CONFIGURATIONS WHERE NAME='MAX DEGREE OF PARALLELISM') --, SQLMEMORY = (SELECT VALUE_IN_USE FROM SYS.CONFIGURATIONS WHERE NAME='MAX SERVER MEMORY (MB)') --, EDITION = CONVERT(NVARCHAR(128),SERVERPROPERTY('EDITION')) ---, COLLATION = CONVERT(NVARCHAR(128),SERVERPROPERTY('COLLATION')) --, ISCLUSTERED = CONVERT(BIT,SERVERPROPERTY('ISCLUSTERED')) --, ISFULLTEXTINSTALLED = CONVERT(BIT,SERVERPROPERTY('ISFULLTEXTINSTALLED')) --, ISINTEGRATEDSECURITYONLY = CONVERT(BIT,SERVERPROPERTY('ISINTEGRATEDSECURITYONLY')) --, FILESTREAMCONFIGUREDLEVEL = CONVERT(TINYINT,SERVERPROPERTY('FILESTREAMCONFIGUREDLEVEL')) --, FILESTREAMEFFECTIVELEVEL = CONVERT(TINYINT,SERVERPROPERTY('FILESTREAMEFFECTIVELEVEL')) --, PRODUCTVERSION = CONVERT(NVARCHAR(128),SERVERPROPERTY('PRODUCTVERSION')) --, SQLCHARSETNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SQLCHARSETNAME')) --, SQLSORTORDERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SQLSORTORDERNAME')) FROM SYS.DM_EXEC_CONNECTIONS WHERE SESSION_ID = @@SPID\


---

Original Source: https://www.mindstick.com/forum/767/sql-query-to-get-server-s-ip-address

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.