A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

Issue: The web application can’t find while we open the CA. In the ULS logs and Event viewer sees the error” A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections”

Solution: Ensure to check the below settings to get rid of the error.

·        Ensure SQL database and services are running.

·        Ensure to reboot  the DB server after applied a Hot fix or Service Pack.

·        Ensure the Firewall is not blocking the communication

·        Ensure The SharePoint Installation Account does have the required permissions to the SQL Server database.

·        Ensure Network connectivity is OK between the SharePoint Server and SQL Server

If issue Still persists, Restart the SQL services and restart the DB server If necessary.

 

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!