Error - A Computer That Is Joined To A Server Farm By Users Who Have Permissions In SQL Server To Read From The Configuration Database – SharePoint

Error: Unable to Connect to SharePoint Server Farm Due to SQL Server Permissions Issue

KB ID: 82
Issue:
When attempting to connect to the SharePoint server farm via the Portal Site http://svsweb2:9999, an error occurs. The specific error message states: "This operation can be performed only on a computer that is joined to a server farm by users who have permission 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."
Cause:
This issue arises when the user accounts "UserAccountName" or "Administrator" lack sufficient permissions in the SQL Server contents databases of SharePoint site collections on the machine.
Solution:
To resolve the issue, follow these steps to add the "UserAccountName" to the MSSQL server:
1. Access the SQL SharePoint instance using Management Studio on the server.
2. In the "Object Explorer," navigate to the "Security" tree menu at the bottom. Expand the menu and select "Login." Right-click on it and choose "New Login." Then, enter your login credentials and select "sysadmin" under server roles.

    • Related Articles

    • Unable to List Databases during Microsoft SQL Server Backup

      KB ID: 110000 Case 1: Microsoft SQL Server services are not running properly. Problem: This error occurs when the system is unable to list databases. This issue may arise if the SQL Server service and its associated services are not running. ...

    • SharePoint Backup Error - Unable To List Site Collections

      KB ID: 81 Issue: When using BDRSuite Client for SharePoint backup, you may encounter an error that prevents the listing of site collections. This issue can be caused by various factors, and the following solutions provide guidance to resolve each ...

    • Unable to List Site Collections Under a Portal Site in SharePoint

      KB ID: 36 Purpose: When attempting to expand the node of a portal site in SharePoint, users encounter difficulties in listing the site collections under the portal site. This knowledge base article provides insights into the possible causes of this ...

    • SG0083: Error - Unable to Send Backup Details to Server

      KB ID: 115109 Cause: When performing backup jobs, the error "Unable to send backup details to server" may occur. This error is typically associated with large backup data sizes or unstable network connectivity. Solution: To address this issue, please ...

    • Troubleshooting Guide: SG0147/SG0136 - Unable to Connect to the Backup Server

      KB ID: 115098 Cause: This error typically occurs under the following circumstances: 1. The client is unable to connect to the BDR Server backup port (default 32004). 2. VembuBDR services are not running on the server machine. 3. The backup port ...