This guide shows you how to install and configure SQL Server 2012. The configuration includes assigning permissions and configuring networking.
Here we go:
This Video is part of a series:
SQL Server 2012 Installation
Start the setup and choose a New SQL Server stand-alone installation.
Choose the SQL Server Feature Installation after you have accept the license agreement and entered the license key.
Add at least the ’Database Engine Services’ and ‘Management Tools - Basic’.
Use the default instance.
Add the SQL Server service account (in my case: sqlSvcAcc) and keep the collation settings.
If you create a development environment add the current administrator and SharePoint 2013 setup administrator as SQL Server administrators.
Also enable FILESTREAM for Transact-SQL access and FILESTREAM for file I/O under FILESTREAM tab if you plan to use RBS.
Review your configuration and click install.
SQL Server 2012 Configuration
There are 2 configuration steps needed to prepare SQL Server 2012 for the use with SharePoint 2013.
The first step includes assigning permission to the SharePoint setup administrator which is in my case spAdmin.