Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooing Skills

Step by Step: Installing SQL Server 2012 RC 0

Posted by blakhani on November 30, 2011


For my upcoming internal session on contained database, I decided to install latest version of SQL Server 2012 (earlier known as SQL Server “Denali”) to show the demo. Here are the steps with screenshots to help someone who is doing the same. So, here we go!

I have done this on my Hyper-V machine so that I can always rollback. I have used SQL Server 2012 RC0 (Release Candidate 0) build. While writing this post, RC0 was the latest version available and can be downloaded from here

  • Copied the media to local machine, I prefer this to avoid any network hiccups which might cause my setup to fail. Now run Setup.exe

Choose Setup.exe

  • After clicking you should see “SQL Server Installation Center”. On left menu, click on “Installation” and then click on “New SQL Server stand-alone installation or add features to an existing installation”

02_Setup

  • Once you click, you should see “Setup Support Rules” screen.

03_Setup

  • Hit OK and you should get “Product Key” Screen. Since I launched setup from Evaluation Media, it doesn’t populate Product Key. Hit Next.

04_Setup 

  • Next would be License Terms screen. Check the box “I accept the license terms.” and Next.

05_Setup

  • Next Screen is about auto patching of setup. Since I am using version which is not having any further updates, so I would uncheck the option and move forward. I would cover more about this feature later.

06_Setup

  • Hitting Next would install setup support files as shown below.

07_Setup

  • Next screen would just show the rules. Hit Next.

08_Setup

  • I have selected first option as I don’t play with SharePoint.

09_Setup

  • Normally I don’t click “Select All” but to get all screens, i have selected this. Notice the left menu getting changed based on your selection. Hit Next.

10_Setup

  • Hit Next

11_Setup 

12_Setup

  • Summary of disk space. Hit Next.

13_Setup

  • If you want to change service account, you can provide details and password. You can also specify “Startup Type”. Hit Next.

14_Setup

  • In this screen I am going with Mixed mode and given password. Also clicked on “Add Current User” to add logged on user as Sysadmin in SQL Server.

15_Setup

  • Please don’t ask question about SSAS. I have just hit next clicking on “Add Current User”.

16_Setup

  • In “Reporting Services Configuration” screen, just hit next.

17_Setup

  • Next screen should be “Distributed Replay Controller”. I have just hit next clicking on “Add Current User”. I would cover this feature in detail in some later blog.

18_Setup

  • In “Distributed Replay Client”. I have entered some name as I don’t know what to enter here. I should be able to change this later (I think so). At this point I am yet to read more about this feature.

19_Setup

  • If you want us to provide feedback about setup and some watson failures, you can check the box and in “Error Reporting” screen and then hit next. I always check this because I know this is really useful to make product better.

20_Setup

  • Next screen would do validation about installation/system and may block you if one or more rules are failed.

21_Setup

  • Finally, the summary of all options selected so far. Very important information is Configuration File Path which can be used if you want to have automation. Remember that we don’t store any password in that file so you are safe!

22_Setup

  • “Installation Progress” screen would show the actions being performed.

23_Setup

  • And here is the screen which you would all love to see.

25_Setup

That’s all for today. I would love to hear feedback from reader(s).

Hope this would help someone in the world!

Cheers,
Balmukund Lakhani
Twitter @blakhani

About these ads

13 Responses to “Step by Step: Installing SQL Server 2012 RC 0”

  1. jberke said

    Distributed Replay Controller setup step has a bug. It crashes if you want to add a user when you are not in a domain environment or dc is not available. It has been documented by Aaron Bertrand http://sqlblog.com/blogs/aaron_bertrand/archive/2011/11/19/sql-server-2012-a-couple-of-notes-about-installing-rc0.aspx and I have posted a workaround to the MS connect site along with some others: https://connect.microsoft.com/SQLServer/feedback/details/705158/setup-adding-current-user-to-distributed-replay-crashes-setup#

  2. Geethu Kutty said

    WoW! What an excellent post.

    I was looking for this information all around the net and found it here

    You are truly a genious!

    Hats off to your work!

    Regards,
    Geethu Kutty

  3. Gaurav said

    It’s a Gr8 Post again.

  4. Bharath Reddy said

    Really helpfull,thanks for posting

  5. Geethu Kutty said

    I attended your Tech-Ed and all participants were saying that you are “Always On” Man. Do you have any plans to write a book on Always On? I’m more than willing to buy that and get your autograph on that…

    • blakhani said

      Thanks Geethu. There are other peoples in market who are writing book. But you can expect a blog/video tutorial on the same.

  6. ali said

    it helped me thanks

  7. miri said

    Very helpful post! Thank you!
    I had a red row at the installation rules screen: “prior installations of Visual Studio 2010 that might require update”.
    The solution was to download this file: http://go.microsoft.com/fwlink/?LinkID=220649.
    Maybe this will help someone.. :)

  8. Joe said

    I have read so many articles concerning the blogger lovers
    but this article is truly a pleasant article, keep it up.

  9. shiku said

    awesome. better than i thot!!!!!!!!!!!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 788 other followers

%d bloggers like this: