user does not have permission to run DBCC PAGE

• pols

  SSC Eights!

  Points: 935

  More actions

  July 25, 2022 at 12:38 pm

  #4067853

  Hi,

  We have configured Always on 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 secondary. 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

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  July 25, 2022 at 1:18 pm

  #4067861

  DBownership also by the same account ? ( check when primary on instance )

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me