SQL Server Error Msg 15247 – User does not have permission to perform this action

In this blog post, let’s learn about the error message “15247 – User does not have permission to perform this action.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

15247 – User does not have permission to perform this action.

Reason for the Error

SQL Server Error Msg 15247 is typically caused by a permission issue within the database. Specifically, it occurs when a user tries to perform an action for which they do not have sufficient permissions. For example, if a user attempts to create a new login or database, but does not have the required permissions to do so, they will receive this error message.

Examples of SQL Server Error Msg 15247 Here are a few examples of situations in which you might encounter SQL Server Error Msg 15247:

1. Creating a New Login: If you attempt to create a new login for a user account, but do not have sufficient permissions to do so, you may receive this error message.
2. Creating a New Database: Similarly, if you try to create a new database and do not have the necessary permissions, you will encounter this error.
3. Modifying Server Roles: If you attempt to modify server roles and do not have the appropriate permissions, you may see this error message.

Solution

There are a few different methods for resolving SQL Server Error Msg 15247, depending on the specific situation that is causing the error. Here are some of the most common fixes:

1. Grant Permissions: One solution is to grant the necessary permissions to the user or group that is encountering the error. For example, if you are trying to create a new login, you can grant the “CREATE LOGIN” permission to the user account in question. Similarly, if you are trying to create a new database, you can grant the “CREATE DATABASE” permission to the user.
2. Use an Account with Sufficient Permissions: If you do not have the necessary permissions to perform the action in question, you may need to log in with an account that does have sufficient permissions. For example, if you are trying to modify server roles, you may need to log in as the system administrator account.
3. Check the Error Log: SQL Server maintains an error log that can provide more information about the cause of the error. Check the error log to see if there are any additional details about the error and use that information to troubleshoot the issue.
4. Use SQL Server Management Studio: SQL Server Management Studio (SSMS) is a powerful tool that can help you manage your SQL Server databases. If you are encountering SQL Server Error Msg 15247, try using SSMS to perform the action in question. SSMS provides a graphical interface for performing tasks, which may make it easier to troubleshoot and resolve the error.

SQL Server Error Msg 15247 is a common error that can occur when a user does not have sufficient permissions to perform a specific action within the database. Fortunately, there are several methods for resolving this error, including granting permissions, using an account with sufficient permissions, checking the error log, and using SQL Server Management Studio. By following these tips, you should be able to resolve SQL Server Error Msg 15247 and continue working with your database without interruption.