操作步驟：

1、打開本地Microsoft SQL Server Management Studio（SSMS）客戶端。
2、執行以下SQL語句，獲取所有連接ip

SELECT SY.SPID, SY.LOGINAME, SY.LOGIN_TIME, SY.HOSTNAME, SY.PROGRAM_NAME, DM.CLIENT_TCP_PORT, DM.CLIENT_NET_ADDRESS
FROM SYS.SYSPROCESSES AS SY 
INNER JOIN SYS.DM_EXEC_CONNECTIONS AS DM
ON SY.SPID = DM.SESSION_ID
WHERE SY.SPID > 50 AND DM.AUTH_SCHEME='SQL'