How to Install SQL Server 2012 on Windows 8.1

This article explains how to easily install SQL Server 2012 in Windows 8.1.

Introduction

This article explains how to easily install SQL Server 2012 in Windows 8.1.

Hardware and Software Requirements for Installing SQL Server 2012

SQL Server 2012 install issues for this type of error:

  • Enable .NET Framework 3.5 (includes .NET 2.0 and 3.0) in other words (NetFx3) Windows feature
  • NET Framework 3.5 installation error: 0x800F0906, 0x800F081F, 0x800F0907

Sql server 2012 install issues 

Step 1: Open Control Panel  then select "Programs and Features" then click on "Turn Windows features on or off".

Windows features on or off

Step 2: Then check (select) ".NET Framework 3.5 (includes .NET 2.0 and 3.0)" and check the following items then click "Ok".

check

Step 3: You will ten encounter the .NET Framework 3.5 installation errors: 0x800F0906, 0x800F081F and 0x800F0907 as in the following windows:

 installation error

 installation error

Step 4: Use offline mode install of NetFx3 then "ISO image or DVD" > "D:\Windows_8.1 \sources\" > "sxs" > " File copy".

Offline mode install

Step 5: Paste in the C:\ "sxs" file:

File

Step 6: Now open a "Command Prompt (admin.) Run".

Command Prompt

Step 7: "cmd" -> type.

"DISM /Online /Enable-Feature /FeatureName: Netfx3 /All /Limit Access /Source:C:\sxs"

type

Step 8: Again open Control Panel and select "Program and Features " then click on "Turn Windows features on or off".

Turn Windows features

Step 9: Then again Then check (select) ".NET Framework 3.5 (includes .NET 2.0 and 3.0)" and check the following items then click "Ok".

Again Turn Windows features on or off

Step 10: Then the Windows Features will be installed; it will say "Applying changes ".

install

Step 11: Now it was installed successfully; it will say "Completed the requested changes".

installed successfully

Step 12: Now for the SQL Server 2012 installation of "ISO image or DVD" and run Setup.Exe; see the following screen:

SQL Server 2012 installation

Step 13: The SQL Server Installation Center launches; choose the Installation tab then from the second in the right click on "Installation" then click on "New SQL Server stand-alone installation" .

choose Installation tab

Step 14: Now in "Setup support Rules " click "Ok".

Setup support Rules

Step 15: Select "Enter the product key" and click "Next".

Product key

Step 16: Now in License Terms check the box next to "I accept the license terms." and click "Next".

License Terms

Step 17: In Product Updates just click "Next"..

Product updates

Step 18: In Setup Support Role just click "Next".

Setup support Role

Step 19: In Setup Role select "SQL Server Feature Installation" and click "Next".

Feature Installation

Step 20: In Feature Selection in "Instance Features" select something then click "Next".
instance Feature

Step 21: Feature Selection will show "Please Wait ".

Wait

Step 22: Now for Installation Rules; just click "Next".

Installation Rules

Step 23: Now for "Instance Configuration".
  • Generally you can leave the Default Instance
  • Choose the installation path for SQL Server (default C drive) and click "Next"

Instance Configuration 

Step 24: Next is Review the Disk Space Requirements; just click "Next".

Disk Space Requirements

Step 25: Now for Server Configuration; set both "SQL Server Agent"," Analysis Services" and installed click "Next".

SQL Server Agent

Step 26: Now for “Database Engine Configuration".
  • Choose the authentication mode for the system. Windows authentication mode and mixed mode
  • user name Default “SA” and password=”Enter Password” Click "Add Current User" then click "Next"

Database Engine Configuration 

Step 27: Now for Analysis Services Configuration Select the "Multidimensional and Data Mining Mode " then click "Add Current User" then click "Next" .
 
Analysis Services Configuration

Step 28: Now for "Reporting Services Configuration"; select "Install and configure" then click "Next".

Reporting Services Configuration

Step 29: Now for Error Reporting; click "Send Windows" then click "Next".
 
Error Reporting

Step 30: Now for "Installation Configuration Rules" > "Ready to Install" then click "Next".

Installation Configuration Rules

Step 31: Now for "Ready to Install"; just click "Next".

Ready to Install

Step 32: Now for the Installation Progress window.

Installation Progress windows

Step 33: Now the installation is complete; SQL Server 2012 installation was successful as shown below.

installation complete

Step 34: Now go to Windows 8 Search and search for "ssms".

windows 8

Step 35: Now SQL Server 2012 will start as shown below.

start SQL Server

Step 36: In the Connect to Server dialog box do the following:
  • Server Type: Database Engine (default)
  • Server Name: This is your system name (default).
  • Authentication: Use Windows Authentication (default) or
  • SQL Server Authentication with Login: SA and Enter password and click Connect.

Server dialog box  

Step 37: You will now get the SQL Server 2012 as shown below.

SQL Server

Now SQL Server 2012 is installed in Windows 8.1. I hope you enjoyed this article. If you have any other questions then please provide your comments below.