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
“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”
Open the Windows Firewall with Advanced Services and add an inbound rule to allow traffic over port 1433.
There was an error while running Install Prerequisite (prerequisiteinstaller.exe) “Failed to create configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.”
Solution:
you may face this issue while installing manually instead of using the prerequisiteinstaller.exe
Uninstall WcfDataServices and then reinstalling the WcfDataServices using the prequisiteinstaller.exe automatically or using command with the appropriate parameter.
prerequisiteinstaller.exe /wcfdataservices56: WcfDataServices.exe location
Then delete two databases from SQL Server which are created by previous psconfiguration and run Products Configuration Wizard again, it will be successful.
“This program can’t start because api-ms-win-crt-heap-l1-1-0.dll is missing from your computer.” error while running SharePoint Products Configuration Wizard.
*Missing update patches “Windows 10 Universal Runtime update” for Windows Server 2012 R2.
But “The update is not applicable to your computer.” error came after that as below.
This is because Windows 10 Universal C Runtime KB2999226 is dependent on a Windows Server 2012 R2 Cumulative Update package in KB2919355.
Check windows updates, install patch KB2919355 and “The update is not applicable to your computer.”error will be resolved and after which there will be no error in installation of the Windows 10 Universal C Runtime.
Have a look into my previous post Install Prerequisite (prerequisiteinstaller.exe) SharePoint 2016.
Unable to install Microsoft Information Protection and control Client 2.1 error SharePoint 2016