While working on one of the existing SharePoint server, I tried
to open the SharePoint central admin site. I got an error saying that “A
network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible.” As shown
the image below.
This is the error due to SQL server service got stopped. To
fix the error we have to run the SQL Service as shown the image below.
But in my case, MSSQLSERVER service is started and running. Restarted
the service, but it wasn’t worked for me. By digging in to the deep I got few
details from system admin. The farm I am working is already had few sites. But
before handing that to me all the sites deleted from SQL server. When I try to
access the CA site it gives the error message.
Restarted SharePoint timer service, SQL server and all the
servers in the farm. Nothing worked for me. Finally ran SharePoint configuration
wizard. Super... it worked for me. Now I got the issue that some of my farm
users deleted DB’s in sql server directly instead deleting form CA. By running
the config wizard