Monday, 19 December 2016

Steps to reset your SharePoint Passphrase

Forget your passphrase don't worry. Powershell will come to your rescue.

Why we need passphrase, it is required when we are adding a new server to our farm.

If you don't know it then you cannot add server to your farm

Below PowerShell can help you setting up a new passphrase for your farm.

$passpharse=ConvertTo-SecureString - String "SP2010Password" -asPlainText -Force
Set-SPPassPhrase -PassPhrase $passphrase -Confirm

Thanks to Stewart Wainaina for sharing this

Happy SharePointing :)

How to do Index Reset in SharePoint.

Below are the steps to do an Index Reset thru GUI


1. Open Central Administration > Manage Service Application.

2. Click on Search Service Application.

3. On Search Administration Page on left side under Crawling you can see Index reset option.

4. Click on it, it will again ask for confirmation. Click on Reset Now.

5. It will take sometime around 2 to 5 minutes.

You are done with index reset and now you can start full crawl on your content sources.

If you want Powershell to do an index reset. Run below command.


Parameters true is to disable alerts and ignore timeout error.

Happy SharePointing :)

Wednesday, 14 December 2016

How to Remove "Revert to template" warning message in SharePoint


Sometimes you see a warning message on you site saying.
"The current page has been customized from its template. Revert to template”

There are many option to resolve.I will share with you then one, i personally like.


1. Go to the page where you are getting the warning message.

2. Edit the page.

3.  Go to insert tab and click Web Part.

4. From Media and Content categories, Select Script Editor and Click ADD.

5. Now click on edit the web part and click on Edit Snippet.

 6. Insert the below line of code to hide the warning message

    #DeltaPageStatusBar { displaynone; }

7. Click Apply and OK on Web Part properties.

Your warning message will be gone.

Happy SharePointing :)


Friday, 9 December 2016

Configure People Picker for a domain with One way trust

This post will help you Configure People Picker  for a domain with One way trust.

If SharePoint is installed on a domain that has a one-way trust with other domains and you want the People Picker on SharePoint 2013 to show users and groups from those other domains, you have to use the STSADM command to configure the People Picker.

This is tested on SharePoint 2010,2013

So lets get started :)

Step 1

You have to set an encryption key on all web front end servers in your farm so that the stored credentials can be encrypted:

STSADM.exe -o setapppassword -password Key

where "Key" is any value.

STSADM.exe -o setapppassword -password Password11

Note : For two way trust no need for setting an encryption key,means you can skip step 1 for a domain with two way trust.

Step 2

You have to give SharePoint the credentials to authenticate against the remote domain and tell it which domain you would like to authenticate against. You only have to run this on one of your SharePoint web servers

STSADM.exe -o setproperty -propertyname peoplepicker-searchadforests -propertyvalue <Valid list of domains> -url <URL of the Web application>

where <Valid list of domains> is in the following format:


For example, a sample command might look like this:

STSADM.exe -o setproperty -propertyname peoplepicker-searchadforests -propertyvalue ",test\user,P@ssw0rd" -url

You can add more than one domain. Just delimit them with a semicolon and a space. For example:

SSTSADM.exe -o setproperty -propertyname peoplepicker-searchadforests -propertyvalue ",test\user,P@ssw0rd;,test2\user,P@ssw0rd" -url

Step 3

Run below cmd to test if value has been set for people picker or not.

STSADM.exe -o getproperty -pn peoplepicker-searchadforests -url

Happy Sharepointing :)

PowerShell to Change the Retention period of Usage Health and Data.

Powershell is a PowerFull tool and it always come to save us all with any requirements we have.

This post on how to change the retention period of Usage Health and Data.

Lets get started :)

This applies to SharePoint 2013 and 2016

First we check the Usage details using below Powershell Cmd.


Now we change the retention period from 7 to 8 using below Powershell cmd

Get-SPUsageDefinition | ForEach-Object {Set-SPUsageDefinition -Identity $ -DaysRetained 8}

To confirm the change we will run Get-SPUsageDefinition cmd again.


Happy SharePointing :)

Failed to Register SharePoint Service in PSConfig Error

While running the PSconfig it got failed when it was trying to Register the SharePoint Services.

This happens only on Stand Alone servers.


Open up registry
Browse to 
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\15\LauncherSettings
Create a key : DWORD
Name :  AcknowledgedRunningOnAppServer
Value : 1 

Now go to below registry 
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\15\LoadBalancerSettings
Create a key : DWORD
Name :  AcknowledgedRunningOnAppServer
Value : 1 

Now re-run the PSconfig and all will be good now.

