Fix MissingSetupFile Error of Test-SPContentDatabase in SharePoint Migration

Problem: Getting “MissingSetupFile” errors when you run the “Test-SPContentDataBase” cmdlet on SharePoint content databases during a migration process. [MissingSetupFile] File [Features\Feature-folder\feature-artifact] is referenced [1] times in the database [SharePoint_Content_database], but is not installed on the current farm. Please install any feature/solution which contains this file. One or more setup files are referenced…

Read more

Test-SPContentDatabase: Cannot open database [Database Name] requested by the login. The login failed.

Problem: In a SharePoint 2013 to SharePoint 2016 migration, I got this error message on testing the content database with Test-SPContentDatabase cmdlet  to identify possible issues:“Cannot open database [Database Name] requested by the login. The login failed” Troubleshooting: If your databases are hosted on a different SQL Server or instance, other than the…

Read more

The Current Number of Site Collections is 0 in SharePoint After Database Attachment

Problem:During a production SharePoint site cloning into UAT using Database attachment method, after attaching the content database to the web application in UAT environment, found the current number of site collections is 0 (zero). All site collections are missing! I tried “View All Site Collections”  from the SharePoint 2013 Central Administration site…

Read more

Access Denied Error After Migrating from SharePoint 2010 to SharePoint 2013

Problem: After migrating from SharePoint 2010 to SharePoint 2013 using the database attach method, all users received an “access denied” error, and they were unable to login. Confirmed both the source and destination SharePoint farms are in the same Active Directory domain. Root cause: This is because, by default SharePoint 2013 web…

Read more

Migrate SharePoint Users from One Domain To Another using Move-SPUser

Requirement: During an acquisition, Our company decided to merge with an acquired company’s AD by re-creating their user Ids in our AD. Also, the acquired company had a number of SharePoint sites, and we wanted to migrate them to our SharePoint environment. That brought another challenge of re-mapping user Ids with permission…

Read more

Find and Replace URL Links from Hyperlink Columns in SharePoint

Requirement: We had a SharePoint portal site called “Crescent Portal” with URL: https://portal.crescent.com. After migrating from SharePoint 2010 to SharePoint 2013, we decided to replace both site name and URL as “Crescent Intranet” with URL “https://intranet.crescent.com”. We understand there are plenty of lists and libraries hard-coded with the old site URL in…

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 the “Review Database Status” page in Central Administration. Root Cause: This simple means: The SharePoint Products Configuration wizard is unsuccessful in upgrading the specific database. Solution: Go to SharePoint Central Administration >> Upgrade and…

Read more

SharePoint 2013 deployment – Project Plan Template with Milestones

Assuming Hardware, Public IP, SSL Certificates, Domain Names are ready – Here is my SharePoint 2013 deployment project plan template with milestones outlined: Deployment Tasks 0. Project Kick-off, Team-setup, Identifying key stakeholders and Responsibilities 1.Pre-Deployment Activities 1.1 Planning Logical Architecture, Topology, Service Accounts, Domain URLs, Naming Standards, etc 1.2 Provision Service Accounts,…

Read more

Server Status Remains “Upgrade Available” Even After Installing the Latest Patches

Recently, We patched one of our SharePoint 2013 environment and ran SharePoint products configuration wizard without any issues. However, we noticed that the server status is still in “Upgrade Available” for SharePoint application & Web front end server from Central Administration > System Settings > Manage servers in this farm page. Ideally…

Read more

Find and Delete Orphaned Alerts in SharePoint

Problem Description: In Short – When users leave your organization and removed from Active Directory (AD) they become orphans in SharePoint! Also their alerts!! Why we care about them: To keep SharePoint clean, we’ve to remove em’ from all SharePoint sites. So, I’ve written a PowerShell script to scan all site collections…

Read more