Install SharePoint Server 2013 on Server 2012 with SQL Server 2012 configured for SSRS,SSAS and Powe


SharePoint Sever 2013 is available from MSDN and it is about time to test drive all the really nifty features available in the new version. Especially the new Business Intelligence capabilities available in SharePoint Server 2013 and Office 2013.

I am installing this on my development environment and I will be including SharePoint Server 2013, SQL Server 2012 with PowerPivot, PowerView, SSRS (Native Mode and SharePoint Mode), SSAS (Multidimensional and Data Mining Mode, PowerPivot for SharePoint, Tabular Mode) and PowerPivot features for Excel 2013.

I am assuming you have a working DC, if you don’t have: Install and configure a Domain Controller on Windows Server 2008 R2/2012.

Also make sure of your SQL Server 2012 Version. Make sure you are running at least 11.0.2853.3 If you want PowerView on SharePoint 2013 you will need  SQL Server 2012 SP1 CTP It will not work on the  RTM Evaluation Edition – 11.0.2100.60 How will you know? Under the installation media there is a file called.. wait for it.. Mediainfo, in it you will find: <Property Id=”BaselineVersion” Value=”11.0.2100.60″ />

1. Check your service accounts you are going to use.SPAdmin (SharePoint Admin Account),SPFarm (SharePoint Farm account), SQLSvc (SQL Server database engine account), SSAS (SQL Server Analysis Services Account), SSRS(SQL Server Reporting Services Account). Please feel free to change this to your flavour of naming conventions.

2. Install SharePoint 2013. Assuming you already have a SQL Instance installed, if not, first do steps 3 though 11 here, then you should be okay.

3. Install SQL Server 2012. Assuming you have the SQL 2012 RTM and the SP1 you can the following. I make this a .bat file and run it for SQL Server 2012 setup

<Current directory being SQL media directory>Setup.exe /Action=Install /UpdateEnabled=TRUE /UpdateSource="<Folder with Service Pack executable>"
Setup.exe /Action=Install /UpdateEnabled=TRUE /UpdateSource="C:\Software\MS - SQL2012 ENT"

But what is this? Well you get to slipstream your SP into the installation doing an Upgrade Installation

4. Install a new instance  of SQL Server


image

Now let setup do the Support Rules check, you can view them in “Show Details”, if you are happy, just go Next.


image

5. If you are doing the Upgrade Install the Product Updates will give you the following prompt. Well Next it is.


image

Setup will now go though the process of preparing some of the files for install.


image

6. Now to choose your Installation Type, we will be doing a New Installation of SQL Server 2012 SQL Server Feature Installation


image

Do some next, next, next..


image

7. Now we will select some of the features for this instance.


image

8. You can now specify a name for your instance and define your root directory and instance ID


image

9. Time to make those service accounts work for you. You know the ones you made earlier.


image

10. For the Database Configuration and SSAS, SSRS you can add Authentication mode, Server Mode and Configuration Mode as follows.. if you want.. you don’t have to

If you want you can choose SSAS in Tabular mode, if you only plan on using it for PowerPivot


image
image
image

WOW.. not wait for the install to finish.

11. Congratulations, on your new SQL Server, <Insert Instance Name here> is just too cute, whosacute instance.. yes! you! are! Awww.

12. Now we need to rinse and repeat for PowerPivot.

We will go New installation > SQL Server PowerPivot for SharePoint


image

13. The rest of the Installation is pretty much defaulted, except for the service accounts which you can do yourself


image

image

14. Wait for it to finish and now you are almost there. First spot the difference below..

Did you see, no I didn’t expect you to, but you need to now run PowerPivot for SharePoint 2013 Configuration , it can’t just say PowerPivot Configuration Tool. If it does, your version of SQL server is wrong, so try again. I know, it sucks, believe me.


image

You should see this come up. Select Configure or Repair PowerPivot for SharePoint


image
image

If you get an error, your version of SQL server is wrong.. see above for the SP1 CTP.

15. Fill in your details and click Validate


image

image