Showing posts with label SharePoint. Show all posts
Showing posts with label SharePoint. Show all posts

Business Data Connectivity: SP2010 + SP2013

How to create business data connectivity service application

Access Denied by Business Data Connectivity – Resolved

Business Data Connectivity metadata store is currently unavailable

Sandboxed Solutions - SharePoint 2010

Last Access date / time for site collection

How to find out dead sites? 

How to find out unused sites? 

How to find out the sites which has not been updated from a long time? 

How to find out the sites which has not been updated from a long time? 

http://sharepointknowledgebase.blogspot.com/2014/02/last-access-date.html

Backup-Restore in SharePoint 2013 + Backup & Recovery Tools

access services problem in SharePoint 2010

Access services is unable to process the request
http://sharepointknowledgebase.blogspot.in/2013/08/access-services-is-unable-to-process.html

Cannot publish access database to SharePoint 2010 Server
http://sharepointknowledgebase.blogspot.in/2013/02/cannot-publish-access-database-to.html

If you are facing this error: 
There was an error in communicating with Access Database Service Access Database Service URL exception: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server

Then request you to refer the following KB: 
http://support.microsoft.com/default.aspx?scid=kb;en-us;2398833&sd=rss&spid=14944

If you are facing the following symptoms: 

1- Event ID: 24 Description: There was an error in communicating with Access Data Services exception: <exception description> [Session: <session ID> User: <username>].

2-  Event ID: 25. Description: There was an error in communicating with Access Data Services exception: <exception description> [Session: <session ID> User: <username>].

3- Event ID: 26. Description: Unable to reach Access Data Services. [Session: <session ID> User: <username>].

then request you to check the following article: 
http://technet.microsoft.com/en-us/library/ee513086(v=office.14).aspx

EXCEL + OFFICE + Ribbon grayed out features

Hello All, 
I have created this knowledgebase to share the break fixing solutions as well as what kind of troubleshooting I have executed towards that specific issue. Today’s KB is based on EXCEL + OFFICE that we use on regular basis by means of SharePoint site. 

Workbooks fail to load + Event 5231 + Event 5239 + Event 5240 + Error communicating with Excel Services Application + Unable to process the request = SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/workbooks-fail-to-load-event-5231-event.html

The specified file is not a valid spreadsheet or contains no data to import - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/the-specified-file-is-not-valid.html

An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery
http://sharepointknowledgebase.blogspot.in/2013/09/an-excel-workbook-that-contains.html

The list cannot be displayed in DataSheet view – SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/the-list-cannot-be-displayed-in.html

Your client does not support opening this list with Windows Explorer + IE10 + Windows 7
http://sharepointknowledgebase.blogspot.in/2013/09/your-client-does-not-support-opening.html

SharePoint 2010- New Document requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater. To add a document to this document library click the Upload Document button
http://sharepointknowledgebase.blogspot.in/2013/08/sharepoint-2010-new-document-requires.html

Ribbon grayed out features (Extremely imp on day 2 day functionality)

Connect to office disabled in SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/connect-to-office-disabled-in.html

Sync to SharePoint workspace greyed out - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/sync-to-sharepoint-workspace-greyed-out.html

To export a list, you must have a Microsoft SharePoint Foundation-compatible application - SharePoint 2010 + SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/to-export-list-you-must-have-microsoft.html

Upload Multiple Documents is disabled in Document Library- SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/upload-multiple-documents-is-disabled.html

How to enable ‘New Folder’ option in document library + Custom list + New Folder disabled - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/how-to-enable-new-folder-option-in.html

Datasheet view is disabled SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/datasheet-view-disabled-sharepoint-2010.html

Authentication provider disabled SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/authentication-provider-disabled.html

"Connect to Outlook" Disabled - SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/connect-to-outlook-disabled-sharepoint.html

Open with Explorer is disabled - SharePoint 2010 and SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/open-with-explorer-is-disabled.html

Upload Multiple Documents is disabled - SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/upload-multiple-documents-is-disabled_1.html

backup-restore in SharePoint 2010

Hello All,

I know backup-restore is a very important entity in SharePoint 2010 and is being heavily used by Administrators/Developers/IT Pros.

Please refer the following articles based on the same, Thank you


SharePoint 2010: Backup/Restore with PowerShell Command 
http://sharepointknowledgebase.blogspot.in/2012/06/sharepoint-2010-backuprestore-with.html

Backup Restore in SharePoint 2010 
http://sharepointknowledgebase.blogspot.in/2012/06/backup-restore-in-sharepoint-2010.html

Delete List Using PowerShell

Delete Document Library using PowerShell

Delete Site Collection by using PowerShell

Delete Subsite using PowerShell

Enable Site Features using Powershell

Add-PsSnapin Microsoft.SharePoint.Powershell –ErrorAction SilentlyContinue
Enable-SPFeature "SharePoint Server Standard Site features" -Url http://globas:1050

Delete List using Powershell

