Configure a Native Mode Report Server for Local Administration (SSRS)
Deploying a Reporting Services report server on one of the following operating systems requires more configuration steps if you want to administer the report server instance locally. This topic explains how to configure the report server for local administration. If you have not yet installed or configured the report server, see Install SQL Server from the Installation Wizard (Setup) and Manage a Reporting Services Native Mode Report Server.
|Applies to: Reporting Services Native mode|
Windows Server 2012 R2
Windows Server 2012
Windows Server 2008 R2
Windows Server 2008
Because the noted operating systems limit permissions, members of the local Administrators group run most applications as if they are using the Standard User account.
While this practice improves the overall security of your system, it prevents you from using the predefined, built-in role assignments that Reporting Services creates for local administrators.
Overview of configuration changes
The following configuration changes configure the server so that you can use standard user permissions to manage report server content and operations:
Add Reporting Services URLs to trusted sites. By default, Internet Explorer running on the listed operating systems runs in Protected Mode, a feature that blocks browser requests from reaching high-level processes that run on the same computer. You can disable protected mode for the report server applications by adding them as Trusted Sites.
Create role assignments that grant you, the report server administrator, permission to manage content and operations without having to use the Run as administrator feature on Internet Explorer. By creating role assignments for your Windows user account, you gain access to a report server with Content Manager and System Administrator permissions through explicit role assignments that replace the predefined, built-in role assignments that Reporting Services creates.
To configure local Report Server and web portal administration
Complete the configuration steps in this section if you are browsing to a local report server and you see errors similar to the following:
'Domain\[user name]' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
Trusted Site settings in the browser
Open a browser window with Run as administrator permissions. From the Start menu, right-click Internet Explorer, and select Run as administrator.
Select Yes when prompted to continue.
In the URL address, enter the web portal URL. For instructions, see The web portal of a report server (SSRS Native Mode).
Click Internet Options.
Click Trusted Sites.
Clear the check box Require server certification (https:) for all sites in this zone if you are not using HTTPS for the default site.
Web portal folder settings
In the web portal, on the Home page, click Manage folder.
In the Manage folder page, click Security and then select Add group or user.
In the New Role Assignment page, in the Group or user field, type your Windows user account in this format:
Select Content Manager.
Web portal site settings
Open your browser with administrative privileges and browse to web portal,
Select the gear icon on the top row the Home page and then Site Settings from the dropdown menu.
If you do not see the Site Settings option, close and reopen your browser and browse to web portal with administrative privileges.
On the Site settings page, select Security and then select Add group or user.
In the Group or user name field, type your Windows user account in this format:
Select System Administrator.
Close web portal.
Re-open the web portal in Internet Explorer, without using Run as administrator.
To configure SQL Server Management Studio (SSMS) for local report server administration
By default, you cannot access all of the report server properties available in SQL Server Management Studio unless you start Management Studio with administrative privileges.
To configure Reporting Services role properties and role assignments so you do not need to start Management Studio with elevated permissions each time:
From the Start menu, right-click Microsoft SQL Server Management Studio, and then click Run as administrator.
Connect to your local Reporting Services server.
In the Security node, click System Roles.
Right-click System Administrator and then click Properties.
In the System Role Properties page, select View report server properties. Select any other properties you want associated with members of the system administrators role.
Close Management Studio
To add a user to the system role "system administrator", see the Web portal Site Settings section earlier in this article.
Now when you open Management Studio and do not explicitly select Run as administrator you have access to the report server properties.
To configure SQL Server Data Tools (SSDT) to publish to a local report server
If you installed SQL Server Data Tools on one of the operating systems listed in the first section of this topic, and you want SSDT to interact with a local Native mode report server, you will experiences permission errors unless you open SQL Server Data Tools (SSDT) with elevated permissions or configure reporting services roles. For example, if you do not have sufficient permissions, you experience issues similar to the following:
When you attempt to deploy report items to the local report server, you see an error message similar to the following in the Error List window:
- The permissions granted to user 'Domain\<user name>' are insufficient for performing this operation.
To run with elevated permissions each time you open SSDT:
From the start menu, select Microsoft SQL Server and then right-click SQL Server Data Tools. Click Run as administrator
Select Yes when prompted to continue.
You should now be able to deploy reports and other items to a local report server.
To configure Reporting Services role assignments so you do not need to start SSDT with elevated permissions each time:
An additional and common configuration step related to Reporting Services administration is to open port 80 in Windows Firewall to allow access to the report server computer. For instructions, see Configure a Firewall for Report Server Access.