Happy SharePointing :)

Friday, 2 December 2016

Save Site as template action is not supported on this site


Something went wrong. The "Save Site as template" action is not supported on this site

Reason for the Error:

When you try to save a publishing site as site template then you get the following error message
The “Save site as template” action is not supported on this site.
Even you deactivate the publishing feature, you still face the error.


Below PowerShell will update the Single property page value in the SP Web object.

$web = Get-SPWeb
$web.AllProperties[“SaveSiteAsTemplateEnabled”] = “true”

It can also be done via SharePoint desginer but i always like PowerShell

Happy Sharepointing :)

Thursday, 1 December 2016

List of Site Templates in SharePoint

Below are the list of Site Templates in SharePoint.

GLOBAL#0 = Global template
STS#0 = Team Site
STS#1 = Blank Site
STS#2 = Document Workspace
MPS#0 = Basic Meeting Workspace
MPS#1 = Blank Meeting Workspace
MPS#2 = Decision Meeting Workspace
MPS#3 = Social Meeting Workspace
MPS#4 = Multipage Meeting Workspace
CENTRALADMIN#0 = Central Admin Site
WIKI#0 = Wiki Site
BLOG#0 = Blog
BDR#0 = Document Center
OFFILE#0 = Records Center
OFFILE#1 = Records Center
OSRV#0 = Shared Services Administration Site
SPS#0 = SharePoint Portal Server Site
SPSPERS#0 = SharePoint Portal Server Personal Space
SPSMSITE#0 = Personalization Site
SPSTOC#0 = Contents area Template
SPSTOPIC#0 = Topic area template
SPSNEWS#0 = News Site
CMSPUBLISHING#0 = Publishing Site
BLANKINTERNET#0 = Publishing Site
BLANKINTERNET#1 = Press Releases Site
BLANKINTERNET#2 = Publishing Site with Workflow
SPSNHOME#0 = News Site SPSSITES#0 = Site Directory
SPSCOMMU#0 = Community area template
SPSPORTAL#0 = Collaboration Portal
SRCHCEN#0 = Search Center with Tabs
PROFILES#0 = Profiles
SRCHCENTERLITE#0 = Search Center
SRCHCENTERLITE#1 = Search Center
SPSBWEB#0 = SharePoint Portal Server BucketWeb Template
VISPRUS#0 = Visio Process Repository

Let me know if i missed out on something. Will add it

Happy SharePointing :)

Monday, 28 November 2016

How to check version of App Fabric or Distributed Cache

With post we like to share how easy it is to find App fabric or Distributed cache version.

So lets get started :)

The easiest way is to manually check what version of App Fabric you are using or CU applied to App Fabric

 Go to Control Panel  > Program and Features. Check for App Fabric and you can see the version.

Second way is thru PowerShell.

Run below cmd to get the details about App Fabric a.k.a Distributed cache.

(Get-ItemProperty "C:\Program Files\AppFabric 1.1 for Windows Server\PowershellModules\DistributedCacheConfiguration\Microsoft.ApplicationServer.Caching.Configuration.dll" -Name VersionInfo).VersionInfo.ProductVersion

Happy SharePointing :)

Thursday, 24 November 2016

WSS Usage Application proxy stopped on SharePoint

This post help you with Issue where Usage and Health Data Collection proxy is stopped on SharePoint.

This applies to SharePoint 2013 and 2016

Below screenshot for reference .

Resolution :

Follow below steps to Start the proxy application.

1. Get the ID for  Usage and health Application using this cmd "Get-SPServiceApplicationProxy".

2. Now use below Powershell cmd to start it

$Usage= Get-SPServiceApplicationProxy | Where{$_.ID -eq "f4cd8349-a2ba-4c66-96da-2ffa84b32b19"}

3. Now Check Usage and Health Data Collection proxy will be started.

Happy SharePointing :)

Adding Certificate to Manage Trust in Central Administration.

This Post will help you out with the steps on how to export the certificate which is associated with site and then add it to Manage Trust in Central Administration.

So lets get started :)

1. First of all browse your site.Click on Lock and Click View Certificate.

2. Go to Certification Path and Select the Root of the Path and Click On View Certificate.

 3. It will open a new certificate, go to Details tab and Click on Copy to File.

4. It will open a Certificate Export Wizard and Click Next.

5. Click Next and Give a name to the file. Click Finish. Certificate will exported.

6. Now,Cert is exported.Go to Central Admin > Security > Click Manage trust.

7. Click New and Fill out the details.

8. Now Certificate has been added in Manage Turst.

9. Do an I.E reset.

