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

    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

All replies