Problem reinstalling reporting services
-
Just for reference to anyone reading this. We cracked it, but not without some interesting repercussions.
It appeared that the link between the NT groups and SRS's interpretation of them had broken down.
We had to destroy the encryption before we could do anything, but the odd thing was that we could see all the reports and folders directly from the server, but when an administrator logged in remotely - although permissions we set correctly - some objects were inaccessible, others could be seen but not manipulated, others could be seen and fully manipulated!
We solved it by creating a new root folder tree and moving the contents of each existing folder into the new folder. We then destroyed the original folder and renamed the new one. The permissions seemed to repair.
All we had to do then was go into EVERY data connection object and resupply the connections string, usernames and password.
BUT IT WORKED! AFTER 3 DAYS PULLING MY HAIR OUT - IT WORKED!!!!
If anyone wants me, I'll be in the pub!
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply