Post reply

Dropping login associated with endpoints as granter in DB Mirroring

  • March 27, 2009 at 3:37 pm

    #202780

    I am trying to drop a login from sql server 2008 but find user has granted endpoints(65536, db mirroring) to grantees NT AUTHORITY\SYSTEM and sqlserver service account , i find the same thru below query.

    select * from sys.server_permissions

    where grantor_principal_id =

    (select principal_id from sys.server_principals where name = 'Domain\username')

    is there any way which i can use to avoid dropping of these endpoints and mirroring and simply transfer the ownership etc and can drop the login

    thanks for your time..

  • March 27, 2009 at 6:45 pm

    #967814

    What error do you receive when you try to drop it?

    MJ

  • March 28, 2009 at 4:13 pm

    #967952

    Here is the error message due to endpoints

    Login 'domain\username' has granted one or more permission(s). Revoke the permission(s) before dropping the login. (Microsoft SQL Server, Error: 15173)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply