Starting/Running SQL SERVER 2012 (SQL Permissions) for SharePoint 2013

SQL Server

You need to give the SharePoint Account that you plan to install and configure SharePoint with some elevated rights in SQL. Typically we recommend you use a dedicated account [Domain]\[SharePoint Admin] and this account will need the following roles on the SQL Server.

  • DB_Creator
  • Security_Admin
  • Public

From your newly installed SQL Server click Start > All Programs > Microsoft SQL Server 2012 > SQL Server Management 2012.

Microsoft SQL SERVER 2012 Start 1

After waiting this loading user settings screen will appear:

Microsoft SQL SERVER 2012 Start 2

Wait for some time then the following screen appears:

Microsoft SQL SERVER 2012 Start 3

Login as [Domain]\[SharePoint Admin] by selecting “Windows Authentication”:

Microsoft SQL SERVER 2012 Start 4

Microsoft SQL SERVER 2012 Start 5

From Object Explorer expand-out Security.

Under Security expand out Logins.

In case you don’t have the User

  • Right click on Logins.
  • From the menu choose New Login.
  • For Login name: enter [Domain]\[SharePoint Admin]  or whatever account you will be logged into SharePoint as when you do the install.

Microsoft SQL SERVER 2012 Start 6

After right click, select Properties. The following screen will come:

Microsoft SQL SERVER 2012 Start 7

On the left, under select a page click Server Roles.

Check the box for dbcreator and securityadmin. Also, leave public selected.

Microsoft SQL SERVER 2012 Start 8

Click OK. Now your [Domain]\[SharePoint Admin] is ready to install sharepoint on the server.

Advertisements

One thought on “Starting/Running SQL SERVER 2012 (SQL Permissions) for SharePoint 2013”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s