Installing SharePoint 2013 on server 2012 with sql sp1


Installing

If you plan to use SQL Server Business Intelligence components in a SharePoint Server 2013 farm you must use SQL Server 2012 with Service Pack 1 (SP1).

http://technet.microsoft.com/en-us/library/hh292622.aspx

Microsoft® SQL Server® 2012 Service Pack 1 (SP1)

Version:    Date Published:

11.0.3000.00    11/09/2012

File Name:    File Size:

SQLServer2012SP1-FullSlipstream-ENU-x86.iso    3.1 GB

ENU\Readme.htm    13 KB

SQLServer2012SP1-FullSlipstream-ENU-x64.iso    3.6 GB

SQLServer2012SP1-FullSlipstream-x64-ENU.box    3.3 GB

SQLServer2012SP1-FullSlipstream-x64-ENU.exe    131 KB

http://www.microsoft.com/en-eg/download/details.aspx?id=35575

Three main comments

  1. SQL service account
    used to run SQL server service account
  2. SharePoint Setup user Account used to run SharePoint setup and configuration wizard (admin on SP server and must be granted SQL server log on and member of the following Roles security admin and DB creator ) (s-sql) replaced with spservice(will create all DBs

    Must be local admin on both servers

  3. Server farm database access account used to manage and configure the farm and application pool identity and will run the WF timer service must have dB creator and owner it won’t be member of the admins group on server (s-farm)

    Note: We will not create account for each application service

 

Configure specific SQL Server settings before you deploy SharePoint Server 2013

http://technet.microsoft.com/en-us/library/ms181007(v=sql.105).aspx

We need to set the maximum degree of parallelism to 1

I need to configure the following

Hostname Alias for a SQL Server Instance

A Hostname Alias SQL Server instance is a simple Hostname that allows clients to connect to an instance of SQL Server without specifying an instance name or a port number

http://blogs.msdn.com/b/dbrowne/archive/2012/05/21/how-to-add-a-hostname-alias-for-a-sql-server-instance.aspx

Installation

Make sure of the following on firewall

First open the firewall to port to connect to SQL

F:\prerequisiteinstaller.exe

Note: you must be connected to the internet to run the prerequisites

Then restart

 

 

 

 

Go to splash file

 

Install sharepoint server

 

Create new server Farm

Must enter instance name

Create site collection with team site

If the instance is default don’t write it just the server name

 

Add everyone to main visitors group

Advertisements

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