Wednesday, 28 September 2016

Creating UDL to test the Connection between SharePoint and SQL.

This post will guide on how to create and test the connectivity between SharePoint and SQL.

So lets get started :)

Sometimes while working on SharePoint we may encountered issue like

"A Network- related or instance occurred while establishing a connection to SQL server"
"The server was not found or was not accessible".

So UDL is the best way to test whether our SharePoint is able to communicate with SQL or not

Below are the steps to create the UDL:

1. Right click on the desktop and Go to New > Text Document

2. Now open the Text Document and Click on Save As. Give a name with UDL extension for example Test.UDL and Select All files in Save as type.

3. You text document will look like this now

4. Now we will check the connection between SharePoint and SQL. Open the UDL file.

5. Enter the SQL server name and Select window or specific username (they should have access to login to SQL) and Click on Test Connection

6. If communication is happening you will get result "Test connection succeeded". Otherwise it will fail.

Hope this article helped you out.

Happy SharePoinring :)

Monday, 26 September 2016

PowerShell to disable and enable the Sync option in SharePoint

This post is related to Power-shell cmd to disable and enable the Sync option in SharePoint

So lets get started :)

Our Sync option is working fine.

If you are using window Power-Shell then you have to add Power-Shell snap-ins for  SharePoint.

I ran these cmds on SharePoint management Shell
To disbale the Sync option  (ExcludeFromOfflineClient=1)

Get-SPSite -limit all | get-SPWeb -limit all | Foreach { $_.ExcludeFromOfflineClient=1;

After successfully completion of commands our sync option has been disable.

Now, we have to enable the Sync option again.
To enable the Sync option  (ExcludeFromOfflineClient=0)

Get-SPSite -limit all | get-SPWeb -limit all | Foreach { $_.ExcludeFromOfflineClient=0;

After successfully completion of commands our sync option is enable again.

Happy SharePointing :)

How to Disable the Sync option in Sharepoint 2016

Sync option enable users to keep copies in sync between SharePoint libraries and User's local disk.

Lets get started :)

We have to disable the sync option which can see on site collection level or at document libraries.

Steps to disable sync option:

1. Go to Site Settings.

2. Click on "Search and offline availability" under Search

3. Select no for offline Client Availability and click OK

4.  The Sync option has been disabled.

Happy  SharePointing :)

Friday, 23 September 2016

Unable to see the recent uploaded document in SharePoint Document library

Many users faces this issue.

They upload the document but unable to see it in document library. No need to worry in this case.

You just missed one step which was to check in the file.

Please follow the below steps to resolve it.

1. Open the document lib.

2. Click on Document library settings.

3. Now click on "Manage File which have no checked in version".

4.You can see your documents there, select the document and click on "Take Ownership of Selection".

5.Come back to your document library and Check-in the document.

Issue Resolved

Happy SharePointing :)

Adding Microsoft Project .mpp files into Search

This post will help you out with searching .mpp (Microsoft project) file in SharePoint.

So lets get started :)

1. First of all we have to add .mpp extension to our search service application file types.

2. Go to Search Service Application manage page > Click on File types.

3. Click on New File Type. Enter extension .mpp and click OK

4. mpp extension has been added to file types

5. Most important part you have to do an index reset and then full crawl of local SharePoint sites .

6.Once after the completion of Crawling. You can try to search for .mpp file in your sites

Below are the search result for Microsoft project file (.mpp)

Happy SharePointing :)

Thursday, 22 September 2016

SharePoint 2016 Software and Hardware Requirements.

This post will deal with basic software and hardware requirement you should achieve before you go for a SharePoint 2016 installation.

So lets get started :)

Hardware Requirement:


Operating System:

SharePoint 2016 Supported O/S:

1. Window Server 2012 R2
2. Windows Server 2016 Technical Preview.

.Net Framework Requirements:

Supported .net framework are 4.5.2 and 4.6.

Note: From January 2016 Microsoft will only support .net framework 4.5.2 or higher.

SQL Server Requirements:

Supported SQL servers are :-

1. SQL server 2014
2. SQL server 2016

Happy SharePointing :) 

Wednesday, 21 September 2016

Search Service Application on Server did not finish loading Issue


While working on Search we faced very rare issue "Search Service Application on Server did not finish loading Issue"



Check event logs and uls logs  getting error message stating that application : the device is not in ready state.
Checked permission all were fine.
Even when i click on content source or Crawl logs getting the same error.

Tried searching some blogs on google and found out that below cmd can fix the issue:

PSConfig  -cmd secureresources

Run that cmd it will take somewhere 5 to 10 minutes to complete.While command was running i was sitting with my finger crossed.

After the completion of command we were still facing the same issue.



After the completion we again checked event logs just to see if we can pin point the root cause 

This time we found out the search account was unable to connect to search database.

So after giving the access on db still no luck

So i thought of running the SharePoint Product Configuration wizard to put my bits n piceces in place.

Once SharePoint Product Configuration wizard was complete. I went to check the search application 
and this time is back to normal with running status, searchable items. everything was back to normal

Hope this will help you resolve your issue
Happy SharePointing :)

Monday, 19 September 2016

Change Server role in this Farm SharePoint 2016

This post will help you out on how to change the role of your server in the farm.

As you all know SharePoint 2016 comes with Min Role feature which helps us to select a role for our servers.
Below are the list of roles which are available to us

So, now i have a requirement to change of application server role to distributed cache role

Follow below steps to achieve it :-

1. Go to Central Administration > System Settings.

2. Click on "Convert server role in this farm".

3. Now, Select the role from Drop Down and click Apply.

You are done, you have changed the role of your server.

Happy SharePointing :)

