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

I had to delete the Database Mirroring endpoint which he must have created
but I know we weren't using.
Thanks for your help Ekrem!

--
jonphilip


"Ekrem Önsoy" wrote:

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: 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 delete now. ... Open it up and go to Server Objects and then Endpoints from the Object Explorer. ... Microsoft SQL Server Management Studio Express ...
    (microsoft.public.sqlserver.security)
  • 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: ... 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)