July 21, 2015 at 6:09 pm
Greetings,
I have a sneaking hunch I already know the answer to my question, and that makes me sad, but I figure I'll ask here anyway in case someone has figured this out, or my Google-Fu is just failing me.
In our environment we are migrating all of our existing SSRS 2008 R2 reports to a brand new SSRS 2012 dedicated server (previously SSRS resided on the data warehouse - I know, I know). I was able to use the SSRS migration script to move all of the reports, folder structure and definitions over, and my testing shows that they're all working just fine.
In our environment, we control access to reports and folders by using NT Security Groups, specifically Local Security groups at the host level. I've already built a PowerShell script to re-create all of the security groups on the new machine, as well as re-add the users. I even captured the SID of the original group, and the new SID of the new group and stored them in a table on our DBA server.
My question is this - is it possible for me to re-map (or re-link) via T-SQL on the new server all of the security groups based on what their old SID's were and what the new SID's are? We have over 500 reports, so doing this by hand, even at the folder level, is going to be a major undertaking.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply