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

I tried to browse a SharePoint Site. I got the below 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 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

  • The SQL Server is down.
  • The SQL Server Services are stopped.
  • The Database server is not reachable from the Application server.
  • The SQL Server license has expired.
  • The SQL Server Service account credentials were changed.

Solution

The SQL Server is down.

Make sure that the SQL Server is up and running.


The SQL Server Services are stopped.

  • 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 Database server is not reachable from the Application server.

Try to telnet the DB server IP from App server, and make sure it’s reachable from APP server as mentioned at HOW TO CHECK SQL SERVER INSTANCE CONNECTIVITY FROM THE APPLICATION SERVER TO DATABASE SERVER FOR A SPECIFIC USER.


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 are now running.

SQL service Started

  • Again, Reset the machine date to today.
  • Try to browse the SharePoint site that should be now worked properly.

Check also SQL SERVER EVALUATION PERIOD HAS EXPIRED, HOW TO EXTEND IT?


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 is 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 username and password then confirm it > Click Start.

Reset SQL Server Account

  • It should be now started properly.

SQL service Started


Applies To
  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
See Also
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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s