Fix for “Cannot Connect to Database Master at SQL Server at Server Name. The Database might not exist, or the current user does not have permission to connect to it” SharePoint Error

Problem:When trying to create a new SharePoint farm using PowerShell, the SharePoint 2016 management Shell gave an error message:New-SPConfigurationDatabase : Cannot connect to database master at SQL server at <SQL-Server-Alias>. The database might not exist, or the current user does not have permission to connect to it. Tried using SharePoint products configuration…

Read more

An error occurred while getting information about the user <Farm-Admin> at server <Domain-Name>: The RPC server is unavailable

Problem: After installing SharePoint 2016 to setup a new farm, tried running SharePoint 2016 products configuration wizard, and the wizard failed at step 3 saying: Failed to create the configuration database. An Exception of type System.InvalidOperationException was thrown. An error occurred while getting information about the user <Farm-Admin> at server <Domain-Name>: The…

Read more

The Database name located at the specified database server contains user-defined data.- Error in SharePoint Products Configuration Wizard

Error:SharePoint Products Configuration Wizard:The Database name located at the specified database server contains user-defined data. Databases must be empty before they can be used. Delete all of the tables, stored procedures, and other objects, or use a different database. Root cause:This is due to the fact, the previous installation failed in between…

Read more

How to Create a SharePoint 2013 Farm using PowerShell to Avoid GUIDs?

Why to use PowerShell to create SharePoint farm rather the nice SharePoint products configuration wizard? Because, SharePoint Products configuration wizard creates Central Administration database names with GUIDs. Create SharePoint 2013 farm using PowerShell: How to start? Follow these steps to create SharePoint farm using PowerShell. Step 1: Install SharePoint binaries on each…

Read more

SharePoint Products Configuration Failed: Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.

Problem:After applying a service pack, Ran SharePoint Products Configuration Wizard. It failed with this error message: “An exception of type microsoft.sharepoint.postsetupconfiguration.postsetupconfigurationtaskexception was thrown. additional exception information: Failed to upgrade SharePoint Products.“ Tried Running the PSconfig upgrade using the command line, but that too failed: psconfig -cmd upgrade -inplace b2b -wait On scanning…

Read more

“There was an error during Installation, The tool was unable to install Application Server Role, Web Server (IIS) Role.” In SharePoint 2013 Products Preparation Tool

Problem: SharePoint 2013 Products Preparation Tool failed with an error “There was an error during Installation – The tool was unable to install Application Server Role, Web Server (IIS) Role.” during prerequisites installation in Windows Server 2012 R2. Solution: Mount the Windows 2012 R2 ISO into the drive and install the roles…

Read more

Configuration Failed: Failed to create the configuration database in SharePoint Products Configuration Wizard

Problem: Experiencing “Configuration Failed” error message while running SharePoint 2013 Products Configuration Wizard right after new installation/patching. It got stuck while performing configuration task 3 of 10. Creating the configuration database… Which ended with an error message: “Configuration Failed: Failed to create the configuration database.An exception of type System.Security.Principal.IdentityNotMappedException was thrown. Additional exception…

Read more

SharePoint 2013 Patch (Service Pack-CU-Hotfix) Installation Guide – Step by Step

So you want to maintain your SharePoint environment healthy, secure, stable, and up to date by installing the latest patches? Well, this article walks through the various steps involved in installing patches for your SharePoint 2013 environment. SharePoint 2013 patching best practices Before proceeding, let’s consider some of the best practices for…

Read more

Configuration Failed – Failed to connect to the configuration database: Error during decryption. Ensure the passphrase is correct.

Problem: Trying to add a server to SharePoint 2013 farm, after a passphrase reset. Got this error message.Configuration Failed Failed to connect to the configuration database:  An exception of type System.ArgumentException was thrown. Additional exception information: Error during decryption. Ensure the passphrase is correct. Troubleshooting: Double-checked my passphrase is correct. If my…

Read more

Some Farm Products and patches were not detected on this or other servers – Fix

After patching a SharePoint 2013 Farm, attempted running the SharePoint Products configuration wizard and receive this error message: “Error: Some farm products and patches were not detected on this or other servers.  If products or patches are missing locally, you must quit this program and install the required products and patches on…

Read more