SharePoint 2016 Products configuration Wizard failed at Step 3


While Running the SharePoint Products configuration Wizard it got failed at Step 3 which was creating SharePoint config Db.

Checked the logs found the below Error

Trouble Shooting:

Was thinking that is something to do with the account i am using to configure the SharePoint.

So logged into SQL and give Db creator , Sysadmin and security admin to the account which i was using.After that run the SharePoint Products configuration Wizard again but it still fails at steps 3.

Suddenly i saw anther error but this on SharePoint Products configuration Wizard GUI only.

It stated the The RPC server Unavailable.

Resolution :

To add the IP address in host file open the following file: c:\Windows\System32\Drivers\etc\hosts in notepad and add entry for your DC.

In my case it was

After that SharePoint Products configuration Wizard was completed with any issue.

Happy SharePointing :)

SharePoint 2016 Step by Step installation.

This post will help you with Step by step instruction to install SharePoint 2016.

Before installing you must have to install SQL and add Active directory role. So that you can create separate user to run SharePoint and SQL.

I have already configured SQL and now will install SharePoint 2016.

So lets get started :)

1. Install the Pre-requisites. On SharePoint ISO click on Pre-requisite installer and if you are connected with internet it will automatically download and install all the required requisites.

2. Wait while Prerequisites are getting installed.

3. As we can see all the prerequisites has been installed. After that click on Finish your machine will restart.

4. After restarting the Machine we will run the SharePoint Set-up. It will ask for Product key.
 I have Trail key for 180 days (NQGJR-63HC8-XCRQH-MYVCH-3J3QR).Enter it and click Continue.

5. Installation will start wait for it to get complete.

6. Once installation got completed.Select Run SharePoint Product Configuration Wizard and Click Close.

7. SharePoint Product Configuration Wizard will Open and Now Click Next

8. Click on Yes.

9. As you are creating a new server farm. Select Create a new server farm and click Next

10. Enter your Database Server name and Database access account. Click Next

 11. Enter Passphrase and remember it because we have to use it on each server that joins our farm.

12. Best thing in SharePoint 2016 know as MinRole. You can select your server role . I have selected as an application server role. You can select as per your requirement.

13. You can change the port number if you want i preferred to keep it default and click on Next

14. Double Check your setting and click Next.

15. Now we have to wait while SharePoint  2016 is getting configured

 16. After completion of configuration it will open below page. Click Cancel

 17. Now your SharePoint 2016 is installed and waiting for you to explore and play with it.

Hope this article will help you with SharePoint 2016 installation.
If you liked the article please leave a comment.

Happy SharePointing :)

Wednesday, 14 September 2016

Remove Content Database from SharePoint using Powershell

SharePoint Content DB is most important part of SharePoint because its contain most of the dta. But sometimes we may have to delete it.

This post will help you out on how to delete or remove content DB using PowerShell

So lets get started :)

We will use Remove-SPContentDatabase cmdlet to remove the Content Db.

PowerShell Cmd

Get-SPContentDatabase -identify "Content DB name" | Remove- SPContentDatabase

Once you run the above cmd it will ask you confirmation.

Type Y to confirm it and it will remove it from SharePoint.

It will also ask for removing it from SQL Database.So it totally depends on your requirement.

Type Y if you want to remove it otherwise type N

Happy SharePointing :)

PowerShell script to create a list and add a lookup column

Many times we got requirement for client or some to create a custom list and add look up column to it.

As we all know, we can do it thru SharePoint GUI.

But this post will help you to do via Powershell.

So lets get started :)

Adding a List

$SpWeb = Get-SPWeb -Identity "http://SharePoint"
$SpTemplate = $SpWeb.ListTemplates["Name of list"]
$SpListCollection = $SpWeb.Lists
$SpListCollection.Add("listName", "listName", $SpTemplate)

Adding Lookup Field

$ParentList = $SpWeb.Lists.item("ParentList")
$SpList = $WebObj.Lists["listName"]
$SpChildListLookupField = $SpList.Fields["ChildLookupField"]
$SpChildListLookupField.LookupField = $ParentList.Fields["ParentLookupField"]

Happy SharePointing :)

Tuesday, 13 September 2016

The Database name located at the specified database server contains user-defined data Error in SharePoint Product Config Wizard

While running the SharePoint Product Configuration Wizard. Sometimes, we ran into below error.

This post will help you to resolve the above error.

So lets get straight down to resolution and cause of it.


This is due to the fact, previous installation failed in between and left the SharePoint_Config database in SQL Server.


Delete the SharePoint_Config database which was created by previous installation and Run the SharePoint Product Configuration Wizard again.

Happy SharePointing :)

Powershell for Super User and Super Reader Account

This post will help you to identify the Super User and Super Reader Account in SharePoint

So lets get started :)

We have powerfull tool called PowerShell and its always to good to use it so for finding the Super accounts we will use that tool

Run the SharePoint 2010 Management Shell with Administrator rights.

Super user account

To find Super User below is powershell cmds

$wa = Get-SPWebApplication -Identity "<WebApplication>"

Super reader account

$wa = Get-SPWebApplication -Identity "<WebApplication>"

Happy SharePointing :)

Friday, 2 September 2016

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered

As there are so many post related to the error. So just wanted to throw my ball in the court.

So lets get started :)

When ever you are running any powershell cmd or script you are getting below Error.


1. The account which you are using to run the powershell should have  below access on SharePoint Config DB
  • DB_Owner access
  • SharePoint_Shell_Access
2. Other way to add it is using a CMD
    Add-SPShellAdmin -username DOMAIN\Username

3. If above doesn't help you and you are still facing the error. You have to run PowerShell As an Administrator.

Hope this post help.
Happy SharePointing :)