April 19, 2005
Problems with SQL Server Reporting Services Permissions
In the default installation for Visual Studio Team Server Beta 2, the SQL Server Reporting Services only allow access from the server's BUILTINS/Administrators group. This prevents you from creating new team projects, viewing reports, and probably other things if your domain account is not in this group.
Nothing in the Team System permission system seems to do anything with the Reporting Services permissions, so it doesn't matter what you do from within VS 2005.
The workaround, at least for the moment, is to do the following:
Load the report site from an account in the 'BUILTIN\Administrators' group on the Team Server (http://localhost/Reports), select the 'Home' link, select the 'Properties' tab, click the 'New Role Assignment' button, and add your domain account to the SQL Server Reporting Services. I selected all of the roles and I can now access the reports and create new team projects.
I've posted a question at the TFS Forum to see if there's a better work around.
Hopefully Rob Caron can add the necessary step to the Installation Guide to avoid others having the same problems.
UPDATE: Bruce Taimana confirmed that there are, currenty, no hooks from TFS security into WSS or RS security. So, you'll need to make sure that you set all three appropriately before deploying. I'd recommend that at least the exception messages provide more information on what needs to be changed.
Posted by Mike Attili at April 19, 2005 01:25 PM