Recently our SharePoint farm is facing SQL connectivity issue. Whenever I open any SharePoint Site I get the message shown below. This message appears 3 to 4 times in a day.
Error:
This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products Configuration Wizard, located on the Start menu in Microsoft SharePoint 2010 Products.
Â
This error occurs whe the SharePoint farm administrator cannot connect to your configuration database. make sure that from the SharePoint front end and application servers that you can ping your SQL server. make sure that your Farm account has permission to the configuration database. Lastly verify that your database didn’t for some reason go into recovery mode. once everything is fine and you are still having issues, restart the SQL host service on the SQL server. Once the service is restarted you will need to reboot Central Admin and then your front end servers.
Is the Database connected to the Farm? Heres a few resources to get you started.. https://social.technet.microsoft.com/Forums/en-US/d0c62398-a171-407…
