How to Install SQL Server 2012 on 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

 

Step 1: Open Control Panel  then select "Programs and Features" then click on "Turn 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".



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





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



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



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



Step 7: "cmd" -> type.

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



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



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".



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



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



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



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" .



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



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



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



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



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



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



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

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



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



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"

 

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



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



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"

 

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

 

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



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

 

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



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



Step 32: Now for the Installation Progress window.



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



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



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



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.

 

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



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.