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.

Question

I have a Front-end server and SQL server. When we are trying to open Intranet on front end server we are seeing 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.

I am using user in AD which have all permissions in SQL Database. SQL server services are running, user is not expired.

I tried to run Sharepoint Products Configuration Wizard, but I got error:

Any Ideas? The SQL server was copied from other machine.

When accessing Central Admin the error is:

Answer 1

Hi @Marin ,

Check as following:

1. Make sure that you can ping your SQL server IP from the SharePoint front end server. ping Server IP
2. Make sure that the SQL Server Port is opened (the default port: 1433) by performing a telnet of the DB server IP with the SQL Server port in WFE server. telnet "the SQL Server IP" 1433
3. Make sure the App Pool account for Central Administration has access to the SP Config DB.
4. Make sure that the SharePoint Configuration database is not in recovery mode.
5. Make sure that all SharePoint servers within the farm are joined properly and working healthy!
   

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

More information for your reference:

https://spgeeks.devoworx.com/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/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.