After I restarted a SharePoint VM, then I tried to browse a SharePoint Site. I got the following 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.
Cause:
This problem usually occurs because of stopping the SQL Server Service.
The SQL Server Service may be stopped for several reasons, including
1. The SQL Server license has expired.
2. The SQL Server Service account credentials were changed.
Solution:
Just, change the machine date to the last date service was working.
Open SQL Server Configuration manager.
From the left side, below SQL Server Services > check the service status, if stopped try to start it.
The service is trying to start.
Repeat all the previous steps with SQL Server Agent.
The services now are running.
Again, Reset the machine date to today.
Try to browse the SharePoint site that should be now worked properly.
With respect to SQL Server Service account credentials were changed.
Open SQL Server Configuration Manager.
SQL Server Configuration manager
Within SQL Server Services, Check the SQL Server Instance and SQL Server Agent state (Running/Stopped).SQL Service Stopped
If it was running, try to restart it.
If it was stopped, try to start it.
If it was failed to start > Right Click on it > Properties > below Log on try to retype the user name and password then confirm it > Click Start. Reset SQL Server Account
It should be now started properly.
Thank you very much
Fahadullah Karimi
SharePoint Specialist
Next Post| New web application button was grayed out within Central Administration in SharePoint | Step by step upgrade from SharePoint 2010 to SharePoint 2013 |
No comments:
Post a Comment