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

When you run the SharePoint products configuration wizard right after installing SharePoint binaries, it creates a SharePoint central administration database with GUIDs. E.g. SharePoint_AdminContent_a149fa83-d2b9-4ad9-9e4c-ad12f73f0dd6. Your DBA’s may not be happy with these GUIDs as they deviate from database naming standards. So, let’s rename the SharePoint Central administration content database with the following…

Read more

Database is in compatibility range and upgrade is recommended – Solution

Problem:  After a service pack upgrade in SharePoint 2013, database status under  Central Admin >> Upgrade & Migration >> Review database status – turned into “Database is in compatibility range and upgrade is recommended” Solution: In most cases, this message simply means, You have installed the latest patch/service pack, and running SharePoint…

Read more

Fix “The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator.” Error in SharePoint 2013

Getting “The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator. Please resubmit the form with less data” error in SharePoint 2013 when trying to upload a file? Root cause: By default, SharePoint 2013 web applications have limitation on maximum upload size for documents. If…

Read more

Get SharePoint Central Admin URL in PowerShell

In PowerShell script writing, I had to get the central admin URL of the SharePoint farm. Tried various approaches and found the below to get SharePoint 2010/SharePoint 2013 Central Administration site URL using PowerShell: Alternatively,  you can use:

Read more

Increase Maximum File Upload Size in SharePoint

SharePoint 2013’s default file upload size is 250 MB! To upload large files you have to change the “Maximum Upload Size” setting in SharePoint 2013 Central administration site. How to increase file upload size in SharePoint 2013? The maximum upload size setting is configured per web application. To change the maximum upload…

Read more

Database is up to date, but some sites are not completely upgraded – Fix

Problem: Getting database status as “Database is up to date, but some sites are not completely upgraded” from “Review Database Status” page in Central Administration, Root Cause: This simple means: SharePoint Products Configuration wizard is unsuccessful in upgrading the specific database. Solution: Go to SharePoint Central Administration >> Upgrade and Migration >>…

Read more

Create Service Application Proxy Group in SharePoint 2013 using PowerShell

What is Proxy Group in SharePoint? SharePoint 2016 groups service applications together for consumption of the web application through proxy groups. These are simply groupings of service applications that you can deploy to different web applications. In other words, A proxy group is a link between a web application and service application…

Read more

Usage and Health Data Collection Proxy Stopped in SharePoint 2013

Problem: Usage and Health Data Collection Service Application collects Data for Health Monitoring and usage Analytics Service. We found the Usage and Health Data Collection Proxy status in “Stopped” state, after deploying SharePoint 2013 to a new environment, from: Central Administration >> Application Management  Manage Service Applications Page Solution: If you see…

Read more