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.
While running psconfig wizard got error as “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”
“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.