尝试一下：

USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on' 
GO

http： //www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/