Creating a SQL Server 2012 playground (part VIII)

Introduction

In this blogpost I'll show the installation you  the Reporting Services Sharepoint mode as a Single Farm. The steps include installation of some Features of SQL Server 2012 and a configuration of Sharepoint 2010 Central administration. I've used an article on MSDN for this blogpost.


This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installing RS Sharepoint in Single Server Mode

Run the SQL Server 2012 installation wizard again and click on "installation".  Choose New SQL Server stand alone installation or add features to an existing installation. Press a couple of times on "OK", "Next" and "Install" until you reach the following window.

Confirm that the options are selected in the red box of the window below.

If they are unchecked install them.

Configuring SharePoint Central Administration

Now the necessary files are already installed during the installation process of SQL Server 2012 ( (part III).  But, the Services need to be registered into the Sharepoint Farm. Therefore some cmdlets needs to be run. Goto Start, Microsoft SharePoint 2010 Products and right click on SharePoint 2010 Management Shell and Click Run as Administrator.

If you haven't configured Sharepoint 2010 the following information is shown. Go to the blogpost VII for configuration of Sharepoint 2010.

Here the error again:


Error "The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.".

I checked whether the integration of SQL Server Reporting Services Service Application in sharepoint  has happened by opening Central Administration and press on  Manage Service Applications > New and it didn't show up here. If you have configured Sharepoint properly then the error message is not presented. Run the following code

Install -SPRSService

This gives an error because there is a space between Install and -SPRSService.

Correct this to

Install-SPRSService

The following result is shown.

Then execute the following code

Install-SPRSServiceProxy

And

get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

Now check the Service applications in the Aplication Management section and now the Application is present.

Create a Reporting Service Service Application

In this paragraph I'll explain the basic configuration of the SQL Server Reporting Services Service Application.  As with most of Service Applications you need to provide some base configuration 

Now it's time to watch whether the configuration succeeds.

Once it is finished it will show the following window.

Now check whether the application is installed correctly. 

Conclusion

This blogpost is about installing a single server installation of a Reporting Services report server in SharePoint mode.

Greetz,
Hennie