Agent Jobs

Add Security After SSRS Installation

Once you have SSRS 2012 installed, and configured, one of the most important things you should do is configure security for SSRS. By default all groups are essentially relegated as a basic user (regardless if you have been added as admin or not). UAC will always block access to users or applications trying to add/create/edit reports via SSRS. The solution is to simply configure security within reporting services to add the BuiltinAdministrators (or other group the admins are a part of locally on the server). Here is the process for that.

From the database server where you have installed SQL Server Reporting Services.

Open the browser with Administrative rights.

Go to this address:

http://MyServerName/Reports_MyInstanceName

Click Site Settings link on the right.

Click the Security button on the left.

Check the box next to BUILTINAdministrators, and click ‘Edit’.

Select ‘System User’, and click ‘Apply’.

You’re done.

Easy peasy.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s