SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


How to Install SQL Server 2012 (Microsoft SQL Server 2012 Installation Guide)

Microsoft released SQL Server 2012 which had been known with its code name SQL Server Denali as Microsoft SQL Server 2012 CTP1. Following public available CTP version was released as CTP3. Please also read How to Install SQL Server 2012 Denali CTP3 guide)
I also download SQL Server 2012 from Microsoft downloads and while installing SQL Server 2012 data platform I tried to take some notes.
I hope SQL Server database professionals like administrators and T-SQL developers find my SQL2012 setup notes useful.
Please keep in mind that, for this tutorial I install Microsoft SQL Server 2012 on Windows 7 operating system.
Windows XP is not supported for SQL Server 2012 installation as an operating system. Please refer to Microsoft SQL Server 2012 Requirements for more information.

Microsoft SQL Server 2012 setup file for X86

SQL Server 2012 setup choose directory for extracted files

I choose path "D:/SQLServer2011" for Microsoft SQL Server 2012 setup files extraction target path.

SQL Server 2012 setup files

Microsoft SQL Server 2012 installation server

To view hardware and software requirements for SQL Server 2012, please visit: http://msdn.microsoft.com/en-us/library/ms143506(SQL.110).aspx and /sql-server-2012/microsoft-sql-server-2012-requirements.aspx

If you check the requirements you will see that PowerShell 2.0 is required for Microsoft SQL Server 2012 installation.

In order to check which version of Windows PowerShell installed on target SQL Server computer, you can print the built-in variable $PSVersionTable

Windows Powershell version check

Please refer to guide How to Check Windows PowerShell Version Installed on a Computer for more detail and alternative methods to check the version of installed PowerShell tool on your PC.

Another important requirement is the installation of a Windows Update for Microsoft .NET Framework 4.0

Here as seen in below screenshots, the KB958488 and KB979900 were already installed on my SQL Server 2012 computer.

KB958488 installationKB979900 installation

Unfortunately SQL Server Upgrade Advisor for SQL Server 2012 code-name Denali is not available for CTP 1 release.

After you are ready for installing Microsoft SQL Server 2012 Denali CTP 1, you can switch to Installation tab from the left side menu of SQL Server Installation Center.

SQL Server 2012 installation center

Click on New SQL Server stand-alone installation or add features to an existing installation.

SQL Server 2012

Then Setup Support Rules will be executed to identify problems that might occur when you install SQL Server Setup support files. Before continuing to installation process, the failures listed must be corrected.

SQL Server 2012 setup for Denali CTP1

Here is the detailed report.

Microsoft SQL Server "Denali" Community Technology Preview 1 - System Configuration Check Report

Computer Name(s): KODYAZ
Report Date/Time: 10.11.2010 22:35
Saved to Directory: C:\Program Files (x86)\Microsoft SQL Server\110\Setup Bootstrap\Log\20101110_223441\SystemConfigurationCheck_Report.htm

Rule Name Rule Description Result Message/Corrective Action
GlobalRules: SQL Server "Denali" CTP1 Setup configuration checks for rules group 'GlobalRules'
skip NoRebootPackageDownLevel This rule determines whether the computer has the required update package that ensures that the computer will not have to be rebooted because of the Microsoft .NET Framework 4 installation. Not applicable This rule does not apply to your system configuration.
success AclPermissionsFacet Checks if the SQL Server registry keys are consistent. Passed SQL Server registry keys are consistent and can support SQL Server installation or upgrade.
success MediaPathLength Checks whether the SQL Server installation media is too long. Passed The SQL Server installation media is not too long.
success NoRebootPackage This rule determines whether the computer has the required update package that ensures that the computer will not have to be rebooted because of the Microsoft .NET Framework 4 installation. Passed This computer has the update package that ensures that the computer will not have to be rebooted because of the Microsoft .NET Framework 4 installation.
success RebootRequiredCheck Checks if a pending computer restart is required. A pending restart can cause Setup to fail. Passed The computer does not require a restart.
success SetupCompatibilityCheck Checks whether the current version of SQL Server is compatible with a later installed version. Passed Setup has not detected any incompatibilities.
success ThreadHasAdminPrivilegeCheck Checks whether the account running SQL Server Setup has administrator rights on the computer. Passed The account running SQL Server Setup has administator rights on the computer.
success WmiServiceStateCheck Checks whether the WMI service is started and running on the computer. Passed The Windows Management Instrumentation (WMI) service is running.

Rules Documentation: http://go.microsoft.com/fwlink/?LinkId=194954
Community: http://go.microsoft.com/fwlink/?LinkId=193497
Setup Help File: http://go.microsoft.com/fwlink/?LinkId=193483

 

Click on OK button to continue...

The SQL Server 2012 Setup (Denali CTP1) requires you to enter a Microsoft SQL Server 2012 product key or to specify a free edition of SQL2012. The possible MS SQL Server 2012 free editions are Enterprise Evaluation, Express and Express with Advanced Services.

SQL Server 2012 product key or specify free edition

I prefer to use Microsoft SQL Server 2012 Enterprise Edition so I select Enterprise Evaluation from dropdown list.

You must accept the license terms in order to continue to Microsoft SQL Server 2012 installation (SQL Server Denali CTP).

Microsoft SQL Server 2012 Denali license terms

