Install SQL Server 2014 for SCCM/Skype for Business/SharePoint

Install SQL Server 2014 for SCCM/Skype for Business/SharePoint

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

SQL-Installation-1

Read and Accept the License terms to continue

SQL-Installation-2

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

SQL-Installation-3

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.

SQL-Installation-4

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.

SQL-Installation-5

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-Installation-6

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

SQL-Installation-7

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.

SQL-Installation-8

This completes the SQL Server 2014 Installation

SQL-Installation-9

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.

 

 

 

 

About The Author

Related posts

Leave a Reply

Your email address will not be published. Required fields are marked *