Post reply

Problem for changing the endopoint SQL server

  • December 23, 2018 at 2:55 am

    #382534

    Hello everyone
    I configured my mirroring production server through an account that privileges sysadmin
    now I want to decrease the right of this account if proceeding to do
     GRANT CONNECT ON ENDPOINT::[Mise en miroir] TO [Domaine\user1]
    I got this error message "
    You can not grant, deny, or revoke permissions to its, dbo, entity owner, information_schema, sys, or yourself"
    Who has an idea how I can solve this problem

  • December 23, 2018 at 8:02 am

    #2017168

    I assume you're logged in as that domain user? If you are a sysadmin, however, you'll already have the permission, so you have no need to grant it to yourself.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • December 23, 2018 at 11:37 am

    #2017172

    the problem that the account used has the profile sysadmin then i have removed the role sysadmin on this account

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

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