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. ...
    • 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 ...
    • How to Resolve SQL Server Instance Not Listing Issue

      KB ID: 115912 Cause: The SQL Server instance might not be listed due to insufficient permissions during the installation of the BDRSuite Client Files Application, preventing access to SQL server entries in the system registry. Resolution Steps 1. ...
    • 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 ...
    • 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 ...