Posts

Restore ShrePoint 2010 Site Collection Backup into SharePoint 2013

Can I restore SharePoint 2010 Site Collection backup into SharePoint 2013 environment? No, it won't work that way. You should do a backup and restore in your SP 2010 environment and put the site collection into it's own database. Then do a sql backup and restore of the database into the 2013 farm and content db attach it for it to upgrade correctly

SharePoint Provider Host App

http://blogs.technet.com/b/meamcs/archive/2013/02/24/sharepoint-provider-hosted-app-walkthrough-part-1-preparation.aspx  

Cannot connect to LOB System - BCS Issue

Issue   All of a sudden, when your BCS stopped working and you are getting the below issue, "Cannot connect to LOB system"   Cause of the Issue   BCS files may be referring the wrong connection wrong and you might have changed it in the bcs files. Also BCS files would have been updated in the SharePoint server, but still you are getting the issue.   Resolution Issue is old files are not properly updated and still referring the old connection string. So you need to delete all the BCS files and again need to deploy it in the SharePoint server. This solves the issue.

External List - Fetch data from SQL using SQL Authentication and Secure Store Service

Steps Configuring Secure Store Service 1.        Go to Central Administration à Manage Service Application à Check Secure Store Service Application is running. 2.        If Secure Store Application is not there, create new Secure Store Service 3.        Then click “New” button to create a new target application using the “Group” type 4.        Give the details for – Target Application Id, Display Name, Contact Email and Target Application 5.        Click Next, Choose “User Name” and “Password” from the dropdown options. Also change the name from Windows User Name to “User Name” and Windows Password to “Password” 6.        Give Service account/(account with admin access) name in the screen and give permission for the user to edit the details if required later 7.    ...

Configuring SQL Server authentication for External Content Types

http://www.atlantacodefactory.com/blog/?p=180

Disable duplicate value in search result webpart - SharePoint

Disable duplicate value in search result webpart can be avoided by changing the attribute TrimDuplicates default value. By default it is set as true and hence the similar items will be trimmed. To avoid this, TrimDuplicates value need to be set as false like, 'TrimDuplicates':false

SharePoint - Sorting in Search result webpart

SharePoint 2013 - Search Result Web Part sorting Search result web part sorting is different from content search web part. Here sorting need to be done in AvailableSortsJson attribute and not in FallbackSort attribute AvailableSortsJson="[{'name':'Created (A-Z)','sorts':[{'p':'Created','d':1}]}]