SharePoint Diary

How to Create Default Groups in SharePoint Site?

August 27, 2014 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Users and Groups

Problem: The default SharePoint groups are created automatically when you create a site collection through SharePoint Web UI. But, when you create SharePoint sites programmatically or with PowerShell (E.g. New-SPSite or New-SPWeb), The default site groups (such as: Visitors, Members, Owners) ar…

Installing and Configuring ADFS Integration with SharePoint 2013 - Step by Step Guide

August 26, 2014 Deployment Guides, Security, SharePoint, SharePoint 2007, SharePoint 2013

Introduction: Active directory federation services is the solution for extending enterprise identity beyond corporate firewall. It simplifies sharing identities between trusted partners across organizations. Its a common requirement in a typical business scenario, users in one organization wants…

SharePoint 2013 Warmup Scripts using PowerShell

August 22, 2014 Performance Optimization, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is "Warmup Scripts" in SharePoint? By default IIS applications pools recycles every night to keep clean memory space - Every time during IIS Application pool recycles - Asp.net assemblies to be re-compiled to serve the page to end user. So, When the recycling occurs during mid ni…

Save Site as Template in Sharepoint 2013 using PowerShell

August 22, 2014 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

How to save site as template in SharePoint 2013? The most easiest way to create a standard template for your SharePoint sites is to Create a site, Add-remove content, list and libraries to it and save site as a template from Site Settings >> Save Site as template. - Shortcut URL: "…

Create SharePoint Service Accounts in AD using PowerShell

August 22, 2014 Active Directory, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

I do a lot of SharePoint deployments now a days. I use PowerShell scripts to quickly create SharePoint service accounts instead of manually creating them in Active directory one by one. Run the below PowerShell script from domain controller (or from Remote Server Administration Tools installed wo…

How to Change Managed Account Password in SharePoint 2013?

August 20, 2014 PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

You may have to change your service account passwords for reasons such as: Password expiration, Security best practice, Your SharePoint guy left your company, etc. Remember those old days? You got to run stsadm -o updatefarmcredentials and update application pool accounts on every server in the f…

Create New Managed Account in SharePoint 2013 Using Powershell

August 20, 2014 PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Managed accounts are active directory accounts for SharePoint's whose credentials are managed by SharePoint. Managed accounts in SharePoint 2013 is explained in my another article: Configuring Managed Accounts in SharePoint 2013. Important: Before creating a managed account, They must be al…

Limit Maximum Number of Site Collections in SharePoint Content Database using PowerShell

August 19, 2014 Content Database, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

By default maximum number of site collections in a SharePoint 2013 content database is set to: 5000 and warning level will be 2000 as initial configurations. Although, technically SharePoint 2013 content database can hold up to 10,000 site collections maximum (2,500 non-Personal site collections …

"Open with Explorer" Greyed out in SharePoint 2013?

August 18, 2014 Known Issues, SharePoint, SharePoint 2010, SharePoint 2013

Open with Windows Explorer is Disabled in SharePoint 2013 or in SharePoint 2010? Well, Open with Explorer works only in 32 bit version of Internet Explorer! It may not work on Chrome or Firefox. Solution: To enable Open with explorer, Open your SharePoint 2010 or SharePoint 2013 site with…

How to Check SQL Server Connectivity from SharePoint?

August 14, 2014 PowerShell, SharePoint, SQL Server, Troubleshooting

How do I quickly check SQL Server connectivity from SharePoint server? Well, you can use Telnet. telnet {SQL-Server-Name or IP} 1433 If your SQL Server listens on different port, change the default port 1433 accordingly. Using PowerShell to test SQL server connectivity: Or you can use Power…

How to Rename SharePoint 2013 Central Admin Database to Remove GUID?

August 14, 2014 Central Administration, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Database

When you run the SharePoint products configuration wizard right after installing SharePoint binaries, it creates SharePoint central administration database with GUIDs. E.g. SharePoint_AdminContent_a149fa83-d2b9-4ad9-9e4c-ad12f73f0dd6. Your DBAs may not be happy with these GUIDs as they deviates…

Disclaimer