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.
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...!!!
Find the similar issue and solution at:
ReplyDeletehttp://praveenbattula.blogspot.in/2013/07/error-occurred-in-deployment-step.html
thank you praveen
DeleteIt helped.
ReplyDeleteI 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.
Yes.It's really usefull Nirav
Delete