locked
Can't Drop User - "The server principal owns one or more endpoints and cannot be dropped" RRS feed

  • Question

  • I have a domain user login in SQL that is the account of the former employee who installed System Center ConfigMgr 2012. I want to drop his login but when I do I get this message, "The server principal owns one or more endpoints and cannot be dropped". So in SSMS I go to Server Objects>Endpoints>Service Broker and I see ConfigMgrEndpoint. Right click ConfigMgrEndpoint>Create To>New Query Editor Window results in this:

    /****** Object:  Endpoint [ConfigMgrEndpoint]    Script Date: 04/30/2013 07:41:17 ******/
    CREATE ENDPOINT [ConfigMgrEndpoint]
        AUTHORIZATION [DOMAIN\userIwannadelete]
        STATE=STARTED
        AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL)
        FOR SERVICE_BROKER (MESSAGE_FORWARDING = ENABLED
    , MESSAGE_FORWARD_SIZE = 5
    , AUTHENTICATION = CERTIFICATE [ConfigMgrEndpointCert]
    , ENCRYPTION = REQUIRED ALGORITHM AES)
    GO

    What do I need to do to change AUTHORIZATION to someone other than this guy?


    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Tuesday, April 30, 2013 12:50 PM

Answers

  • According to the documentation, you will need to drop/recreate it.
    • Marked as answer by John Marcum Tuesday, April 30, 2013 4:00 PM
    Tuesday, April 30, 2013 2:40 PM
  • Hi,

    Just to add to the unanimous chorus for dropping and recreating, I've done this exact thing with an SCCM endpoint and had no problems.



    Thanks, Andrew


    Tuesday, April 30, 2013 4:01 PM

All replies

  • According to the documentation, you will need to drop/recreate it.
    • Marked as answer by John Marcum Tuesday, April 30, 2013 4:00 PM
    Tuesday, April 30, 2013 2:40 PM
  • I believe you can alter the endpoint to use another login

    http://technet.microsoft.com/en-us/library/ms186332.aspx


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Tuesday, April 30, 2013 3:53 PM
  • Thanks guys. I recreated it using another login. Scary for me because I'm not sure how it got created to begin with and/or what it's used for.


    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Tuesday, April 30, 2013 4:01 PM
  • Hi,

    Just to add to the unanimous chorus for dropping and recreating, I've done this exact thing with an SCCM endpoint and had no problems.



    Thanks, Andrew


    Tuesday, April 30, 2013 4:01 PM