9

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.

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" in 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 "Security" tree menu at the bottom. Expand that menu and Go to "Login" and right click it and click "New Login". Then put your login there and under server roles select "sysadmin".

You can refer this link.

13

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.

  • 1
    Great!! that helped me a lot. – Burre Ifort 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. – Slaven Semper Jun 9 at 6:14
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 :)

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.