Install SQL Server 2012 for SCCM/Skype for Business/SharePoint
In my Blog, you will soon see articles on SCCM, Skype for Business, SharePoint, Virtual Machine Manager, SCOM and so on. All of them require SQL server to store configuration and content. This article focuses on installing SQL Server 2014 and important points to consider while Installing SQL Server.
Insert your SQL media and go to Installation tab. I am installing SQL in standalone mode but you might want to consider installing SQL in Cluster mode (which will be covered in later posts sometime).
Read and Accept the License terms to continue
Run through the pre-requisite checks and ensure that there are no errors. Windows firewall can be adjusted later to allow SQL port (1433 or any other custom port later).
Select the SQL feature that you want to install. I have select Database Engine Services , Reporting Services and Management Tools – Complete. Also change the installation folder if you don’t want it to go C Drive or default location as shown below. Ensure that you have enough space before you continue.
This one is important. The Default instance connects directly to SQL server and in certain cases you might need to install named instance. Make your selection here and continue.
If you need SQL Services to run in specific service account then provide details here. Note that service is often created in Active Directory and may need to be added to Local Administrators group on the SQL server.
SQL supports Windows Authentication and Mixed mode authentication. It is always better to use Mixed Mode authentication, which uses Windows and native SQL authentication. This is critical during any emergency when Windows Authentication fails for multiple reasons.
Ensure that you type the password of
You have option to Install and Configure reporting services or just Install the Reporting Services. We will only Install the role to expedite the installation now.
This completes the SQL Server 2014 Installation
I will soon cover Installation of Clustered Servers and using Powershell soon. This will now create base for my next deployments – SCCM, Skype for Business, VMM and so on.