question

Marin-4312 avatar image
0 Votes"
Marin-4312 asked JoyZ commented

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 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:

84661-123456.png


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

When accessing Central Admin the error is:

84617-1234567.png


office-sharepoint-online
123456.png (190.9 KiB)
1234567.png (216.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ commented

Hi @Marin-4312,

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.84721-image.png

  5. Make sure that all SharePoint servers within the farm are joined properly and working healthy!
    84713-image.png

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.



image.png (36.2 KiB)
image.png (34.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Marin-4312,

Is there any progress on this issue?

Please feel free to reply.

0 Votes 0 ·

Hi @Marin-4312,

I’m checking how the things are going on about this issue. Whether the post helps you?

You can accept the post as answer if it helps.

Thank you for your understanding and support.

0 Votes 0 ·