Saturday, May 22, 2010

Set permissions on SSRS

  1. Run Sql Server Management Studio as Administrator (right click "Run as Administrator")
  2. Connect to a Reporting Services server using Windows Authentication.
  3. Right click Home, Select Properties, Select Permissions.
  4. Click Add Group or User, Type your Username, Click Ok.
  5. Check the box for Content Manager, Click Ok.

Now you can access Reporting Services via Sql Server Management Console without running as administrator.

You should also have permissions to browse Report Manager (http://localhost/Reports). If not, but you do see the Information Bar complaining then add http://localhost/ to Explorer's Trusted Sites Zone.

No comments: