SQLTeam.com | Weblogs | Forums

User does not have permission to run DBCC PAGE

Hi,

We have configured Alwayson configuration. Primary-A and secondary-B.
When we are connecting SAP Application using Listener, Their is no error is showing.

If we fail over to secindary. Now B is primary. The SAP Application through listener we can see below below error.

user does not have permission to run DBCC PAGE.[WP32] [sap_get_last_dbcc_checkdb:build_n_exec]

User is P38. Same kind of permissions are present for user P38 in both replicas. (I transfered same logins to secondary and manually also i checked in both replicas. Everything is matching.)

Kindly help me how to resolve the error?

Thanks,
Pols