Dynamics CRM 2013 Step by Step Part 3: Installing SQL Server 2012

Alright, so now we are done with installation of Windows Server 2012 and configured the Active Directory; it’s now time to install the SQL Server 2012 on the VM.

If you are reading this post for the first time and are not ready with the Server setup, I would recommend you to take a look at the previous posts in the series (Navigate to other posts from the box above).

Pre-requisites

Software Requirements

  • Windows Server 2012
  • Active Directory Setup

User Accounts

  • SQL Server Admin account
  • !svc.sql
  • Reporting Services Admin account
  • !svc.ssrs

Steps

Installing SQL Server is a fairly easy task. When you first open the SQL Sever DVD/ISO image file, you’ll be presented with a Configuration wizard where you’ll have to select Installation from Left Navigation and then New SQL Server Installation option on the right.

What follows is a Next, Next, Next thingy (not exactly but kinda) 🙂

  1. On the First screen of the wizard you’ll have to Accept the License Terms. Just click “I accept the license terms” check-box and press Next.
  2. The Setup will actually scan you system for all of the pre-requisites. If you were following my step-by-step then you should be fine here with 0 Errors and a couple of warnings, which is fine. Once the scan is completed and you see the summary, Press Next.
  3. At this point you might see another License Terms screen, go ahead and Accept the License and press Next.
  4. Now, the important part of the whole process. You will need to select which features should be installed for Microsoft Dynamics CRM 2013 to run successfully. Following is the list of features you should check.
    • Database Engine Services
    • SQL Server Replication
    • Reporting Service – Native
    • Management Tools (SQL Server Management Studio – Optional)
      Once you are through, Click Next.
  5. This step will let you know all about Disk Space Requirements. If all is well here, you’ll see the Next button available, Click it.
  6. Next screen is another important part of the installation process, you will have to give the Service Account details. Refer the following tables for the accounts to be selected.
    Service Acount Name Password Startup Type
    SQL Server Agent domain_name\!svc.sql “password” Automatic
    SQL Server Database Engine domain_name\!svc.sql “password” Automatic
    SQL Server Reporting Services domain_name\!svc.ssrs “password” Automatic

    Where domain_name is the name of your Domain which you setup in Part 2 of the Post (Setting up the Active Directory) and password is the password for your Service Account. Once you are done with the above steps, Click Next.

  7. Now, you will have to select Authentication Mode and SQL Server Administrators. Select Mixed Mode (SQL Server authentication and Windows authentication).
    Specify the password and then add the users whom you want to give SQL Sever Administrator rights.
    Once you are done, go to the Next screen.
  8. Next is Reporting Services Configuration. Select Install and Configure under Reporting Services Native Mode and then press Next.
  9. Next window is for Error Reporting. As of now we will leave this as is and press Next.
  10. In the next screen, system will actually check if there will be any roadblocks while installing the product. Wait until the scan is finished and then press Next.
  11. Finall you will see the entire Summary of all the steps and configurations that you have selected. Just take a look at it and press Install button.
  12. Wait until the installation is over and you are good to go 🙂

Following gallery will ease the process for you with screenshots of every single step mentioned above.