Setting up SharePoint 2013 Development Environment - Part 3

This is the Part 3 of the series for setting up a development environment for SP 2013 on a VM. As we know, this is the latest release for the new Microsoft stack of products that involves Windows Server 2012, SQL Server 2012, Visual Studio 2012 and SharePoint Server 2013 (or SP 15).

In this part 3, we will focus on Installing SSAS with Tabular and PowerPivot for SharePoint Integration modes.

So let’s fire up the SQL install once more and continue exactly as we did earlier till you reach the step to choose the Installation Type.

Choose to perform a New Install of SQL Server 2012.

Click Next, Next till you see the Setup Role screen. Select the SQL Server Feature Install.

In the feature Selection screen, choose the Analysis Services feature and click on Next.

Specify a name for your SSAS Tabular instance and click on Next.

Define SQL Server Analysis Services service account and click on Next.

Choose the Tabular Mode option, add click [Add Current User] to add an administrative user account, and click on Next till you hit the install button on the last step of the wizard screen.

You should see a success message after a while:

We are now going to install SSAS for PowerPivot for SharePoint.

Click through the same steps as we did in the previous method for “Tabular” mode till you see the Setup Role screen.

On this screen, select the SQL Server PowerPivot for SharePoint Installation option. Also uncheck the option for “Add SQL Server Relational Engine Services to this installation”, as we already did that earlier with the Tabular mode.

Click Next. The feature selection screen must already have the features selected for you.

Click Next.

Note that the Named Instance has already been set for you “POWERPIVOT”, so let’s name the instance ID, say “POWERPIVOT” to keep things simple.

Specify SQL Server Analysis Services service account and click on Next.

Add the Current User.

Continue with the installation process, and wait until the installation completes successfully.

Okay, now we need to install the following SQL Server 2012 SP1 CTP4:

(www.microsoft.com/en-us/download/details.aspx?id=34700)

This is required, as this gets you the Configuration Tool needed to configure the PowerPivot for SP 2013 integration mode.

So go ahead, download and Install the CTP4.

IMPORTANT: DO NOT run “PowerPivot for SP 2013 Configuration Tool” at this time. We will come back to this once we are done with the “SP 2013 Setup, Install and Configuration Wizard” process.

Setting up SharePoint 2013 Development Environment – Part 2

This is the Part 2 of the series for setting up a development environment for SP 2013 on a VM. As we know, this is the latest release for the new Microsoft stack of products that involves Windows Server 2012, SQL Server 2012, Visual Studio 2012 and SharePoint Server 2013 (or SP 15).

In this part 2, we will focus on Installing SQL Server 2012 on top of Windows Server 2012 that we installed on our VM.

- Start the Setup wizard for SQL Server 2012. Click on the “New stand-alone install…”.

Once you go through the steps of Updates for SQL Server, Setup Support Rules, License Keys and Accept Terms, you’ll need to choose from 3 different Setup Roles. I chose SQL Server Feature Installation.

On the next screen, Click [Select All].

Click Next. It should pass all the 3 Installation Rules as below:

Choose “Named Instance” and provide a name. Press TAB, this should update the Instance ID and all the 3 directory paths. Click Next.

Click Next on the Disk Usage Summary.

Specify Service Accounts as created earlier for SSRS and SSAS. I’ll leave others as is (as a best practice, in prod environments, you may want to specify the service accounts for others as well).

Click Next.

Leave the Auth Mode = “Windows” and click [Add Current User]. Click Next.

Click Next. Then Click [Add Current User] to specify which user has permissions for the distributed replay controller. Click Next.

Specify controller name and leave the directory locations as is. Click Next.

Click Next. Then Click Next again on Error Reporting. It should be something like:

Click Next and then Install. Wait for the setup to complete.

This completes the SQL Server installation with SSRS (SQL Server Reporting Services) configuration in Native mode only.

At this point of time, let’s take another snapshot of the VM and do a windows restart.

So, that’s it for getting the basic SQL Server 2012 installed and running.

We will move to the Part 3 of this series, where we will get the SSAS with Tabular and PowerPivot for SharePoint Integration modes.