Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Endpoints in SQL Server

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 285
    Comment on it

    Endpoints in SQL

    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)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: