Install SharePoint 2013 Public Beta on Windows Server 2012 RC – Part III – Installation of SQL Server 2012 on Windows Server 2012 RC

With the new version of SharePoint almost in Public Beta (I have hopes it will be this month) it is time to show how you can install it on the Release Candidate of Windows Server 2012.

Since the new version of SharePoint isn’t there yet this series of blog post will continue with the Installation of SQL Server 2012 on Windows Serve 2012 RC. After this post the following post will follow:

  • Part IV – Installation of the Prerequisites on Windows Server 2012 RC
  • Part V – Installation of SharePoint 2013 on Windows Server 2012 RC
  • Part VI – Configuring SharePoint 2013 on Windows Server 2012 RC

So let us begin with booting up the Virtual Machine we got this far and add the ISO of SQL Server 2012 to the machine.

When continuing from the previous blog post the “Server Manager” will be opened. Close the Server Manager and open “Active Directory Users and Computers” to create the service accounts we need for the installation of SQL Server:

To open Active Directory Users or Computer do the following:

  1. Go to the Start Menu by using the Windows button or by going to the low left corner with your mouse.
  2. With the Start Menu open select “Active Directory Users and Computers”.

Open the Users OU and use your other mouse button to add users:

new-users

When you have the “New Object – User” window open create the following users:

First name Last name User Logon name User logon name
SQL DB Engine svc_sqldbengine svc_sqldbengine
SQL Reporting svc_sqlreporting svc_sqlreporting
SQL Agent svc_sqlagent svc_sqlagent

 

Make sure you select the options:

  • User cannot change password.
  • Password never expires.

This will make sure the password of the accounts will not be reset or be disabled.

new-user

When the accounts are created it is time to start the installation of SQL server. Run the Setup wizard that’s on the SQL Server 2012 CD / DVD.

When you run the setup the SQL Server Installation Center will open. Press the Installation option on the left and then select “New SQL Server stand-alone installation or add feature to an existing installation”.

SQL-Installation-Center        SQL-Installation-Center---Installation

The installation setup will start with running a few startup rules. When you have passed all of the rules click Ok to continue with the installation.

Setup-Support-Rule

A new window will open and ask for your product key. If your product key hasn’t been filled in yet fill it in and continue by clicking next. On the next step accept the license terms and click next again.

Pre-Setup-Wizard-step-Product-key

The wizard will now start installing the required files for the installation and will start up another wizard. This wizard will automatically check the conditions of the server.

Setup-Support-Rules

Most of the the the wizard will give two warnings:

  1. Computer domain controller: You can ignore this warning because we will use this pc as a development pc. For production servers never install SQL on a domain controller this is for security reasons.
  2. Windows Firewall: This warning states that the Firewall is blocking SQL server. Because the machine will be a one machine farm we can ignore this warning. When you are creating a farm with multiple pc’s you will have to open the SQL server port. By default this is: 1433.

Because we can ignore the warnings we will click next and proceed to the next step. The next step will give us the option to select the installation type. You will have three options:

  1. SQL Server Feature Installation: This option will give you the possibility to install specific features of SQL Server.
  2. SQL Server PowerPivot for SharePoint: This option will give you the possibility to install PowerPivot for SharePoint.
  3. All Features with Defaults.

Setup-Type

We will select the first option: “SQL Server Feature Installation” because we want to install SQL server and select the features we want. We do not want to install everything because this can downgrade the performance of our virtual machine.

In the next step we can select the features we want to install. We will select the following features:

  • Database Engine Services.
    • SQL Server Replication
    • Full-Text and Semantic Extractions for Search
    • Data Quality Services
  • Management Tools – Basic
    • Management Tools – Complete

At the moment we will not install “Reporting Services Add-in for SharePoint Products” because we do not have a instance running of SharePoint server. Click next to continue with the installation.

SQL-Server-Feature-Selection

The wizard will perform a couple of checks based on the features you have selected. If you pass all of the Rules click next to continue to the Instance Configuration. On the instance configuration screen you have the option to change the name of the SQL Server Instance. We will keep the default settings and click “next”  to continue.

Instance-Configuration

The Disk Space Requirements Step will show you if you have enough hard drive space to install SQL server if you pass this step click next to continue. This will bring us to the “Server Configuration” step. In this step we will have to fill in the accounts and passwords for the services.

Disk-Space-Requirements   Server-Configuration

Fill in the accounts that we have created in the first step:

Service Account Name
SQL Server Agent svc_sqlagent
SQL Server Database Engine svc_sqldbengine

 

When you proceed you will have the option to select the authentication mode off SQL Server and were the data files are saved. For now we will leave it to the default settings and we will only fill in the SQL Server Administrators. I always fill in the BUILTIN\Administrators group but because were are installing it on a domain controller it cannot find this group that’s why we will just add the current user.

Database-Engine-Configuration

Now that we have configured these last steps we are almost finished with the installation. The next step can be ignored and you can simple click next. The wizard will again check a few rules, when you pass these rules click next to go to the confirmation screen.

Error-Reporting   Installation-Configuration-Rules

In the confirmation window check every setting and click “Install”  to start the installation.

SQL-Server-2012-Installation  Installation-Complete

When the installation is complete you can close the wizard. You can then op SQL Server management studio by following these steps:

  1. Go to the Start Menu by using the Windows button or by going to the low left corner with your mouse.
  2. With the Start Menu open select “SQL Server Management Studio”.

SQL-Server-Management-Studio

With SQL Server installed we can start the Installation of SharePoint 2013. We will start this fourth part of the blog series when the SharePoint 2013 Public Beta is released.

Related Posts

Offline Installation SharePoint 2013 In many situation you would like to do a offline installation of SharePoint 2013 or you are required to do a offline installation because you do not h...
User automatically removed from SharePoint Group During my current project we received an access request from a user. We did what we normally do, we checked the request and added the user in the appr...
Unable to start User Profile Synchronization Service A few days ago I wrote a post about loading modules in PowerShell by default: “Load modules by default when opening PowerShell”. Today we had to setup...
PowerShell Scripts During my current project we are using a lot of PowerShell scripts to administrate the environment and make development easier for us. In this post...
SharePoint License Versions versus Versions As a SharePoint developer you do not often get the question what SharePoint version do we need to install. In many situations we see that the Enterpri...
SharePoint 2013 and Biztalk 2013 (On-Premise) For a couple of days we have been trying to connect our On-Premise SharePoint 2013 environment with our On-Premise BizTalk 2013 environment using the ...

One comment

  • Installation of SQLServer failed. After I changed the network adapter from static IP to DHCP, installation finished without any error – like you described it.
    Although a server should have a static IP (configured in the network adapter properties) – when using a VM you can used DHCP. Another solution would be to configure a second network adapter with DHCP. This network adapter can be used to access the internet.
    Regards,
    Oliver

    P.S.: Looking forward to reading the next parts of your installation guide 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *