Applies to: SharePoint Foundation 2013, SharePoint Server 2013 Enterprise

When you run this cmdlet to add a user to the SharePoint_Shell_Access role, you must have membership in the securityadmin fixed server role on the SQL Server instance, membership in the db_owner fixed database role on all affected databases, and local administrative permission on the local computer.

This cmdlet is intended only to be used with a database that uses Windows authentication. There is no need to use this cmdlet for databases that use SQL authentication; in fact, doing so may result in an error message.

Continue reading


User permissions and permission levels in SharePoint 2013


You do not see the SQL Server Reporting Services service in SharePoint Central Administration after installing SQL Server 2012 SSRS in SharePoint mode


This SQL Server Reporting Services (SSRS) functionality is not supported. Use Central Administration to verify and fix one or more of the following issues:•A report server URL is not configured. Use the SSRS Integration page to set it.

•The SSRS service application proxy is not configured. Use the SSRS service application pages to configure the proxy.

•The SSRS service application is not mapped to this web application. Use the SSRS service application pages to associate the SSRS service application proxy to the Application Proxy Group for this web application.



  • up after installation is complete.

Step 1: Install Reporting Services Report Server in SharePoint mode


This step installs a Reporting Services report server in SharePoint mode and the Reporting Services add-in for SharePoint products. Depending on what is already installed on your computer, you may not see some of the installation pages described in the following steps.

  • Run the SQL Server Installation Wizard (Setup.exe).
  • Click Installation in the left side of the wizard and then click New SQL Server stand-alone installation or add features to an existing installation.
  • Click OK on the Setup Support Rules page, assuming all rules passed.
  • Click Install on the Setup Support Files page. Depending on what is already installed on your computer, you might see the following message:
    • “One or more affected files have operations pending. You must restart your computer after the setup process is completed.”
    • Click Ok.
  • Click Next after the support files have completed installing and the Support Rules pages show a status of Passed. Review any warnings or blocking issues.
  • On the Installation Type page, click Add features to an existing instance of SQL Server 2014. Select the correct instance in the drop-down list and click Next.
  • If you see the Product Key page, type your key or accept the default of the ‘Enterprise Evaluation’ edition.

    Click Next.

  • If you see the License terms page, review and accept the license terms. Microsoft appreciates you clicking to agree to send feature usage data to help improve product features and support.

    Click Next.

  • If you see the Setup Role page, select SQL Server Feature Installation

    Click Next



  • Select the following on the Feature Selection page:
    • Reporting Services – SharePoint
    • Reporting Services add-in for SharePoint Products.

       The installation wizard option for installing the add-in is new with the SQL Server 2014 release.

    • If you do not already have an instance of SQL Server Database Engine, you could also select Database Engine Services and Management Tools Complete for a complete environment.

    Click Next.



  • If you see the Installation Rules page. Review any warnings or blocking issues. Then click Next
  • If you selected the Database Engine services, accept the default instance of MSSQLSERVER on the Instance Configuration page and click Next.

    The Reporting Services SharePoint service architecture is not based on a SQL Server “instance” as was the previous Reporting Services architecture.

  • Review the Disk Space Requirements page and click Next.
  • If you see the Server Configuration page type appropriate credentials. If you want to use the Reporting Services data alerting or subscription features, you need to change the Startup Type for SQL Server Agent to Automatic. You may not see the Server Configuration page, depending on what is already installed on the computer.

    Click Next.

  • If you selected the Database Engine services, you will see the Database Engine Configuration page, add appropriate accounts to the list of SQL Administrators and click Next.
  • On the Reporting Services Configuration page you should see the Install only option is selected. This option installs the report server files, and does not configure the SharePoint environment for Reporting Services.


When the SQL Server installation is complete, follow the other sections of this topic to configure the SharePoint environment. This Includes installing the Reporting Services shared service and creating Reporting Services service applications.

  • Help Microsoft improve SQL Server features and services by clicking the check box to send error reports on the Error Reporting page.

    Click Next.

  • Review any warnings and then click Next on the Installation Configuration Rules page.
  • On the Ready to Install page, review the installation summary and then click Next. The summary will include a Reporting Services SharePoint Modechild node that will show a value of SharePointFilesOnlyMode. Click Install.
  • The installation will take several minutes. You will see the Complete page with the features listed and the status of each feature. You may see an information dialog indicating the computer needs to be restarted.

Step 2: Register and Start the Reporting Services SharePoint Service

Description: If after successfully installing SQL Server 2014  Reporting Services in SharePoint mode and the SQL Server 2014  Reporting Services Add-in for SharePoint 2010, you do not see “SQL Server Reporting Services” in the following two menus, then the Reporting Services service has not been registered:

  • SharePoint 2010 Central Administration -> “Application Management” -> “Manage Services on Server” page
  • SharePoint 2010 Central Administration -> “Application Management” -> “Manage Service Applications” ->”New” menu

Workaround: To register and start the Reporting Services SharePoint Services, complete the following:

  1. On the computer that runs SharePoint 2010 Central Administration
    1. Open the SharePoint 2010 Management Shell with administrator privileges. Right click the icon and click, “Run As Administrator”. Run the following three cmdlets from the shell:







Get-SPServiceInstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance



  1. Verify the Reporting Services Service shows status as “Started” on the page: SharePoint 2010 Central Administration -> “Application Management” -> “Manage Services on Server


install reporting services