10

This error appears frequently and sometime disappears after refresh

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.

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.

2
  • try accessing your database with the credentials you are using for login in your sharepoint site.
    – Deepika
    Oct 28 '14 at 11:09
  • If you are unable to login with the credentials you have for the DB then check my answer. It will help you.
    – Ram
    Nov 14 '16 at 5:48
5

This issue would occur if the user account "UserAccountName" or "Administrator" doesn’t have enough permission in the SQL server contents databases of SharePoint site collections in your machine. So, add the "UserAccountName" to your MSSQL server by following the below steps:

  1. Go to that server and open the SQL SharePoint instant using Management Studio.

  2. Then in the "Object Explorer" you can see the "Security" tree menu at the bottom. Expand that menu and Go to "Log in" and right click it and click "New Login". Then put your login there and under server roles select "sysadmin".

You can refer This operation can be performed only on a computer that is joined to a server farm link.

15

I got the same error and i did the following steps and worked for me.

Go To services.msc Restart the SQL Server (SharePoint) & SQL Server Agent (SHAREPOINT) Check the web site, It'll work.

enter image description here

Hope this will help to any one.

8
  • 1
    Great!! that helped me a lot. Jan 17 '17 at 14:38
  • 1
    In my case, Sql server agent service (SHAREPOINT) was disabled.
    – Kevin .NET
    Sep 6 '17 at 17:35
  • 1
    In my case SQL Server Agent (SHAREPOINT) was disabled. I restarted only the SQL Server (SHAREPOINT) service and it worked for me.
    – Naveen
    Oct 30 '17 at 8:01
  • 1
    In my case SQL Server (SHAREPOINT) service wasn't started. Jun 9 '19 at 6:14
  • 1
    Yes, @Matt Please check on your server where the SQL is installed.
    – Ram
    Oct 1 '19 at 8:42
2

In my case the user account under which apppool for web application was running was locked. unlocking the user account solved the issue.

0

In my case:

  • User was already in sysAdmin group in SQL Server

  • Restarting SQL services did not work

  • Account was not locked..

    IIS Reset did work :)

0

The scenario I faced was as follow:

  • A power failure caused all server in the company get down
  • After restarting the power all servers started again
  • In some cases and for some misterious reasons the sql server service was not configured to run automatically (I have no access to the database center) and so the SharePoint SQL Server Service did not start
  • The Solution was to restart the SQL Server instance.
0

in my case the problem was that the "Security/Logins" of a new Instance clustered in a AlwaysOn High Availability Group, has replicated all the environment and application DDBB but not the logins.

I've created manually all the missing logins on to the new SQL AlwaysOn AG, copying them from the Master and worked properly.

Hope this information could help in the future, User Logins doesn't replicate on a AlwaysOn AG.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.