not all privileges or groups referenced are assigned to the caller

kedar giri 81 Reputation points
2024-10-30T11:47:13.32+00:00

While changing the configuration for Instance File Initialization through SQL Server Configuration Manager, I encountered the error: "Not all privileges or groups referenced are assigned to the caller (0x80070514)." This error occurred after I modified the SQL Server service account name. How can I resolve this issue? any have any suggestions?

SQL Server | Other
{count} votes

2 answers

Sort by: Most helpful
  1. Zahid Butt 961 Reputation points
    2024-10-30T14:42:44.4166667+00:00

    Hi,

    I got it done while changing my windows user. So its permissions issue.

    Since I am using my office machine, first I tried to make changes with my widows authentication user which has limited rights and got error.

    Then I used windows authentication user which has domain level admin rights & its done.

    I got this idea from below link:

    https://serverfault.com/questions/370461/not-all-privileges-or-groups-referenced-are-assigned-to-the-caller-when-conne

    Further you may get help from here (regarding access):

    https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization?view=sql-server-ver16

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2024-10-31T06:26:32.6933333+00:00

    Hi @kedar giri

    Instant file initialization is only available if the SQL Server (MSSQLSERVER) service account has been granted SE_MANAGE_VOLUME_NAME. Members of the Windows Administrator group have this right and can grant it to other users by adding them to the Perform Volume Maintenance Tasks security policy.

    Please make sure that your account has the required permission.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.