Labels

Tuesday, 10 September 2019

SQL Server - How to find domain name of SQL Instance installed using SQL query

The below script is very useful to find the domain details of SQL Instance installed 
specially if you don't have access to RDP the server.

DECLARE @Domain VARCHAR(100)
 ,@key VARCHAR(100)

SET @key = 'SYSTEM\ControlSet001\Services\Tcpip\Parameters\'

EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE'
 ,@key = @key
 ,@value_name = 'Domain'
 ,@value = @Domain OUTPUT

SELECT @@servername [SQL Instance Name]
 ,convert(VARCHAR(100), @Domain) AS [DomainName]
 ,'10.170.201.206' IPAddress

No comments:

Post a Comment