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?