How to Install and Run SQL Server 2012 after a successful Windows 8 Installation
The new SQL Server 2012 is the first SQL Server product that can be actively installed on a Windows Server Core. Windows Server 8 is also the first operating system on which you can employ switching features between the Server Core and the Server Full implementations. Now, although SQL Server 2012 can be installed on a Windows Server 8 Core (or a successful copy of Windows 8 installation) directly from the command line or configuration file, the easier way would be by installing it first on Windows Server 8 Full with GUI and then later switching the OS to Windows Core.
So in taking a look at how you can go about achieving the same, the team with Windows 8 and support has formulated a simple guide as given below.
Starting Windows Server 8 Setup
- To first begin with installing Windows Server 8 with GUI, you will need to choose the same option from the setup wizard, “Install .NET Framework 3.5 Feature”. Following which, click on “Add Roles and Features” from the “Server Manager” and then continue with the wizard. Make sure that your operating system has active access to the Internet as it will need it to install this same feature.
(NOTE: .NET Framework 4.5 is already installed on the server by default)
- You can now proceed with installing all SQL Server 2012 features on your Windows Server 8 in the same way you would do so on any other Windows OS.
- After the successfully completing the installation, you can then start with the necessary configurations graphically.
- Now, once after you have configured and tested your SQL Server instance, go ahead and try switching your OS to Windows Server Core. Do so by getting on your “Server Manager” and select “Remove Roles and Features” from the “Manage” menu.
(NOTE: The Server Manager in Windows 8 has separate interfaces for removing and adding server roles and you cannot do both at
the same time as you were able to do in the previous versions of Windows)
- Next up, from the “Remove Roles and Feature” wizard, clear “Graphical Management Tools and Infrastructures” and “Server Graphical Shell” check boxes then click on “Next”.
- After the server is newly restarted, you will see the command prompt only. Type “msconfig” into the command prompt and then hit “Enter”.
- You can also easily switch back to your main Windows 8 installation with GUI by selecting option 12 “Restore Graphical User Interface (GUI)”.
Your SQL Server instance is now running on Server Core and you can connect to it remotely with Management Studio. Happy computing! For more help and support, visit OmniTechSupport.com.
May 17, 2012
|
Posted by


Categories:
Tags:





