Installing SharePoint 2013 on Windows Server 2012 and SQL Server 2012 - Part 4: SQL Server Installation and Configuration


This guide shows you how to install and configure SQL Server 2012. The configuration includes assigning permissions and configuring networking.

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.

Create a new SQL Server stand-alone installation. Select the SQL Server Feature Installation and proceed.

Add at least the ’Database Engine Services’ and ‘Management Tools - Basic’.

Check the Database Engine Services. Check the Management Tools Basic.

Use the default instance.

Add the SQL Server service account (in my case: sqlSvcAcc) and keep the collation settings.

Use the default instance to install SQL Server. Use the SQL Server Service account and keep the collation.

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.

Select your SQL Server administrators and enable Filestream. Install SQL Server 2012.

SQL Server 2012 Configuration

There are 2 configuration steps needed to prepare SQL Server 2012 for the use with SharePoint 2013.

Assign Permission

The first step includes assigning permission to the SharePoint setup administrator which is in my case spAdmin.

Select the dbcreator and sysadmin role for the SharePoint 2013 setup administrator.

Next Step

Step 5: Windows Server 2012 Configuration

Other Resources