Now, you wont get any certificate error while browsing the site.

Happy SharePointing :)

Tuesday, 22 November 2016

PowerShell to replace the old content type with new one.

One of our user came up with a request to change all the old content type with the new one.

If you do google you will find lots of resource which can help you achieve it.

But our user had special request while changing the content type, the modified by or modified time should not be changed.

Below is the PowerShell to achieve it.

Add-PSSnapin Microsoft.SharePoint.PowerShell

#Custom PowerShell Function to switch Content type of all items stored in a SharePoint library

Function Change-ItemContentType {
        [Microsoft.SharePoint.SPWeb]$Web = $(throw "Please provide the 'Web' Parameter!"),
        [string]$ListName = $(throw "Please provide the 'ListName' Parameter!"),
        [string]$OldContentTypeName = $(throw "Please provide the 'OldContentTypeName' Parameter!"),
        [string]$NewContentTypeName = $(throw "Please provide the 'NewContentTypeName' Parameter!")
    #Get the list
    $List = $Web.Lists[$ListName]

    #Get the new content type
    $NewContentType = $List.ContentTypes[$NewContentTypeName]
    #Iterate through each item in the list
    foreach($item in $list.Items)
        if($item.ContentType.Name -eq $OldContentTypeName)
            #Change the content type
            $item["ContentTypeId"] = $NewContentType.Id
            Write-host "Content type changed for item: "$

#Variables for processing
$WebURL ="Site URL"
$ListName ="Library Name"
$ContentTypeName ="New Content type Name"

#Get the Web and List
$Web = Get-SPWeb $WebURL
$List = $Web.lists.TryGetList($ListName)

if($list -ne $null)
    #Call the function to add content type
    Change-ItemContentType $web $list "Old Content type Name" "New Content type Name"

Happy SharePointing :)

Thursday, 20 October 2016

SharePoint : URL list

We all are working, enjoying, exploring and learning something new everyday with SharePoint.

There may other articles related to it. Just want to throw my cap in the ring.

This will help you when your  site settings is missing and no where to find in the GUI . There are few URL which can save your day.

You just have to add URL at the end of the site below screenshot for your reference.

So lets get starts :)

Site Settings /_layouts/settings.aspx
Site Contents /_layouts/viewlsts.aspx
User Alerts /_layouts/sitesubs.aspx
Workflows /layouts/wrkmng.aspx
Gallery /catalogs/solutions
Site content and structure Manager /_layouts/sitemanager.aspx
site content types /_layouts/mngctype.aspx
people and groups /_layouts/people.aspx
Manager User permissions /_layouts/users.apsx
Site column gallery /_layouts/mngfield.aspx
Recycle Bin /_layouts/adminrecyclebin.aspx
Master Page Gallery /_catalogs/masterpage
Web part gallery /_catalogs/wp
Create /_layouts/create.aspx
List Template Gallery /_catalogs/It
Manage Site collection Administrators /_layouts/15/mngsiteadmin.aspx
Manage site and Workspace /_layouts/mngsubwebs.aspx

 Let me know if i missed on something will update that .
Happy SharePointing :)


Tuesday, 18 October 2016

SharePoint 2016 : Create Web Application and Site Collection Using PowerShell.

This post will help you on how to create Web Application and Site Collection using PowerShell.

i am going to create Web Application as  http:Sharepoint with port 32789.

Before we create lets see the web application list i have in my farm.

So lets get started.

Creating Web Application

Open SharePoint Management shell or Windows Powershell ISE run it as administrator.

Run below PowerShell Script

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$authentication = New-SPAuthenticationProvider -UseWindowsIntegratedAuthentication -DisableKerberos

New-SPWebApplication -Name "SharePoint2016" -Port 32789 -ApplicationPool
"SharePoint2016" -ApplicationPoolAccount (Get-SPManagedAccount "Sutta\Administrator")
-AuthenticationMethod NTLM -AuthenticationProvider $authentication

It will take some time to create and once successful you will see the below screen.

Now, go and check web application list again.

New Web application has been created and added to the list.

Creating Site Collection

Run below PowerShell command  to create a site collection

New-SPSite http://sharepoint:32789/Sites/SP -OwnerAlias "Sutta\Administrator" -Name "Root" -Template "STS#0"

It will take some time to create and once successful you will see the below screen.

Now, we again check the site collection list.

Site collection has been created.

Happy SharePointing :)

Friday, 14 October 2016

Configure User Profile Service Application in SharePoint 2016

This post will help you to configure the User Profile Service application

User Profile Service application require MMS application in running mode.please make sure you configure MMS before you start with User profile service.

