Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

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...!!!

Monday, April 12, 2010

SharePoint Site Cannot connect to configuration database


Error Message : Cannot connect to configuration database


Cause : When you try to open SharePoint site below error fire on your screen that means your Site can't connect SQL Server Database.




Resolution : Check your SQL instance Service from MS Services. If stopped SQL instance Service then Start it.

Example: Start > type this in RUN "services.msc " > as per below SQL Instance Start it from property.

Happy Coding !!!