Tuesday, March 12, 2013

SharePoint (2010,2013) Setup Part 2 (SQL Install)

Login to virtual machine on which you want to insall SQL server. Login as sql_Admin account created in Part 1.

Run Setup.exe.


Go To installation > New SQL Server stand-alone


Click Ok

Tick "Include Sql Server Product Updates". Click Next.

Click Next.

Select "SQL Feature Installation" and click Next.

Select features highlighted in above screenshot and click Next.

Click Next.

Click Next.

Click Next.

Change SQL Server Agent and Database engine service accounts.
Use SQL_Service account created in Part 1

Click "Add Current User" Button. click Next.

Click Next.

Click Next.

Click Install and wait for installation to complete.


Part 1



Sunday, March 10, 2013

SharePoint Service Accounts Details

SQL Server Service Accounts


NameDescriptionLocal RightsDomain Rights
SQL_AdminUsed to Install the SQL Server.Local Administrator on the SQL Serverno special rights
SQL_ServiceService account used for the following MSSQLSERVER, SQLSERVERAGENTSQL SQLServer servicesno special rightsno special rights

SharePoint Service Accounts


NameDescriptionLocal/SQL RightsDomain Rights
SP_AdminInstall SharePoint,
Run SharePoint Configuration Wizard
Local Administrator on all the SharePoint Servers. SecurityAdmin and DB_Creator rights on the SQL Instanceno special rights
sp_farmConfigure Srerver, Run cental Admi site, Run SharePoint Timer JobLocal Admin during UPS provisioning, log on locally rightno special rights
SP_ServiceService Accounts to run Service Application Poolsno special rightsno special rights
SP_PortalAppPoolAccount is used to run web applications poolno special rightsno special rights
SP_ProfilesAppPoolApplication Pool for My site web applicationno special rightsno special rights
SP_SearchServiceAccount used to run Search Window Serviceno special rightsno special rights
SP_SearchContentAccount used to crawl contentno special rightsno special rights


SharePoint (2010,2013) Setup Part 1 (Service Accounts)

SharePoint (2010,2013) Setup Part 1 (Service Accounts)

Step 1 Create Service Accounts in Active Directory

I am assuming you have already configured active directory. If not then you can go to this site to know step by step how configure this.

Link 1
http://social.technet.microsoft.com/wiki/contents/articles/12370.step-by-step-guide-for-setting-up-windows-server-2012-domain-controller.aspx

Link 2

http://sharepointgeorge.com/2012/configuring-active-directory-ad-ds-in-windows-server-2012/

Create Service Accounts

Service Acccount details can be found at SharePoint Service Accounts Details

I am using power shell script available at this site to create active directory user. http://gallery.technet.microsoft.com/scriptcenter/PowerShell-Create-Active-7e6a3978

You can also download this script using link provided below.


  1. Download the script provided above.
  2. Run Powershell as Administrator.
  3. By default script execution is disabled. Enable it using command
    "Set-ExecutionPolicy Unrestricted"
  4. Add Service account Users in "Users.csv" as required.
  5. Run Powershell command
    "../SPAccounts.ps1"





Popular Posts