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

Access denied. You do not have permission to perform this action or access this resource.

Error:
Access denied. You do not have permission to perform this action or access this resource.

Stack Trace:

at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream)
at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse()

at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryToServer(ChunkStringBuilder sb)

at Microsoft.SharePoint.Client.ClientRequest.ExecuteQuery()

at Microsoft.SharePoint.Client.ClientRuntimeContext.ExecuteQuery()

at Microsoft.SharePoint.Client.ClientContext.ExecuteQuery()

at ConsoleApplication2.Program.getSubWebs(Web orootweb, String path)

Error Code:
clientContext.Load(oWebsite, website => website.Webs, website => website.Title);
clientContext.ExecuteQuery();
 
Error Cause:
There lots of SubSites and some Webs has not permission so when we call  "website => website.Webs" above error file.
 
Error Resolution:
There is one out of the box method for fetch Current User's site (WebCollection result = oWebsite.GetSubwebsForCurrentUser(new SubwebQuery());).
 
Working Code:
WebCollection result = oWebsite.GetSubwebsForCurrentUser(new SubwebQuery());
clientContext.Load(result, n => n.Include(o => o.Title));
clientContext.ExecuteQuery();
 

Happy SharePointing...!!!

The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

Error:
The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

Solution:
1.Open Central Administration
2.Click on Configuration Wizard right hand side navigation links and then Launch the Farm Configuration Wizard.
3.Start the Wizard
4.Make sure checkbox along with State Service is checked.
5.Click Next.
 
 
Happy SharePointing...!!!

Error occurred in deployment step 'Recycle IIS Application Pool'

Error:

Error occurred in deployment step 'Recycle IIS Application Pool': The open operation did not complete within the allotted timeout of 00:01:00. The time allotted to this operation may have been a portion of a longer timeout.

Solution :

Close you VisualStudio Project & open again.

Happy SharePointing...!!!

Error occurred in deployment step 'Activate Features': Unable to locate the workflow's association data.

Error :  "Error occurred in deployment step 'Activate Features': Unable to locate the workflow's association data. To restore the association data to the workflow, restart the workflow settings wizard by selecting the workflow node in Solution Explorer and then clicking the ellipsis button (…) on one of the properties in the Properties window that has an ellipsis button"

Solution : Goto Visual Studio 2010 > Right Click on Workflow file > Property Window  >  Click on any one of (History List/ Target List / Task List ) ...
Then, one popup window will opend and fill required details.

Happy SharePointing...!!!

Microsoft SharePoint is not supported with version 4.0.30319.239 of the Microsoft .Net Runtime

SharePoint 2010 does not support access from .NET Framework 4 or being run in a .NET Framework 4 app domain.

Solution :
If you must support the .NET Framework 4, we recommend that you develop a web service that uses the .NET Framework 4 and then connect to it from SharePoint.

Limitation:
All server-side customizations directly for SharePoint 2010 still need to be either the .NET Framework 3.5 or the .NET Framework 3.5 SP1.

You can't directly give the reference of assembly which has run time framework is 4.0.


Happy SharePointing...!!!

Visual Upgrade in SharePoint 2010

There so many ways to Visual Upgrade Migrated SharePoint Site.

One of this is run power shell script from SharePoint 2010 Management Shell.

All Site Collection Upgrade under Single Web Application as below command

    $webapp = Get-SPWebApplication http://UIVersion3WebApps/

    foreach ($s in $webapp.sites)

    {$s.VisualUpgradeWebs() }

Site Collection Upgrade including All Sub Webs as below command

    $site = Get-SPSite http://UIVersion3SiteCollection/

    foreach ($web in $site.AllWebs){$web.UIVersion = 4;$web.Update();}

Only Site Collection Web Upgrade without All Sub Webs as below command

    $site = Get-SPSite http://UIVersion3SiteCollection/

    $site.VisualUpgradeWebs()

Only Single Web Upgrade as below command

    $web = Get-SPWeb http://UIVersion3SiteCollection/site

    $web.UIVersion = 4;

    $web.Update();

Happy Upgrading !!!

MOSS 3.0 to SharePoint 2010 Migration

MOSS 3.0 to SharePoint 2010 Migration

