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

Creating a SQL Server 2012 playground (part VII)

Introduction 

In this blogpost I'll guide you through a single server installation of a Reporting Services Report Server in SharePoint mode. The steps include running the SQL Server installation wizard as well as additional configuration tasks that use SharePoint 2010 central administration. A single farm is meaningful for a test or a development environment. This is not recommended  for a production environment.



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.

Configuring Microsoft Sharepoint 2010  

Go to start Microsoft Sharepoint 2010 Products and click on Central administration. That will show the following starting screen of the configuration wizard. You are asked to particpate in a Custom experience improvement program.  Press Next.

A warning show up that some services are about to restart on the server.

On the "Specify Configuration Database Settings" page enter your database server name. Enter the required database name for the SharePoint Configure database. Type the Username and Password to access the Database.

Press Yes.

In the "Connect to a Server farm" choose to create a new server farm.

On the "Configure SharePoint Central Administration Web Application" page, you can accept the randomly generated port number or click the checkbox against Specify port number to enter required port number. Specify the Configuration Security Settings. I choose to use Kerberos.

Press Yes.

Review the configuration settings defined in previous steps will be displayed on "Completing the SharePoint Products Configuration Wizard". Click the Next button to continue.

Wait until the configuration is finished.

And the configuration was succesful.

Then internet explorer pops up and where the configuring goes further:

When the configuring is done the processing screen is shown. It takes a lot of processing time.

After a while the VM reboots and in my case the screen stayed black (with the Winodws startup progress bar) for hours. I checked the processing and the disk usage and that indicated there was activity. But after a hour or something i decided to a "cold reboot". Windows checked up and everything seems normal.

Conclusion

This blogpost was about the configuration of Sharepoint 2010 SP1. Most of the configuration is simple and straight forward.

Greetz,
Hennie

Creating a SQL Server 2012 playground (part IV)

Introduction

We have setup the basic software (OS, SQL Server and the DC VM) for creating a SQL Server 2012 playground in part I, part II and part III. In this blogpost I'll describe installing the Sharepoint Server 2010 SP1.  First I'll create a snapshot of the VM machine. The installation of Sharepoint is easy  The heavy part is shifted to the Powerpivot configuration. This will be covered in a later 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.

Installation of Sharepoint 2010 SP1

I've downloaded the Sharepoint 2010 SP1 iso and opened it in the VM. The first step is installing the prerequisites.

Installing the prerequisites of sharepoint.

And that takes some time.

In the next window we have to choose between Standalone or Server Farm. Stand alone will install SQL Express on the VM and sharepoint will use this database. If you chooose for the Farm option Sharepoint will use an existing SQL Server instance. In a former blogpost I've described a full installation of SQL Server. I'll use this installation and I decide to choose the option "Server Farm".

And the installation proceeds...

The last step in the installation process is unchecking the sharepoint configuration wizard. In one of the later blogposts I'll show that the powerpivot configuration wizard will do this too.

As recommended in some blogposts it's time to run Windows update because we have installed quite some software. The following screenshot shows a total of 69 updates.

Conclusion

The basic installation of sharepoint Server 2010 SP1 is very easy but more difficult steps has still to come.

Greetz,

Hennie