Installing SQL 2012

Recently I needed to upgrade my CTP edition of SQL 2012 to a full actual install. I thought since I had to uninstall the CTP to install the developer edition, now would be a good time to blog about the steps necessary to install it. Below are the steps that I took:


First, locate the installation media for SQL 2012. When you find the SETUP.exe file, run it. After it loads you will see a screen that looks like the below:




Click on the Installation tab on the left, and then select “New SQL Server Stand-Alone Installation or Add Features to an Existing Installation”




After you click on it a new window will appear, where some rule checks will take place. Once they finish successfully click OK and you’ll proceed to the next screen:


A few more minutes will pass and then you will get a new screen where you enter your product key. Enter your key or specify a free edition to install if you don’t have a key. Click Next, Accept the license terms and select if you want to send usage data to Microsoft. Let it run the update wizard and select to install the updates. The install setup screen will run:



Once it runs and extracts (this could take a few minutes depending on your updates), Once it finishes it will proceed to the Setup Support Rules wizard, where they will run and inform you of any issues. Assuming everything passes fine, Click Next.



Once you click Next, you’ll be on the Setup Role screen. Select the feature you want. In this instance, we want the SQL Server Feature Installation.


The next screen is the fun one. Select the features you want to install. In my case, this is for my regular development I do from my laptop and for quick demos when I need them. I’ve selected the features I want, and I’m ready to click next. One really nice feature in 2012 is that Master Data Services can now be included with the regular install, in 2008 R2 it was it’s own install file that you had to find in the setup files.


Once you click next, the Installation Rules wizard will run. Let it run and then click Next. The next page is the Instance Configuration page. Select if you want the default instance or if you want a named instance running on your machine. On my machine the default instance is already being used by 2008 R2, so I’m installing a named instance. Also please note the Instance Root Directory. This is the default installation path for SQL Server. It is a Microsoft best practice to install it on a volume OTHER than your C: drive. And yes, I know I’m breaking that very rule here due to the options on my machine.




Click Next, and the Disk Space Requirements wizard will run. Click Next. Configure your service accounts and click Next. It is considered a Microsoft best practice to use separate, least-privileged domain accounts to run each of the services needed. This prevents having one “super-account” that has permissions to do everything on your server. After you’re done click Next, and the Database Engine Configuration page will appear. Specify if you want just windows authentication or mixed mode, and then add a user to the administrator section. If you select mixed mode you’ll need to specify a password for the SA account. On the data directories tab create your installation paths (keeping in mind they should NOT be on the C drive).


Once you click Next the Analysis Services configuration screen will appear. Select if you want to install Multidimensional or Tabular mode, and the admin for the instance. On the data directories tab, change the path to something other than the C drive. If possible, this should be on a drive separate from your database engine and tempDB as well. Analysis Services works best on its own drive. Click Next.




On the Reporting Services Configuration page, select Install and Configure if you want it to be configured for you while its installing or if you just want to do the install and configure it yourself later via the Reporting Services Configuration tool. Click Next, and check if you’d like to send Error Reporting to Microsoft. Click Next again and allow the Installation Configuration Rules to run.


Click Next, check the Summary to ensure everything you want installed is there, and click Install. Depending on the features you selected, it may take a while. With the features I selected above, it took about 1/2 an hour to get everything up and installed. If all goes well, your final screen should look like:



Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s