Lets get the basic questions out of the way…
1. How different is the SQL Server 2014 install than the 2012 installation? It’s not. It’s just how you remember it. Same windows. Same selections. Only a few different things based on the ‘type’ of installation you’re doing around the ‘type’ of features you want, but if you are doing the usual SQL Server and Basic Management Tools installation… It’s pretty much the same. No worries on that part of it.
2. Does it require restarting the server? It depends on what is updated. I’ve seen installations that don’t require rebooting, but also some that do. To be safe; simply restart it anyway.
3. Does it automatically restart the server once the installation completes? No.
Since this is a Microsoft Product; even though it’s not required, it’s still a good idea to restart it following the installation. Always recommended.
Mount the .iso you downloaded from Microsoft (Right-click and select ‘Mount’). You’ll be automatically forwarded to the setup files.
Select ‘Installation’ on the left pane of the Installation Center and on the right click ‘New SQL Server stand-alone installation or add features to an existing installation’.
Enter your product key. Click ‘Next’. Note: in this screen-shot I naturally removed the imbedded license key from my environment.
Click ‘I accept the license terms’ and click ‘Next’.
Select ‘SQL Feature Installation’ and click ‘Next’.
Choose the features you need. In this example we are using ‘Database Engine Services’, and ‘Basic Management Tools’ (which is just below whats viewable on this window) under ‘Shared Features’.
Select ‘Default Instance’ and click ‘Next’.
Add the Service Accounts you want to use or keep the defaults, and select the ‘Startup Type’, and click ‘Next’.
Select ‘Mixed Mode’, and enter the password for the ‘sa’ sql login you want to use.
Add the Server Administrators Group and select the ‘Data Directories’ Tab.
Change all the Data Directories and specify the appropriate Drive letters and click ‘Next’. Note: In this example I am using one drive as this is my Test Server.
Note: Ensure you use a complex password for the ‘sa’. I used a simple password to demonstrate that password rules are enabled by default through the installation of SQL Server.
Note: Here is the error you’ll get if you use something too simple:
Be patient while the installation completes.
Click ‘Close’ once the installation in successful.
Categories: Agent Jobs, Alerts, Automations, Backup & Restore, Big Data, Command Prompt, Configuration, Database Mail, Database Mirroring, ELI5, Error Solutions, Featured, Folder System, Forensics & Auditing, High Availability, How To, Installations, Long Scripts, Management Studio, Mirroring, Notification, Powershell, Quick Fix, Scripts, Security, Short Scripts, SQL Stuff, Top, TSQL, Work Arounds