Add multiple accounts with profile photos to SharePoint 2013

SharePoint 2013: Create 2000 Domain Accounts with Profile Photos for a Development Environment

Table of Contents

It can be important to have a development environment that is as close to a production environment as possible. Having realistic development (or staging) environment helps business users visualise what an end product (or solution) will look like when deployed.

The following PowerShell (and accompanying name files) demonstrates creating 2000 unique Active Directory domain accounts, including setting different locations, departments, phone numbers and gender (male or female). Each domain account has a photo uploaded to Active Directory. Finally, SharePoint User Profile synchronization is configured, to import the users and their photos

How to find the template name of SharePoint site?

How I can view SharePoint 2010 template names using Power Shell?
which is the right SharePoint  2010 template to use for my farm?

To find out SharePoint 2010 template names

1. Open your SharePoint 2010 Management Shell
2. Type in Get-SPWebTemplate

SharePoint 2010 template

Name                 Title                                    LocaleId   Custom
----                 -----                                    --------   ------
GLOBAL#0             Global template                          1033       False
STS#0                Team Site                                1033       False
STS#1                Blank Site                               1033       False
STS#2                Document Workspace                       1033       False
MPS#0                Basic Meeting Workspace                  1033       False
MPS#1                Blank Meeting Workspace                  1033       False
MPS#2                Decision Meeting Workspace               1033       False
MPS#3                Social Meeting Workspace                 1033       False
MPS#4                Multipage Meeting Workspace              1033       False
CENTRALADMIN#0       Central Admin Site                       1033       False
WIKI#0               Wiki Site                                1033       False
BLOG#0               Blog                                     1033       False
SGS#0                Group Work Site                          1033       False
TENANTADMIN#0        Tenant Admin Site                        1033       False
ACCSRV#0             Access Services Site                     1033       False
ACCSRV#1             Assets Web Database                      1033       False
ACCSRV#3             Charitable Contributions Web Database    1033       False
ACCSRV#4             Contacts Web Database                    1033       False
ACCSRV#6             Issues Web Database                      1033       False
ACCSRV#5             Projects Web Database                    1033       False
BDR#0                Document Center                          1033       False
OFFILE#0             (obsolete) Records Center                1033       False
OFFILE#1             Records Center                           1033       False
OSRV#0               Shared Services Administration Site      1033       False
PPSMASite#0          PerformancePoint                         1033       False
BICenterSite#0       Business Intelligence Center             1033       False
SPS#0                SharePoint Portal Server Site            1033       False
SPSPERS#0            SharePoint Portal Server Personal Space  1033       False
SPSMSITE#0           Personalization Site                     1033       False
SPSTOC#0             Contents area Template                   1033       False
SPSTOPIC#0           Topic area template                      1033       False
SPSNEWS#0            News Site                                1033       False
CMSPUBLISHING#0      Publishing Site                          1033       False
BLANKINTERNET#0      Publishing Site                          1033       False
BLANKINTERNET#1      Press Releases Site                      1033       False
BLANKINTERNET#2      Publishing Site with Workflow            1033       False
SPSNHOME#0           News Site                                1033       False
SPSSITES#0           Site Directory                           1033       False
SPSCOMMU#0           Community area template                  1033       False
SPSREPORTCENTER#0    Report Center                            1033       False
SPSPORTAL#0          Collaboration Portal                     1033       False
SRCHCEN#0            Enterprise Search Center                 1033       False
PROFILES#0           Profiles                                 1033       False
BLANKINTERNETCONT... Publishing Portal                        1033       False
SPSMSITEHOST#0       My Site Host                             1033       False
ENTERWIKI#0          Enterprise Wiki                          1033       False
SRCHCENTERLITE#0     Basic Search Center                      1033       False
SRCHCENTERLITE#1     Basic Search Center                      1033       False
SRCHCENTERFAST#0     FAST Search Center                       1033       False
visprus#0            Visio Process Repository                 1033       False


Change SharePoint 2010 farm passphrase using Windows PowerShell

How to change SharePoint 2010 Farm passphrase?

1. Open SharePoint 2010 Management Shell from Start, All Programs, Microsoft SharePoint 2010 Products.

