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]
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)
What do I need to do to change AUTHORIZATION to someone other than this guy?
John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/
I believe you can alter the endpoint to use another login
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.