setup support files for SQL Server 2012

Click Install button to install SQL Server 2012 Setup Support files.

The Setup Support Rules again check the current system for possible failure reasons.
As you see below, I got a warning about the Windows Firewall. And others are Passed.

Microsoft SQL Server 2012 setup support rules

Let's start with passed criterias.

success AclPermissionsFacet Checks if the SQL Server registry keys are consistent. Passed SQL Server registry keys are consistent and can support SQL Server installation or upgrade.
success Bids2008InstalledCheck Checks if any of SQL Server 2008 Business Intelligence Development Studio installation exists. Passed SQL Server 2008 Business Intelligence Development Studio is not installed.
success DenaliCTPbyCTPSxS This rule determines whether an instance of SQL Server "Denali" CTP0 exists. Passed SQL Server "Denali" CTP1 can be installed side by side with the existing version of SQL Server.
success FacetDomainControllerCheck Checks whether the computer is a domain controller. Installing SQL Server "Denali" CTP1 on a domain controller is not recommended. Passed This computer is not a domain controller.
success FacetPowerShellCheck Checks whether Windows PowerShell is installed. Passed Windows PowerShell is installed or not required.
success FacetWOW64PlatformCheck Determines whether SQL Server Setup is supported on this operating system platform. Passed SQL Server Setup is supported on this operating system platform.
success FusionRebootCheck Checks if a computer restart is required because of broken fusion ATL. A pending restart can cause SQL Server Setup to fail. Passed The computer does not require a restart.
success PerfMonCounterNotCorruptedCheck Checks if existing performance counter registry hive is consistent. Passed The performance counter registry hive is consistent.
success SSMS_IsInternetConnected Verifies that the computer is connected to the Internet. When a Microsoft .NET application like Microsoft Management Studio starts, there maybe be a slight delay while the .NET security check validates a certificate. Passed The computer is connected to the Internet and .NET security checks can be completed.
warning IsFirewallEnabled Checks whether the Windows Firewall is enabled. Warning The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature.

The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature.

the Windows Firewall is enabled SQL Server 2012 setup

Here is how firewall configuration is managed for SQL Server 2012 setup on Windows Server 2008, Windows 7 or on Windows Vista.
Goto Start menu, click Run, then type WF.msc This command will open Windows Firewall with Advanced Security screen.

Windows Firewall with advanced security tool

Click on Inbound Rules from left menu.

Windows Firewall inbound rules

Then click New Rule from the right pane where Inbound Rules is selected.

Windows Firewall new inbound rule

On the displayed screen, select Port option.

Windows Firewall inbound rule type

Make sure that TCP is selected as target protocol. And You can enter port number 1433 in the specific local ports entry.

Windows Firewall TCP 1433 rule for SQL Server 2012

Click Next buton. On the next screen the Allow the connection option should be selected.

Windows Firewall allow the connection option

Click Next to continue

Windows Firewall inbound rule profile

Click Next buton

Then specify a name for the new Windows Firewall inbound rule.

Windows Firewall inbound rule name for SQLServer 2012

Windows Firewall configuration for Microsoft SQL Server 2012 Analysis Services with Default instance :
Create a new Inbound Rule for TCP Port with TCP port 2383 for Allow the connection option.
If you are using a named instance of SQL Server 2012 Analysis Services,
Create a new Inbound Rule for TCP Port with TCP port xxxx for Allow the connection option.
Additionally create a second Inbound Rule for TCP Port with TCP port 2382 for Allow the connection option for SQL Server Browser service.

For SQL Server 2012 Reporting Services (SSRS) Windows Firewall configuration Allow the connection on TCP port 80 with a new Inbound Rule.

For SQL Server 2012 Integration Services (SSIS), Windows Firewall configuration can be managed with TCP port 135.

Now we can go back to SQL Server Installation Center and continue with SQL Server 2012 Denali setup process.

MS SQL Server 2012 setup roles

Click Next buton for selecting among Microsoft SQL Server 2012 Denali CTP 1 features.
I just select the following Microsoft SQL Server 2012 features for a fast SQL Server setup :
Database Engine Services,
Client Tools Connectivity,
Client Tools Backwards Compability,
Management Tools - Basic

SQL Server 2012 features selection for Denali CTP1 setup

After SQL Server 2012 features selection for setup process, the installation rules are applied and gives reasons for a possible failure.

installation rules after SQL Server 2012 features selection

The only warning the setup wizard is pointing is about SQL Server Management Studio.

SQL Server Denali CTP1 shared component upgrade rule

OK, that is good it will automatically upgrade Microsoft SQL Server Management Studio (SSMS) to a newer version :)

Microsoft SQL Server 2012 instance configuration

SQL Server 2012 disk space requirements

SQL Server 2012 service accounts

SQL Server 2012 collation settings

SQL Server 2012 account-provisioning

SQLServer2012 database-engine-configuration

SQL Server setup error reporting

SQL Server Denali installation configuration rules

verify SQL Server 2012 features to install

Click the Install button.

Microsoft SQL Server 2012 installation completed successfully

restart computer to complete SQL Server setup

SQL Server database professional can refer to http://msdn.microsoft.com/en-us/library/bb500469(SQL.110).aspx for an official Microsoft SQL Server 2012 installation guide.



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.