3 minute read

This post was published in 2013 and may be outdated.

SQL Server 2012Currently I’m playing with some products from the Microsoft System Center 2012 Suite in my Home Lab. I’m Starting the whole installation by installing a new Virtual Machine with Microsoft SQL Server 2012 (Standard Edition).

I used a dedicated VM that will be used to host the database of Configuration Manager 2012 and Orchestrator 2012 (at least.. for now)

Resources

Installation

1 - After launching the SQL 2012 Server Installation, you should first run the System Configuration Checker. This small tool will check if you have every requirements to install SQL Server. Image 2 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"

2 - The System Configuration Checker.As you can see, the Setup support Rules identify problems that might occur when you install SQL Server Setup support files. Failures must be corrected before Setup can continue. Image 3 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 3 - Select Installation on the left navigation pane and select New SQL Server stand-alone installation or add features to an existing installationImage 4 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"

4 - Enter your Product key or select Specify a Free Edition if you just want to and evaluation version. Image 5 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"

5 - Read and Accept the License terms.
Optionally you can check the "Send feature usage data to Microsoft...."Image 6 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 6 - Leave the "Include SQL Server product updates" checked and click on Next. Image 7 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 7 - On the Setup Support Rules, you can see that my firewall generate a warning. I'll open the firewall later on. Click Next to continue Image 8 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
Image 9 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
When you click on the Windows Firewall rule Warning Link, you'll see the information above
8 - Select the standard Features to install, here I just need:
* Database Engine Services * Reporting Services - Native * Management Tools - Basic * Management Tools - Complete Image 10 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" Image 11 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
9 - Installation Rules - the Setup is running rules to determine if the installation process will be blocked.Image 12 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" Image 13 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 10 - Specify the name and instance ID of the SQL Server Instance. By default: MSSQLSERVER. I continue with this setting and click Next. Image 14 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"Image 15 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 11 - Review the disk space required for SQL Server and click Next. If you need to change the location of the database, click back and specify another folder/drive. Image 16 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 12 - Specify the service accounts and collation configuration, here I set NT AUTHORITY\System for: * SQL Server Agent * SQL Server Database Engine * SQL Server Reporting Services
Image 17 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
Before
Image 18 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
After
13 - Make sure the Database Engine is set to SQL_Latin1_general_CP1_CI_AS. If it's not the case, click on Customize, tick SQL Collation, used backwards compatibility, and select the good one in the list. Image 19 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
14 - In the next screen "Database Engine Configuration", specify the authentication mode and the administrators for the Database Engine. I added those:
* The Current User (in my case the Domain Administrator account) * The Domain Admins Group * The Local Administrator Account Image 20 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
15 - Specify the Reporting Services configuration mode.
Here I Selected Install and ConfigureImage 21 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 16 - Tick the "Send Windows and SQL Server Error Reports to Microsoft ..." Image 22 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 17 - The Setup is running rules to determine if the installation process will be blocked during the installation process. Image 23 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
18 - Verify the SQL Server 2012 features to be installed and click on Install.Image 24 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"Optionnaly you can check the ConfigurationFile.ini generated by the wizard. This can be reused for another installation.
Image 25 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
ConfigurationFile.ini
Image 26 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"
ConfigurationFile.ini can be found under c:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\
19 - After a few minutes your Installation of SQL Server 2012 should be completed successfully Image 27 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" You can check the logs under c:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log Image 28 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" 20 - Finally you can launch SQL Server 2012 Management Studio to verify that everything run as expected. Image 29 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" Image 30 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab" Image 31 from the post "Installing Microsoft SQL Server 2012 Standard Edition SP1 in my Home Lab"

Leave a comment