Installing SQL Server 2012 Release Candidate 0

Posted on by

This blog will show you step by step instructions on how to install SQL Server 2012 RC 0.

Before we begin the installation, I would recommend you to go through the Installation documentation for SQL Server 2012 such as Minimum Hardware and Software Requirements and SQL Server 2012 Release Notes.

Once I setup my separate Virtual Machine for SQL Server 2012, I made sure that my Windows Server 2008 R2 had the Service Pack 1 installed. After that I added .Net 3.5 Framework by adding the Role Application Server. You can read how to install .Net 3.5 Framework on a Windows Server R2 in one of my previous blogs.

Once I was done installing those 2 prerequisites, I rebooted my Server to ensure it is ready for the SQL Server 2012 Installation (remember, SQL Server Installation will perform a check and if any of the previous updates needs a system reboot, it will ask you to reboot, so it is always good to restart your machine before you begin the Installation)…

Go to the location where you have copied the SQL Server Installation software and you should find the root directory something like what you see below. Make sure you logged in as a user who has Admin rights on the server. Right click the Setup.exe and choose Run as Administrator. (Though this is not an absolute must, you can also double click the Setup.exe to begin the installation)

SQL Server Installation Center should open and by default the Planning page is displayed as shown below..

SQL Server Installation Center is designed to be useful when you are performing a new Installation, or modify an existing installation, perform an upgrade and many more tasks related to Installation. We need to click on Installation to display the Installation choices. The Installation page is displayed as below..

When you are installing SQL Server 2012 on a stand-alone server, we need to choose the very first link by clicking on the text in New SQL Server stand-alone installation or add features to an existing installation.

Setup Support Rules is displayed (picture below) which performs a quick check that might cause issues while installation. If there are any failures in the the checklist, those failures need to be corrected (such as a system reboot or user not having admin rights etc). Click OK to proceed.

The next screen is Product Key, in this screen you will have to key in the product key (25 characters long) which came with your Installation media. In this case we are installing an Evaluation Edition, hence that is left blank and we continue clicking Next.

The next screen will display the License Terms and we need to accept the license terms by selecting the check box (as shown in the picture below).

Click Next to proceed. The next screen displayed is an enhancement to SQL Server 2012 installation, “Product Updates“, this step check for any updates available for the SQL Server product we are installing.

In this case we do not have any updates available, click Next (above pic). The next screen would display download and extract any updates / setup files (in this case they are skipped as there are no updates available) and then Setup files are installed..

As soon as the Setup files are installed, the windows closes and the next screen is displayed, which is second leg of Setup Support Rules which performs additional checks for smooth Installation (picture below).

See that there is one warning (Windows Firewall) which will not stop us from installing SQL Server. Click Next to proceed..

The Installation now moves to the next step where we can choose how do we want the SQL Server installation to continue. Select SQL Server Feature Installation option button, as this would give us more control on what SQL Server components are going to be installed and installation drives and directories.

Click Next to continue.. In the next screen, you can choose what features do you want to install on your server. You can choose only what is required and in a work environment, not all features are going to be installed. Since we are setting it for trying all features in the latest release of SQL Server, I selected all features. Click Next…

One more round of Installation Rules to ensure that we do not run into trouble while Installing.. Since the 2 check have passed, click Next

Then see the below screen displaying the disk space required for the Installation, this space requirements depend on the components / features we choose. Click Next to proceed…

In the next screen, Installation wizard shows us Names of the Service Accounts  which will be created and used for each of the SQL Server components and the Startup Type for those components. You can also set the Starup Type according to your choice. (In this case I changed the Startup to Automatic for SQL Server Agent).. Once you are done, click Next..

The next few screens will be displaying the configuration for the components, the first being Database Engine (pic below). This is the place where you can set the Authentication Mode of the SQL Server Database Engine. By default it would be Windows authentication mode, If you choose Mixed Mode, you will be asked to enter sa password and additionally you might want to add any other users who would be sysadmins on the SQL Server. You can do both of these at a later time, but I prefer doing it at the time of Installation.

There are multiple tabs in this screen and the below screen is displayed when we choose the Data Directories tab. This tab allows you to choose the Data and Log directories of the User databases, TempDB and the location for your database backups. In this case, I changed the location for User Databases Data and Log directory.

Click Next, to go to the next screen.

In the next screen (pic below), you can choose the Analysis Services Mode, Admins and the Data Directories for SSAS. Once you have made your selections, click Next

The next screen is for Reporting Services. If you would like the Installation to automatically configure Reporting Services for you, you can choose Install and configure option. I have chosen Install only as I would like to configure manually at a later time. Click Next…

The option in the next screen lets you decide if you would like SQL Server to send Error Reports to Microsoft automatically. It is only optional and varies from user to user.

