Advertisements
Feeds:
Posts
Comments

Archive for June, 2015


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.

Use the Add-SPShellAdmin cmdlet to add a user to the SharePoint_Shell_Access role as follows:

–If you specify only the user, the user is added to the role for the farm configuration database.

–If you use the database parameter, the user is added to the role on the farm configuration database, the Central Administration content database, and the specified database. Using the database parameter is the preferred method because most of the administrative operations require access to the Central Administration content database.

The user is added to the WSS_Admin_WPG group on all Web servers when the user is added to the SharePoint_Shell_Access role. If the target database does not have a SharePoint_Shell_Access role, the role is automatically created.

Add-SPShellAdmin -UserName CONTOSO\User1

 

This example adds a new user named User1 to the SharePoint_Shell_Access role in the farm configuration database only, and also ensures the user is added to the WSS_Admin_WPG local group on each server in the farm.

Ref: https://technet.microsoft.com/en-us/library/ff607596.aspx

Advertisements

Read Full Post »



https://technet.microsoft.com/en-us/library/cc721640.aspx


 

Read Full Post »


Error

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.

Note

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


https://msdn.microsoft.com/en-us/library/jj219068.aspx

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:

 

Install-SPRSService

 

Install-SPRSServiceProxy

 

 

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

     



 

https://msdn.microsoft.com/en-us/library/ms144289.aspx

install reporting services

https://msdn.microsoft.com/en-us/library/jj219068.aspx

 

 

 

Read Full Post »

%d bloggers like this: