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

Problem: In a SharePoint 2013 to SharePoint 2016 migration, 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 default…

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 missing! Tried “View All Site Collections”  from SharePoint 2013 Central Administration site, found nothing! No…

Read more

Access Denied Error After Migrating from SharePoint 2010 to SharePoint 2013

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

Read more

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

Requirement: During a 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 bunch SharePoint sites and we wanted to migrate them to our SharePoint environment. That brought another challenge of re-mapping user Ids with permission between…

Read more

Find and Replace URL Links from Hyperlink Columns in SharePoint

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

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

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

Migrate from SharePoint 2010 to SharePoint 2013 – Step by Step

So you are excited by SharePoint 2013’s new features and tend to migrate from SharePoint 2010 to SharePoint 2013? Well, this article walks through moving from SharePoint 2010 to SharePoint 2013 step by step, assuming all necessary migration preparations and planning strategies are done, lets move to the core migration process. Before…

Read more