Lite info kring ip och uppkoppling

Här är ett litet script som tar fram ipnummer, namn typ av nät, port och om du använder Kerberos.

SELECT Serverproperty('ComputerNamePhysicalNetBios') AS 'Is_Current_Owner', 
       Serverproperty('MachineName')                 AS 'MachineName', 
       CASE 
         WHEN @@ServiceName = RIGHT (@@Servername, Len(@@ServiceName)) THEN 
         @@Servername 
         ELSE @@servername + ' \ ' + @@Servicename 
       END                                           AS 
       '@@Servername \ Servicename', 
       Connectionproperty('net_transport')           AS net_transport, 
       Connectionproperty('local_tcp_port')          AS local_tcp_port, 
       dec.local_tcp_port, 
       Connectionproperty('auth_scheme')             AS auth_scheme, 
       Connectionproperty('local_net_address')       AS local_net_address, 
       dec.local_net_address                         AS 'dec.local_net_address' 
FROM   sys.dm_exec_connections AS dec 
WHERE  dec.session_id = @@SPID;