Re: The server principal owns an endpoint and cannot be dropped ???

Hello!

It seems that you created an endpoint with the Login which you are trying to delete now. That Login owns that endpoint so you need to delete the endpoint first.

You can query your endpoints using SELECT * FROM sys.endpoints.

You can see endpoints using SSMS. Open it up and go to Server Objects and then Endpoints from the Object Explorer. Delete that endpoint and then you'll be able to delete your mentioned Login.

--
Ekrem Önsoy



"jonphilip" <jonphilip@xxxxxxxxxxxxxxxxx> wrote in message news:B4CD8D4C-6E88-4C05-83F4-F92D8A05B289@xxxxxxxxxxxxxxxx
I have a user that is no longer employed and when I try to delete his SQL
login account, I get the following message:

****************************************************
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Drop failed for Login 'xxxx\zzzz'. (Microsoft.SqlServer.Express.Smo) for
help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Login&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal owns an endpoint and cannot be dropped. (Microsoft SQL
Server, Error: 15141)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=15141&LinkId=20476
****************************************************

I have gone through every table and looked at all of the table logins and
removed his account every place that I found it. Is there a way to query SQL
to return a list of what objects a particular owns so I can figure out what
is preventing me from removing his account?

Thanks,

jonphilip

.

Relevant Pages

  • Re: GRANT CONNECT to group? - How?
    ... Since you created a SQL Server login, ... If the web service is running already under a domain account, ... then you should be able to make a trusted connection ... the account can use the endpoint. ...
    (microsoft.public.sqlserver.connect)
  • Re: The server principal owns an endpoint and cannot be dropped ??
    ... It seems that you created an endpoint with the Login which you are trying to ... Microsoft SQL Server Management Studio Express ...
    (microsoft.public.sqlserver.security)
  • Re: ... forbidden with client authentication scheme Anonymous
    ... Both the client and server use the same classes for WCF. ... A secure Host/Receiver is created as follows: ... // non-secure endpoint code not shown ... the server posts to the client's endpoint. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: ... forbidden with client authentication scheme Anonymous
    ... the service that is acting as the client is not setup as such. ... Both the client and server use the same classes for WCF. ... A secure Host/Receiver is created as follows: ... // non-secure endpoint code not shown ...
    (microsoft.public.dotnet.framework.webservices)
  • RE: Getting 401 Access denied w/ Endpoint in SQL 2005 from C# client
    ... As for the SQL2005's endpoint SOAP webservice, ... we may need to check the client side code.... ... Getting 401 Access denied w/ Endpoint in SQL 2005 from C# ... the windows app is begin deployed to a Windows 2000 Server ...
    (microsoft.public.sqlserver.connect)