Tuesday, 14 May 2019

Database Restoration error User does not have permission to perform this action

User does not have permission to perform this action

When we trying to restore a database we got below error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore of database 'xxxxxxx' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: User does not have permission to perform this action. (Microsoft.SqlServer.SmoExtended)

Cause:

No active connection on that database even though got same error finally we identified the reason is one of the orphaned replication job

Fix:

We removed that orphaned replication job from SQL agent, after that we are able to complete the restoration.

No comments:

Post a Comment

Disable CDC at table level

 How to Disable CDC( Change Data Capture) for tables Change Data Capture (cdc) property is disabled as default.  here I will Query you how t...