Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

How to get the TCP / IP Settings of a SQL Server?

Rajanand Ilangovan's photo
Rajanand Ilangovan
·Sep 16, 2022·

1 min read

This query gets tcp/ip settings of the SQL Server from registry.

SELECT registry_key, value_name, value_data 
FROM sys.dm_server_registry
WHERE registry_key LIKE '%SuperSocketNetLib%'

image.png

An another way to check is from SQL Server configuration manager.
You can find the SQL Server configuration manager from the below path. The file name will be different based on which version of SQL Server.

C:\Windows\SysWOW64\SQLServerManager15.msc image.png

Right click and open the properties to check the settings.

image.png

Impressum