2. Enter following cmdlet: Set-SPPassPhrase

Change SharePoint 2010 Passphrase

3. Type the new farm passphrase.

4. Confirm the passphrase.

SharePoint 2010 Installation using PowerShell scripts

How can I install SharePoint 2010 using PowerShell to create database with out GUID’ed?

If you don’t want to have GUID’ed databases after installing SharePoint 2010, you should use PowerShell scripts installation. In this blog, I am using SharePoint Auto Installer from  Codeplex

Project Description
This project consists of PowerShell scripts, an XML input file, and a standard windows batch file (to kick off the process) which together provide a quick and near-unattended installation and initial config (Service Apps, My Sites) of Microsoft SharePoint Server 2010. Works on both Windows 2008 and 2008 R2 (x64 only of course).

1. Download SharePoint 2010 Auto Installer

2. Unzip the files and this is what you will see.  You have four folder

AutoSPInstaller:  This folder contain all the configuration files

Put SharePoint 2010 Files Here

PrerequisteInstallerFiles: Put Prerequisite Files Here

LanguagePacks: Put Language Packs here

SharePoint 2010 Auto Installer Files

Instead of putting files in each of these folder,
I opened SharePoint Splash file and installed prerequisite files and installed SharePoint binaries.

SharePoint 2010 Splash


When you install software prerequisites, it will download all the files you needed and prepare you IIS for SharePoint installation. 
Once the prerequisites are completed, just install SharePoint 2010 Server but don’t run the configuration wizard.  

Installing SharePoint 2010 Server

1. Enter the product key and click continue


2. Accept the term agreement and click continue


3. In this case, I am installing Server Farm (One Front End and Backed End Server)

Server Farm installation in Windows 7


4. Complete installation: Install all components, can add servers to form and SharePoint farm

SharePoint Complete Installation in Windows 7

5. Installing SharePoint 2010

Installing SharePoint 2010 in Windows 7


6. Installation completed and DO NOT RUN the SharePoint Products Configuration Wizard NOW.
Now we are going to use the SharePoint SharePoint 2010 Auto Installer




2.  SharePoint Installation using SharePoint 2010 Auto Installer Scripts

1.  Go to Auto Installer Folder


Open config-OWA


Enter your product Key here:  This is where you have to enter your SharePoint 2010 product KEY.
In this case we already installed SharePoint using the product you and you may not needed but if you installing everything using script, this is where you need to input product key.


2. Now open AutoInstallerInput.xml file. This is where you need to add all your configuration.
I am using Dreamweaver but you can open using your notepad


Input your information about your farm.  Your domain name/user name, password, SQL Server Name, etc..
If your using separate account for SQL Server, make sure you give proper permissions in SQL server.

ShaerPoint 2010 Auto Installer Script

Once you make all the changes, save the file and launch Auto SharePoint Installer to Install SharePoint 2010


3.  SharePoint 2010 installation with Power Shell in progress

1.  SharePoint 2010 Auto Installer, Testing SQL server access and trying to connect to SQL Server



2.  SharePoint 2010 Auto Installer skipping prerequisites and binaries.  Enter your pass phrase now to  move on


3. Creating Config Database and joining to a farm


4.  Adding managed accounts and creating web applications



5. Configuring the SharePoint farm servers using using Auto SharePoint installer


6.  Completing the installation.


Once you install SharePoint 2010 using SharePoint Auto Installer, your database will be clean and no more GUIDS.

Running Windows PowerShell Scripts in Windows 7

How do I create a new power shell script in Windows 7 or run power shell script using Windows 7?
In Windows 7 comes with Power shell editor and power shell windows and the location is


To open Power Shell window in Window 7 go to C:\Windows\System32\WindowsPowerShell\v1.0

Open PowerShell_ISE in Windows 7

If you want to create power shell script, open powershell_ise. 
Editing Power Shell script in Windows 7 using Powershell_ise.exe and if you want to run the scrip, just click F5

Editing Power Shell script in Windows 7 using Powershell_ise.exe

Running Powershell scripts in Windows 7 using Power Shell

Running Powershell scripts in Windows 7 using Power Shell