1. Take a Content Database backup from MOSS 3.0 DB Server.
2. Restore it in SharePoint 2010 DB Server.
3. Add Restored Database in SP 2010 existing Web Application.
4. Remove older Content Database (which created with web application creation time)
5. Move all related files from MOSS 3.0 to SP 2010 farm. Ex. – Customization (Features, User Controls, Web Parts, Custom Application Pages, and Timer Jobs etc.), Third Party controls etc.
6. Run PreUpgradeCheck Power Shell script from SharePoint 2010 Management Shell (I will we back with new post)
7. After successfully run this command browse you site it should be working with UI Version 3.0.
8. For SharePoint 2010 look & feel you have to change UI Version 4.0 (Visual Upgrade see my new post).

Happy Migration !!!

Free PDF Viewer for Microsoft SharePoint 2010 Content Editor Web Part

You can configure PDF Viewer in you Content Editor Web Part easily.

1. Add Content Editor Web Part in you Page.

2. Add Below HTML code in this

3. Save Page then Display like below.

Happy Coding !!!

Error occurred in deployment step 'Add Solution': Failed to extract the cab file in the solution.

Error Message: Error occurred in deployment step 'Add Solution': Failed to extract the cab file in the solution.

One day I tried to deploy Images in _layouts folder using VS 2010. But I couldn't deploy Images because above error message fired in VS2010's error window. After half and hour I found one file named with blue_button (2).gif and renamed with blue_button.gif and deploy solution. Its working fine.

Resolution: To work around this problem, remove any parentheses in the names of SharePoint project items.

This link help me to solve the problem http://msdn.microsoft.com/en-us/library/ee330922.aspx.

Happy Coding !!!

Register Javascript using SharePoint Feature

You can register JavaScript and CSS without change your SharePoint sites master page.Follow below steps to register JavaScript in master page.

• Open VS 2010 & create one blank SharePoint 2010 Project.

• Then Add New Item & select SharePoint 2010’s “Empty Element” and give name “JQueryRegisterElement” as below.

• Then right click on project and add “SharePoint Mapped Folder” & select “Control Templates” as below.Then add one Usercontrol in this Control Templates folder.

• Now open Element.xml and add below code for register JavaScript.

Then open UserControl

• Then Right click on project, Deploy it & open SharePoint Site. You will see below popup.

Happy Coding !!!

Access denied by Business Data Connectivity

When I tried to fetch SQL Data using BDC using diffrent user then Administrator below error I found. Open Central Administrator Site and then open Application Management Tab's Manage Service Appplications link as below.

Select Business Data Connectivity Service as below
Then after checked your external content type's set object permissions as below.

Add your Users and set permissions as below

Now Open your External List & see all SQL Data.

Happy Coding !!!

Create Site Template using Sandbox Solution in SharePoint 2010

There are many way to create Site Template in SharePoint.I used below ways in my development experience.

1. Site Definition. - SharePoint 2010 (Site Definition project type in VS2010) - SharePoint 2007 (SharePoint Solution Generator create Site Definition & also WSPBuider, VSEWss1.3)
2. Site Provisioning (Programmatically) - You can create easily Site Template using this way because all controls in your hand (in your code). Add SPList, Delete SPList, Provision Web Part etc.
3. Site Template - For SharePoint 2010, Site Setting > Save as Site Template. Save as .WSP file in Solution Gallery. - For SharePoint 2007, Site Setting > Save as Site Template OR type /_layouts/Savetmpl.aspx in your web url. Save as .STP file in Solution Gallery.

Now I created Custom Site Template in SharePoint 2010 Sandbox.I refer this link.
You can create Web Template Feature in Sandbox Solution & give scope Site for this feature.
Given link will help for me so I hope it will help you.

Happy Coding!!!

Sandbox Solutions Support Elements

Capabilities and Elements in Sandboxed Solutions

Sandboxed solutions support the following capabilities and elements:

• List Definitions


• List Instances


• Onet.xml


• WebTemplate feature elements (instead of Webtemp.xml)


• Content Types/Fields


• Navigation


• Module/files


• Feature callouts


• Web Parts


• Support for all Web Parts that derive from System.Web.UI.WebControls.WebParts.WebPart
  


• Event receivers


• SPItemEventReceiver
  


• SPListEventReceiver
  


• SPWebEventReceiver
  


• Custom actions
  


• Declarative workflows
  

Sandboxed solutions do not support the following capabilities and elements:

• Visual Web Parts
  


• Application Pages
  


• Custom Action Group


• HideCustomAction element


• Content Type Binding


• Web Application-scoped features


• Farm-scoped features


• Workflows with code

SharePoint 2010 Installation on Windows 7

Now very easy to install SharePoint 2010 beta on Windows 7 OS.
Below link is very usefull to install SharePoint 2010 beta on your Windows 7.
http://msdn.microsoft.com/en-us/library/ee554869%28office.14%29.aspx