In this document I will explain how install SQL Server 2012, SharePoint 2010, PowerPivot and Tabular Mode in the same server, for testing/development propose.
As a first step update the Windows Server with the latest Service Pack and hotfix.
SQL Server 2012
- Installation page, click New SQL Server stand-alone installation.
- Setup Support Roles page, click OK.
- Product Key Page, enter the product key or specify Evaluation and then click Next.
- License Terms page, select I accept the license terms and click Next.
- Product Updates page, select Include SQL Server product updates and click Next.
- Install Setup Files page.
- Setup Support Rules page, click Next.
- Setup Role page, select SQL Server Feature Installation.
- Feature Selection page, select All Features and change Shared Feature Directory if is necessary.
- Installation Rules page, click Next.
- Instance Configuration page, specify to install a default instance or a named instance and change the Instance Root Directory if is necessary and then click Next.
- Disk Space Requirements page, click Next.
- Server Configuration page, change the SQL Server Agent to automatic startup and then click Next.
- Database Engine Configuration page, add current user and on Data Directories change the Data Root Directory if is necessary and then click Next.
- Analysis Services Configuration page, add current user and select MultiDimensional and Data Mining Mode, Tabular Model will be installed late. On Data Directories tab change the directories location if is necessary and then click Next.
- Reporting Services Configuration page, change Reporting Services Native Mode to Install Only.
- Distributed Replay Controller page, add current user and then click Next.
- Distributed Replay Client page, leave the Controller Name blank, change the directories location if is necessary and then click Next.
- Error Reporting page, click Next.
- Installation Configuration Rules page, click Next.
- Ready to Install page, click Install.
SharePoint 2010
- On SharePoint Installation screen click on Install Software Prerequisites and then Next.
- Wait until install the Prerequisites softwares.
- On SharePoint Installation screen click on Install SharePoint Server.
- Enter the Product Key and then click on Continue.
- Click on Server Farm.
- Select Complete and then click Install Now.
- Uncheck Run the SharePoint Products Configuration Wizard now.
- Install SharePoint 2010 SP1 and cumulative updates for SharePoint 2010.
- Run SharePoint Products Configuration Wizard and then click Next.
- Click Yes to restart the services.
- Select Create a new server farm.
- Enter the Database Server name, User Account and password that already exist. The user account will be used to create a SharePoint database on the server specified.
- Specify Farm Security Settings, enter the Passphrase.
- Don’t change the random generated port and select NTLM authentication and then click Next.
- Click Next again and then click Finish.
- A web browser will open and then select No, I don’t wish to participate and click OK.
- Select Start the Wizard.
- On Service Account select Use existing manage account and then click OK.
- Create a site collection. Enter the site name and description. On Template Selection go to tab Enterprise and select Business Intelligence Center.
- Click Finish.
PowerPivot
- On SQL Server 2012 Installation page, click New SQL Server stand-alone installation.
- Install Setup Files page, install setup files.
- Installation Type page, select Perform a new installation of SQL Server 2012.
- Setup Role page, select SQL Server PowerPivot for SharePoint and uncheck Add SQL Server Database Relational Engine Services to this installation.
- Feature Selection page, click Next.
- Instance Configuration page, read-only instance name of PowerPivot is displayed, click Next.
- Disk Space Requirements page, click Next.
- Server Configuration page, specify a domain user account for service SQL Server Analysis Services and set Startup Type to Automatic.
- Analysis Services Configuration page, Add current user and click Next.
- Ready to Install page, click Install.
- Complete page, click Finish.
Tabular Mode
- On SQL Server 2012 Installation page, click New SQL Server stand-alone installation.
- Installation Type page, select Performe a new installation of SQL Server 2012 and then click Next.
- Setup Role page, select SQL Server Feature Installation.
- Feature Selection page, select Analysis Services.
- Instance Configuration page, specify the named instance as TABULAR.
- Server Configuration page, click Next.
- Analysis Services Configuration page, add current user and select Tabular Mode.
- Ready to Install page, click Install.
Configure Reporting Services for SharePoint 2010
- Execute SharePoint 2010 Management Shell.
- Type the follow commands:
- Install-SPRSService
- Install-SPRSServiceProxy
- get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance
- Close the SharePoint 2010 Management Shell.
- Open SharePoint Central Administration.
- In Central Administration, in Application Management, click Manage service applications.
- Click New and then SQL Server Reporting Services Service Application.
- On the Create page:
- Enter a name for the Application.
- Create a new application pool.
- On SSRS Service Database, enter the Database Server name and a domain user account that will be used to connect to the database.
- On Web Application Association, select SharePoint – 80.
- Click OK.
- Click OK again.
- Download the Script, click on Download Script.
- Run the script on SQL Server that has your SSRS database.
Sergio and Sabrina Zenatti 