Explicit Hierarchy Security Not working the same in all environments RRS feed

  • Question

  • We have two servers, one where the explicit hierarchy security works and one where it only saves the top node.   Everything about the model and the hierarchy are exactly identical, but yet on our Dev server it works when we assign security, you see all four levels saved.  On our Test box, it only will save the top root level.  I've attached screen shots.   Please advise what I can check to see why one server works and one doesn't.

    Working security screen shot

    Working security

    Non Working Security

    Non working Security Screen shot

    Monday, April 16, 2012 5:01 PM


  • Discovered the issue.   Turns out that the service account needs to have SysAdmin rights to the database and it works.

    • Marked as answer by Challen Fu Wednesday, April 18, 2012 9:39 AM
    Monday, April 16, 2012 7:40 PM