The next screen is the final check of Installation prerequisites before Installation begins..

We are all set for Installation, and the next screen is a summary of what we have chosen to Install, what components and chosen, installation location etc.. Click Install for the Installation to begin..

The screen below is a screen shot of the Installation process..

Once the installation is successfully competed, the following screen is displayed.

Related blogs you might want to read…

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

17 thoughts on “Installing SQL Server 2012 Release Candidate 0”

  1. Pingback: What’s new in Installing SQL Server 2012 | Learn SQL With Bru

  2. Hi Bru,
    Could you tell me please what did you mean with Virtual Machine setup?!

    “Once I setup my separate Virtual Machine for SQL Server 2012”

    Regards,Rand

  3. Hi Rand,

    I created a new virtual machine separate for installing SQL Server 2012. That way I would not have multiple SQL Instances running on the same machine. It is only a matter of convenience to have individual machines…

    Please let me know if you any further questions..

    Regards,
    Bru Medishetty

  4. Hi Bru,

    Thanks a lot for your quick response! I am very glad to find a helpful person like you! I have followed your steps exactly as they shown above, but unfortunately, it appeared this error message 🙁 could you please help me?

    Regards,

    TITLE: SQL Server Setup failure.
    ——————————

    SQL Server Setup has encountered the following error:

    There was a failure to validate setting CTLRUSERS in validaton function ValidateUsers.

    Error code 0x85640004.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0x06ACB90B%25400xD5F9065B

  5. Yes, that was one of the issues that has occurred for many people while installing SQL Server 2012 RC0, for that I found a workaround.

    That is, do not select the 2 features Distributed Replay Controller and Distributed Replay Client, and youe installation should complete smoothly..

  6. YOU ARE THE BEST :)))))) installation is DONE successfully!

    Thanks a lot for your help and your GREAT EFFORTS! I just wanted to know if you recommend SQL Server 2012 RC, or could I use SQL Server 2008 R2 instead of it? (since the first one might be under testing or evaluation right now!)

    The second part of my question is, Does the DBA need to program and develope DB, I mean shold he have a good knowledge with for example, PL/SQL in Oracle or T-SQL in SQL Server?? Please anyone who has a good experience and works as DBA could answer me..In short, what has a DBA to do?! and if you know any good books that might be useful for someone who wants to be a DBA..

    Regards,

  7. Thanks for your comments. Yes since SQL Server 2012 is still in RC0 and few more revisions will be released to fix the bugs and issues, I would personally recommend beginning with SQL Server 2008 R2 and it is more stables and is also being used by a number of organizations.

    For your next question. I cannot comment on being an Oracle DBA, but I would say you “A SQL Server DBA will not be expected to be the best of the programmer, but a SQL DBA would be expected to know T-SQL programming”. As I am a SQL Server DBA myself, I can say that much for sure on the programming part of your question..

    About what a SQL DBA does? That question made me to come up with a list and I have already started jotted down the list, will review and post it as a new blog post as early as day after Tomorrow (Nov 26th 2011).

    Regarding a good book, Professional Microsoft SQL Server 2008 Administration (Wrox Programmer to Programmer) is one of those Admin books I would recommend.

  8. Hi Bru,

    Gr8 Work. Looking forward to install it.. 🙂

    Can i know the difference from SQL Server 2008 to 2012 ? what sort of benefits ?

  9. Your Welcome 🙂 Thanks again for your valuable informations! I will follow them, but now I face a problem with uninstallation of SQL Server 2012 RC! Could you tell me if there any comments for the uninstallation of it??

    I want to install the SQL Server 2008 R2 that you recommended. Which version of SQL server 2008 R2 do you recommend for me to install? Express or Evaluation-180 days- ? Could you please write a link to the one you prefer to me for learning purposes? And if there any notes that related with this installation, so I will not have problems like the previous one 🙁 ?

    Best Regards,
    Rand

  10. Hi Prasad,

    Thanks for your kind words.. There are lots of new features and enhancements in SQL Server 2012 over 2008 R2, each of them needs a lengthy blog (which I am planning to do very soon).. To name them.. AlwaysOn Availbility Groups, ColumnStore Indexes, Contained Databases, Multi-subnet failover clustering, Enhancements in SSIS, in SSAS, SSRS, T-SQL enhancements)

    By the way, I wanted ask you this, are you already using SQL Server 2008 or 2008 R2? If you intend to start using SQL Server for the very first time, I would recommend you to start with SQL Server 2008 R2, as that is more stable and a lot of books have been out in the market making it easier to follow. Since SQL Server 2012 is still in pre-release stage, it might contain bugs that are going to be fixed before final release in first half of 2012.

    Regards,
    Bru Medishetty

Leave a Reply