Environment Applies to: Hyper-v, Windows Server 2008 R2 64-bit SP1, SQL Server 2014 CTP1
- Must not be installed side-by-side with previous versions of SQL Server and will not be put in a production environment.
- .NET 3.5 SP1 is required for SQL Server 2014 (Enable .NET 3.5 SP1 framework on Windows Server 2008 using Server Manager Interface)
- Windows PowerShell 2.0
- Internet Explorer 7 or later version
Download the trial versions of SQL Server 2014 CTP1 and in depth product documentation from the below links.
Once the download is complete go to the destination folder. The installation file is an ISO image file, you will need to either burn the image on a DVD or use any third party tool (i.e. magic disk) to explore the contents of ISO image file.
After you have setup the environment, you can now start the installation. Before you begin it is better to perform system check which can be done using the tool provided by SQL Server 2014 itself. Proceed with your installation once the minimum requirements testing is successfully completed.
First from the root folder, double-click the Setup.exe file.
Once the Installation Wizard runs the "SQL Server Installation Center", click the Planning link on the left pane and then choose "System Configuration Checker".
Before the installation begins, prerequisites will be checked on your system and failed rules need to be fixed before you proceed further.
Once the system compatibility check is passed, click on "Installation" link in the left pane and then click on "New SQL Server stand-alone installation" link in the right pane to begin the installation process.
After rechecking the "Support Rules" you will be prompted with the screen to either enter the 25 character product key or "Specify a free edition" such as "Evaluation" or "Express". Make your selection and click next.
Read and accept the license terms and click next.
Wizard will install the required Setup Files.
Another quick check will run and after passing the rules you will be asked to select the feature component to install.
Make selection of features you want to install, for this example I have selected all the available features from the list.
Installation Rules window will appear and if the operation completed successfully, click next.
Instance Configuration screen will appear with the Installed Instances, since there is no instance already installed, the window is empty.
Give name to your SQL Server instance or use the default name and click next.
Depending on the selected features setup will review the required disk space, if passed click next.
On Server Configuration screen specify the SQL service account (this has to be a dedicated domain account not the local account), or leave everything as default. You can specify the "Startup Type" for SQL Services either Manual or Automatic and can also make post installation changes to these accounts from "Control Panel\All Control Panel Items\Administrative Tools\Services.msc".
Once done click next
On Database Engine Configuration screen specify the authentication security mode. Make sure you have selected the Mixed Mode authentication and provided the password for 'sa' account and also specified the SQL Server administrators.
On Analysis Services Configuration screen specify the user with administrative rights and click next leaving other options selected as default.
On this screen make selection for your reporting services mode and proceed next.
Distributed Replay Client topic require separate discussion, so for now specify the Controller Name and click next.
Make your choice for Error Reporting and click next.
After successfully testing the rules for installation process, move to next screen.
Finally based on the selections you made for the installation a summary window will appear. Review the information which is ready to be installed and click the Install button.
Installation procees may take sometime depending on your feature selection
And finally the message we were waiting for, Installation completed successfully with product updates.
Close the wizard and open the shiny new SQL Server 2014 and Enjoy!