Friday, June 7, 2013

Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

Error:
Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm. (see the image below)



Cause:
Your login user has no 'db_owner' access for SharePoint Databases.
1. SharePoint_Config
2. SharePoint_AdminContent_[XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX]
3.Your web application DB in which you want to deploy WSP (Example. WSS_Content_XXXX)

Solution:
Now connect your SQL Server with admin user.
Then select your user which has error in deployment.
Then assign all above DBs to db_owner rights. (see the image below)





Now try to deploy your WSP.

You can successfully deploy WSP.

Happy SharePointing...!!!

4 comments:

  1. Find the similar issue and solution at:
    http://praveenbattula.blogspot.in/2013/07/error-occurred-in-deployment-step.html

    ReplyDelete
  2. It helped.
    I added the user under Security and did server mapping. {Server -> Security -> Logins} & it worked.
    (The user was already added under Database -> db_name -> Security -> Users & was db_owner but it wasn't working.)
    Thanks.

    ReplyDelete