Note : SharePoint 2016 has deprecated Forefront Identity Manager (FIM) which we used in SharePoint 2013.
Microsoft has replaced FIM with Microsoft Identity Manger (MIM). You have to install and configure MIM only if you required sync data 2 way from and to AD.

This UPA which we are creating will do only Active Directory Import.

So lets get started :)

1. Open Central Administration--> Application Management--> Manage Service Application
2. Click New and Select User Profile service Application.

3. Enter a name for your UPS application and select create new application pool give a name to it.Also give name to your database accordingly.Click Create

5. It will take few minutes to configure your User Profile Service application.

 6. Once it is done,Click OK .You can see it listed on Manage Service Application page.

 7. Before you create a connection in UPS application.Make sure the account which you are using should have Replicated Directory change and read/write permission on the domain.

8.Open the User profile Service application manage page.Click on Configure Synchronization connections.
9. Click on Create New Connection.

10. Give name to your connection, then enter your forest name,give the account details you are using for sync purpose and click on populate container.

11. Select the OU which you want to sync in SharePoint and click OK.

12. Connection created, Now go to home page on User Profile service. We can see we have zero profiles.

13. Click on Start profile Synchronization. Select the Full sync for the first time after that you have to do incremental sync and click OK.

 15 Wait for profile synchronization status to become IDLE and after you can see your profile got imported to SharePoint

 We are done with User Profile in SharePoint. As mentioned above if you want 2 way sync then MIM need to be install. We will cover installation and configuration of MIM in different blog.

Hope it helps. Happy SharePointing :)

Monday, 3 October 2016

Configuring Forms Based Authentication in SharePoint 2016 – Part 4 – Editing the Web.Config Files

This article will help you out on Configuring Forms based authentication (FBA) in SharePoint 2016 it is very similar to SharePoint 2013.

I have broken down steps in  4 articles.

1. Configuring SharePoint

2. Creating Membership Database

3. Adding users to Membership Database

4. Editing the web.config files.

 So lets get started :)

Part- 4 Editing the Web.Config Files

We have reached the last step to configure and then test FBA.

 We will edit the web.config of FBA based web application and make changes to People Picker Wild Card section.

  • In IIS expand the site and Right click on FBA site then click on Explore.

  • Edit the web config. Search for People Picker Wild Cards and make the below changes. Save the Web config.

  • Now,we have to test our FBA configuration. First i will login with window authentication and give access to FBA users and after that we will try FBA authentication.

  • After log in. Go to Site settings and click on People and groups.

  • Click on New and Search for the .net users.
  • Grant him the permissions and Sign out from the site
  • From Sign In drop down select Form Authentication.
Now, Enter the Username and Password.

You have successfully configured FBA in SharePoint 2016.

Happy SharePointing :)

Configuring Forms Based Authentication in SharePoint 2016 – Part 3 – Adding users to the Membership Database

This article will help you out on Configuring Forms based authentication (FBA) in SharePoint 2016 it is very similar to SharePoint 2013.

I have broken down steps in  4 articles.

1. Configuring SharePoint

2. Creating Membership Database

3. Adding users to Membership Database

4. Editing the web.config files.

 So lets get started :)

Part-3 Adding users to Membership Database

  •  Open IIS manager
  • Select IIS Server Name on the left navigation
    • Click on the “Connection Strings”

  •  Click on ADD.
  • Enter name of Connection String
  • Enter SQL Server Instance Name
  • Enter Database Name
  • Verify the Connection String and make sure it is correctly build up

  • Once done we can see the connection string in IIS manager.
  • Now Click on Providers.

  • Click on Add.
  • Select Type as “SqlRoleProvider”
  • Enter Name
  • Enter Connection String Name 
  • Enter Application Name as “/”. Click OK

  • Select Feature “.Net Users” from the drop down and Click Add

  • On the “Add Provider” Screen and Select Type as “SqlMembershipProvider”
  • Enter Name as appropriate
  • Configure behavior of the Membership Provider
  • Choose Connection String Name we created earlier under Data Section
  • Application Name under General Section will be "/"

  •  Expand the sites in web application pool and Click SharePoint Web services.
  • Select STS and Click on Provider.
  • Follow same as above steps to Add Provider. Below are the screenshot for reference.

  • Now we will add users to Membership database.
  • Select the Sites FBA and click on .Net Users.

  •  Click Add and fill out the required fields.Click Next and Finish.

  •  Once done user has been added to .net users.

 We are done with Part-3 now we will move to the last part which is editing the web.config files.

Happy SharePointing :)