Archive

Posts Tagged ‘SQL Server 2012’

Just another SharePoint VM–Part 3–Installing SQL Server 2012

October 10, 2012 Leave a comment

Now that we have a virtual machine with Windows Server 2012 installed and configured with the roles/services required (published in Part 1) and the service accounts required all set up (published in Part 2), we can go on to the next step – installation of SQL Server 2012. It is possible to install SharePoint 2013 with a built-in version of SQL but I wanted to attempt using an individual instance of SQL Server 2012.

We start by choosing to open the ISO file for SQL Server 2012 from the VirtualBox menu and when the virtual drive loads up, choose to run “setup.exe”.

clip_image001

Screen clipping taken: 10/5/2012 10:08 AM

The SQL Server Installation Center launches with all the usual guidance around planning for deployment of SQL Server.

clip_image002

I chose to move on to the next step – Installation by clicking on the link on the left and the following options are presented:

clip_image003

Chose the first option “New SQL Server stand-alone installation or add features to an existing installation”. Setup support rules are run and any items that may prevent complete or proper setup of SQL Server will be identified here. In my case, everything passed.

clip_image004

Clicked on “OK” to move on to the next step. Here’s where you choose to install an evaluation copy or enter a key if you have one and move on.

clip_image005

Read and accepted the license terms on the next screen and moved on.

clip_image006

The following warning came up with searching for updates – this was because after I had made my DNS installation on the machine, I’d forgotten to go back and auto-detect DNS on the VM virtual network card. This is a problem that can be fixed later by ensuring the tunnel through to the host machine network works. So I moved on.

clip_image007

Installation of setup files comes next

clip_image008

The following warnings showed up

clip_image009

The first that the computer is a domain controller. But we are doing that by intent – so that is fine to ignore. The second was caused by my non-existent internet connection again which should be remedied later – so I ignored it. The last relating to the Windows Firewall was expected as well since I disabled it. Moving on. The next screen is for the role you want to install. Went with “SQL Server Feature Installation” here.

clip_image010

Next comes the feature selection page. Since I was installing a developer machine for some basic testing, I went with Database Engine Services, the Management Tools and the SQL Client Connectivity SDK. You can always add features to the existing instance later.

NOTE: If you would like to use Business Intelligence features on SharePoint with Analysis services in SQL Server, choosing Analysis Services here will help. If you would like to use reporting features, installing SQL Server Reporting Services will help. This will require installing the SQL Server Reporting Services add-in for SharePoint and will require some configuration post installation.

clip_image011

Again, an installation rule check occurs and any failures are reported. Clicked “Next” to move on

clip_image012

The instance configuration page is next. I chose to install the default instance:

clip_image013

A small pause and the disk space requirement page is shown. Our allocation of space on the virtual machine disk should suffice for this requirement.

clip_image014

On the Server Configuration page that shows up next, we set up the service accounts we want to use for the SQL Server Agent and the SQL Server Database Engine – the account known as SQL Service above. To do this, I dropped down the account name and “Browse…” for the user by typing their name into the object selection box and clicking on “Check Name”. Once the name was resolved, I clicked on “OK” to add them in. Back on the Setup page, you will need to type in the password you used when you were creating the account.

clip_image015

This is what it should look like when done. Note that I keep the Startup Type on both as they are before I hit “Next” to move on.

clip_image016

On the next screen we get to specify the authentication mode -which I always keep as Windows – and list administrators – where I always add the “Administrator” which is easily done by clicking on the “Add Current User” button

clip_image017

I don’t change anything on the “Data Directories” tab usually – where SQL Server chooses to put its files is fine by me. I do head over to the FILESTREAM tab and make the following selections. These will help with configuration of Remote Blob Storage if required. You should be able to do this from SQL Configuration Manager later.

clip_image018

Next Step, error reporting. I didn’t turn this on and moved on.

clip_image019

Again a configuration rule check which passed in my case. Moved on to the next step

clip_image020

An installation summary is shown for all things selected and configured so far

clip_image021

Clicked “Install” and off we go… this could take a while so go get your coffee and donuts or whatever.

clip_image022

Done. SQL Server is installed.

clip_image023

The start menu looks fuller now

clip_image024

Now for some configuration – launched the SQL Server Management Studio and connected to the local database engine

clip_image025

Expanded the “Security” branch and selected “Logins”. Right click and select “New Login…” to add a new login for the SharePoint Setup account – known as SP Setup above.

clip_image026

On the “Login – New” dialog, clicked on “Search…” to locate the user named SP Setup. In the lookup dialog, typed spsetup and hit “Check Names” to resolve the name, then hit “OK”. Back on the “Login – New” dialog, selected “Server Roles” in the left navigation and checked the roles “dbcreator” and “securityadmin”

clip_image027

That’s it. Hit “OK” on the dialog to create the new login and assign the server roles specified.

After the installation of SharePoint 2013, during configuration, one of the things the Configuration Wizard attempts to do is to check the maximum degree of parallelism setting on SQL Server. This “maxdop” setting determines how many processors SQL Server can assume it can use to create its execution plans. For some reason, the standard installation of SQL Server 2012 sets this to ‘0’. We need this to be at least ‘1’.

Now if we were using the administrator account during SharePoint configuration, it probably wouldn’t be a problem because this account would have the permissions to change the setting on the fly. However, since we intend to use the Setup service account (and I haven’t been able to figure out what permissions this account will require to be able to change this setting), it would make sense to have this setting made before we get to that stage.

Therefore, there is one more thing to do while we are within the SQL Server Management Studio. Right click on the server name at the top and select properties.

clip_image028

This brings up the properties dialog. Selected “Advanced” from the left navigation and found “Max Degree of Parallelism” under “Parallelism” and changed the value against it (was 0 to start with) to 1. Clicked on “OK” to apply.

clip_image029

With that we come to the end of the installation of SQL Server 2012 and configuration in readiness for the installation of SharePoint 2013. The next step is to go ahead and install SharePoint 2013 itself.

Read about installation and configuration of SharePoint 2013 Preview in Part 4.

%d bloggers like this: