Monthly Archives - February 2012

How to change SharePoint authentication from classic mode to claims based authentication

In this post i am going to explain how we can change authentication of web application from classic mode to claims based authentication. Step 1: Check current authentication of Web application Open SP 2010 central administration and go to web application management, select web application whose authentication you want to change. Click on authentication providers from bread crumb and check what current authentication type is. In my case it is showing me Windows.
SharePoint 2010 Authentication Provider
Authentication Provider

How to Import Export a SharePoint Subsites

I found three useful methods, which you can use to import or export SharePoint Subsites.

Method 1: Import/Export  SharePoint Subiste by using STSADM

The STSADM tool commands :

  1. Import Command: STSADM -0 Import
  2. Export Command: STSADM -o Export.
  3. Backup Entire Site Collections : STSADM -o Backup
  4. Restore Entire Collection: STSADM -o Restore

How to Create Multiple Cascade drop downs using InfoPath 2010

Create Multiple Cascading Drop-down Lists in InfoPath: Scenario is to create an AV Asset form, which will be containing following information.
infopath 2010 form
InfoPath 2010 AV Assest Form
In this AV form Equipment Type, Manufacturer and Model number are interdepending lists. If user picks up equipment type from equipment combo box, list of manufacturer combo box should only show manufacturer which are only related to this equipment type. (more…)

How to create External Content Type Based on a SQL Server 2008

External Content Types using SQL Server Authentication Business Connectivity Services (BCS) is new in SharePoint 2010, which is used to be called Business Data Catalog (BDC) in SharePoint 2007. You can create External Content Type (ECT) with BCS that let you define a connection to a web service or database server that is external to SharePoint. How to create External Content Type Based on a SQL Server 2008 Table: I am going to show steps for a scenario where we will use single SQL account to impersonate when we access the external data from SharePoint. Things to note before to implement scenario:
  • Which SQL Server account needs to use for impersonation?
  • Which group of users need to give access to the data? In my scenario I am going to use domain users group which is everyone.  I will restrict use access at site level, if anybody will have access to SharePoint site they will have automatically access to external SharePoint list, which will be connected to SQL Server table (more…)