MSSQL一个实例多个端口。

 

 MSSQL一个实例多个端口

------具体含义不清楚，留个尸体，待续。。。

1、tcp/ip添加1433,8000

2、use [master]
GO
CREATE ENDPOINT TSQL_Settlement
STATE = STARTED
AS TCP ( LISTENER_PORT = 8000 )
FOR TSQL ()

USE [master]

3、GRANT CONNECT ON ENDPOINT::TSQL_Settlement TO [public]
GO

4、做个校验
SELECT *
FROM sys.endpoints;