What are the servers connected to an MSSQL

We need to know what are the other Microsoft SQL Servers connected to your server. Do you allow remote connections,...

The data is stored in the system table: sys.servers

Servers registered

SELECT server_id,
       CAST(name AS VARCHAR(20)) AS 'Server',
       CAST(product AS VARCHAR(20)) AS 'Server type',
       CAST(provider AS VARCHAR(20)) AS 'Provider',
       CAST(provider_string AS VARCHAR(20)) AS 'Provider string',
       CAST(data_source AS VARCHAR(20)) AS 'Data source',
       CAST(location AS VARCHAR(20)) AS 'Location',
       CAST(CATALOG AS VARCHAR(20)) AS 'Catalog',
       CASE is_remote_login_enabled WHEN 1 THEN 'Allowed' ELSE 'Not allowed' END AS 'Remote login',
       CASE is_system WHEN 1 THEN 'Yes' ELSE 'No' END AS 'System',
       CASE is_publisher WHEN 1 THEN 'Yes' ELSE 'No' END AS 'Publisher',
       CASE is_subscriber WHEN 1 THEN 'Yes' ELSE 'No' END AS 'Subscriber',
       CASE is_distributor WHEN 1 THEN 'Yes' ELSE 'No' END AS 'Distributor',
       CASE is_nonsql_subscriber WHEN 1 THEN 'Yes' ELSE 'No' END AS 'Non SQL subscriber',
       modify_date AS 'Last modified'
FROM sys.servers
ORDER BY 'Server';
go
server_id   Server               Server type          Provider             Provider string      Data source          Location             Catalog              Remote login System Publisher Subscriber Distributor Non SQL subscriber Last modified
----------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ------------ ------ --------- ---------- ----------- ------------------ -----------------------
0           W2K3BASE             SQL Server           SQLNCLI              NULL                 W2K3BASE             NULL                 NULL                 Allowed      No     No        No         No          No                 2007-05-07 10:35:51.153

(1 row(s) affected)
  1. server_id of 0 means that this is the local server.
  2. Check ther value of Remote login. Is this what you want and/or need?