Wednesday, October 7, 2009

This operation can be performed only on a computer that is joined to a server

Scenario:
While trying to back up my site collection using stsadm command

stsadm -o backup -url http://localhost -filename "newbackup.bak" -overwrite

I got the following error.

Error : 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 and Technologies Configuration Wizard, located on the Start menu in Administrative Tools.

Solution:

This is indirectly saying that you have been Access Denied to the farm.

1. Make sure that you are running this command from one of the machine which is part of the sharepoint farm

2. You should be a Farm Administrator

3. Sometime step 2 is not enough and you might again get Access Denied on the Content Database. You need to be site collection administrator.

4. If still you are facing issue, make sure to add your self to the appropriate content database.

5 comments:

Anonymous,  November 10, 2009 at 4:07 PM  

Or, your farm administrator account might just be locked out.

Anonymous,  September 10, 2010 at 7:37 PM  

If you are using SharePoint 2010. Make sure that your project type is set as AnyCPU instead of x86. Otherwise you will get the same error.

Anonymous,  September 23, 2010 at 10:01 PM  

Good call, setting the target CPU To AnyCPU instead of x86 worked for me too.

Anonymous,  January 21, 2012 at 8:14 AM  

can't thank you enough the anycpu thing dit te trick for me too

Anonymous,  July 10, 2013 at 5:16 AM  

Make sure sharepoint administration services and search services in "services.msc" running.