For providing TCP/IP communication between your SQL and other applications you need to create end point for that .
Creating end points is a series of steps
Message
Contract
Queue
Service
Route
Endpoint
ALTER DATABASE student
SET ENABLEBROKER;
CREATE ENDPOINT mydemo
STATE = STARTED
AS TCP
(
LISTENERPORT = 4022
)
FOR SERVICEBROKER
(
AUTHENTICATION = WINDOWS,
ENCRYPTION = DISABLED
)
0 Comment(s)