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.

Improve this question
2
  • try accessing your database with the credentials you are using for login in your sharepoint site.
    – Deepika
    Oct 28, 2014 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, 2016 at 5:48

6 Answers 6

Reset to default
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.

Improve this answer
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.

Improve this answer
8
  • 1
    Great!! that helped me a lot.
    – Burre Ifort
    Jan 17, 2017 at 14:38
  • 1
    In my case, Sql server agent service (SHAREPOINT) was disabled.
    – Kevin .NET
    Sep 6, 2017 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, 2017 at 8:01
  • 1
    In my case SQL Server (SHAREPOINT) service wasn't started.
    – Slaven Semper
    Jun 9, 2019 at 6:14
  • 1
    Yes, @Matt Please check on your server where the SQL is installed.
    – Ram
    Oct 1, 2019 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.

Improve this answer
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 :)

Improve this answer
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.
Improve this answer
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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