Add-PsSnapin Microsoft.SharePoint.Powershell –ErrorAction SilentlyContinue
$web = Get-SPWeb http://globas:1010
$custom = $web.lists["Articles"]
$custom.Delete()
$custom1 = $web.lists["BasicWebparts - Gallery"]
$custom1.Delete()
$custom2 = $web.lists["ContentSlides"]
$custom2.Delete()
$custom3 = $web.lists["domphoto"]
$custom3.Delete()
$custom4 = $web.lists["dp"]
$custom4.Delete()
$custom5 = $web.lists["gallery"]
$custom5.Delete()
$custom6 = $web.lists["photo1"]
$custom6.Delete()

Write-Host "Finished! Press enter key to exit." -ForegroundColor Green
Read-Host

Retrieve All Wsp from the Central Admin

Add-PSSnapin Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue
## setup our output directory 
$dirName = "c:\ExportedSolutions"
Write-Host Exporting solutions to $dirName 
foreach ($solution in Get-SPSolution) 
{ 
    $id = $Solution.SolutionID 
    $title = $Solution.Name 
    $filename = $Solution.SolutionFile.Name
    Write-Host "Exporting ‘$title’ to …\$filename" -nonewline 
    try { 
        $solution.SolutionFile.SaveAs("$dirName\$filename") 
        Write-Host " – done" -foreground green 
    } 
    catch 
    { 
        Write-Host " – error : $_" -foreground red 
    } 
}

Remove Solution from the Central admin using Poweshell

Add-PsSnapin Microsoft.SharePoint.Powershell –ErrorAction SilentlyContinue


Uninstall-SPSolution –Identity bamboo.logging.v1.wsp

Start-Sleep -Seconds 60

Remove-SPSolution –Identity bamboo.logging.v1.wsp


Uninstall-SPSolution –Identity basicwebpartssingle.wsp

Start-Sleep -Seconds 60

Remove-SPSolution –Identity basicwebpartssingle.wsp



Uninstall-SPSolution –Identity contentsliderwebpart.wsp


Start-Sleep -Seconds 60

Remove-SPSolution –Identity contentsliderwebpart.wsp


Uninstall-SPSolution –Identity mydocstreeview.wsp

Start-Sleep -Seconds 60

Remove-SPSolution –Identity mydocstreeview.wsp


Uninstall-SPSolution –Identity sampletodeployapage.wsp


Start-Sleep -Seconds 60

Remove-SPSolution –Identity sampletodeployapage.wsp

Write-Host "Finished! Press enter key to exit." -ForegroundColor Green
Read-Host

Delete Particular Subsite using Powershell

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction "SilentlyContinue"

$ParentSiteUrl = "http://spgalaxy:1025"

function DeleteSubSite([string]$SiteUrlName)
{
$SiteUrlName = $ParentSiteUrl + $SiteUrlName
Write-Host "SiteUrlName:" $SiteUrlName

Remove-SPWeb $SiteUrlName -Confirm:$false
Write-Host "Web:" $SubWeb.Title " deleted!"
}

DeleteSubSite "Planet"

rm function:/DeleteSubSite

Write-Host "Finished! Press enter key to exit." -ForegroundColor Green
Read-Host

Records management and compliance in SharePoint Server 2013

The records management and compliance features in SharePoint Server 2013 provide improved ways to help you protect your business. The records archive and in-place record retention from earlier versions of SharePoint Server are still supported. SharePoint Server 2013 adds retention policies that are applied at the level of a site.

Site-based retention


Compliance features of SharePoint Server 2013 have been extended to sites. You can create and manage retention policies in SharePoint Server 2013, and the policies will apply to SharePoint sites and any Exchange Server 2013 team mailboxes that are associated with the sites.
Compliance officers create policies, which define the following:
  • The retention policy for the whole site and the team mailbox, if one is associated with the site.
  • What causes a project to be closed.
  • When a project should expire.

Azure Rights Management Connector

The Microsoft Rights Management (RMS) connector lets you quickly enable existing on-premises servers to use their Information Rights Management (IRM) functionality with the cloud-based Microsoft Rights Management services.

Use the following sections to help you plan for, install, and configure the RMS connector. You must then do some post installation configuration so that your servers can use the connector.

Business Connectivity Services in SharePoint 2013

Configure authentication infrastructure in SharePoint 2013

Building blocks Content Description

Configure forms-based authentication for a claims-based web application in SharePoint 2013
Describes the steps to configure forms-based authentication using a Lightweight Directory Access Protocol (LDAP) membership provider.

Configure SAML-based claims authentication with AD FS in SharePoint 2013
Describes the steps to configure Security Assertion Markup Language (SAML)-based claims authentication using Active Directory Federation Services (AD FS) 2.0.

Configure server-to-server authentication in SharePoint 2013
These articles describe the steps to configure server-to-server authentication.

Configure app authentication in SharePoint Server 2013
Describes the steps to configure app authentication for SharePoint Server 2013.

Configure client certificate authentication for SharePoint 2013
Describes how to configure user authentication with client certificates.