[SQL Server]Cannot alter the server role ‘sysadmin’, because it does not exist or you do not have permission.

You are getting below error message while performing the SAP homogeneous system copy with Microsoft SQL Server.

(Last error reported by the step: Errors when executing sql command: 
[Microsoft][SQL Server Native Client 11.0][SQL Server]
Cannot alter the server role 'sysadmin', 
because it does not exist or you do not have permission.

Solution

Login to the Microsoft SQL Management Studio with different authorized user. In this example, we are using “sa” ID.
Go to Security and right click on the impacted user.

Jump to Server Roles and check the box to assign the sysadmin server role. Click OK to apply the changes.

You can retry the system copy execution.

You May Also Like

Leave a Reply?