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

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.

this opeeration can be performed

Cause:

This problem usually occurs because of stopping the SQL Server Service.

the SQL Server Service may be stopped for several reasons, including

  • The SQL Server license has expired.
  • The SQL Server Service account credentials were changed.

Solution:

  • With respect to SQL Server license has expired.
    • Just, change the machine date to the last date service was working.
    • Open SQL Server Configuration manager.SQL Server Configuration manager
    • From the left side,below SQL Server Services > check the service status,if stopped try to start it.SQL Service Stopped
    • The service is trying to start.SQL service Starting
    • Repeat all the previous steps with SQL Server Agent.
    • The services now are running.SQL service Started
    • 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.SQL service Started

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s