powershell

Scenario: You are working in a site collection where the root site was instantiated from a web template.  You have then created subsites which you wish to save as a web template.  Upon doing so, you receive an error. Issue: Error exporting the list named “Announcements” at the URL: Lists/Announcements If you rename the list…

Read More

Add/remove sharepoint group using power shell Content from http://vimleshtiwari.blogspot.com/2011/01/addremove-sharepoint-group-using-power.html #Add a sharepoint group using power shell#Create a sharepoint custom permission using Power shell$web = get-SPWeb “http://sitecollectionName” $member = $web.AllUsers[“domain\username”] $CustomPermission =”Permission Name” $CustomRoleRoledef = New-Object “Microsoft.SharePoint.SPRoleDefinition” $CustomRoleRoledef.Name = “$CustomPermission” $CustomRoleRoledef.Description = “Custom permission level for Site Owners” $CustomRoleRoledef.BasePermissions = “CancelCheckout,AddListItems,EditListItems,DeleteListItems,ViewListItems,OpenItems,ViewVersions, DeleteVersions,CreateAlerts,ViewFormPages,ViewUsageData,ViewPages,BrowseUserInfo,ManageAlerts, UseRemoteAPIs,UseClientIntegration,Open” $web.RoleDefinitions.Add($CustomRoleRoledef) $web.Update() # Create…

Read More

Detail:  Using built-in accounts like Network Service or Local System as application pool or as service identities is not supported in a farm configuration.  The following services are currently running as built-in identities on one or more servers: SPTraceV4(Windows Service) SPSearch4(Windows Service) Solution:  SPSearch4 will be assigned to run under a domain user with no…

Read More

Detail:  InfoPath Forms Services is not functional on the following Web applications because there is no service connection configured for the State Service. Solution:  A State Service Application has to be created and associated with the active web applications.  This will be done via PowerShell as follows: Create a new state service application: New-SPStateServiceApplication -Name…

Read More

Reference source: http://sharepointbergen.blogspot.com/2010/05/sharepoint-2010-excel-services-workbook.html “The Workbook cannot be opened.” $w = Get-SPWebApplication $w[0].GrantAccessToProcessIdentity(“domain\account”) Note: this must be done for each web application, this example assumes that the first (0) web application is the one being referenced.

Read More
  • Posted By: Jonathan Adams
  • Comments Off on SharePoint 2010 Excel Services – “The workbook cannot be opened.”