Unable to start the SQL Server End Points

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  August 30, 2009 at 11:57 pm

  #141127

  --Created a new End Point:

  create endpoint [MyEndpoint] state = stopped as

  tcp (listener_port = 6060) FOR tsql ()

  -- Granted to the End Point:

  GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] to [public]

  -- Checked the creation of the new End Point:

  select name, port, is_dynamic_port, state from sys.tcp_endpoints

  name port is_dynamic_port state

  ------------------------------ ----------- --------------- -----

  Dedicated Admin Connection 0 1 0

  TSQL Default TCP 0 1 0

  MyEndpoint 6060 0 1

  (3 row(s) affected)

  -- But unable to change the "state" of the End Point :: TSQL Default TCPto 1.

  --executed the below statement, but getting an error.

  alter tcp_endpoints [TSQL Default TCP] set state = 1 where name ='TSQL Default TCP'

  Error::

  Msg 343, Level 15, State 1, Line 1

  Unknown object type 'tcp_endpoints' used in a CREATE, DROP, or ALTER statement.

  Can anyone please suggest, how to correct the "alter" statement??

  Thanks.

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 31, 2009 at 4:04 am

  #1046768

  alter tcp_endpoints [TSQL Default TCP] set state = 1 where name ='TSQL Default TCP'

  If this really was the statement you executed, then change it to:

  Alter Endpoint [TSQL Default TCP] set state = 1 where name ='TSQL Default TCP'

  [font="Verdana"]Markus Bohse[/font]

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  August 31, 2009 at 8:36 am

  #1046888

  Thanks Marcus...

  Thanks.