Nishant Rana's Weblog

We need to make following changes to get the Bulk Data Export tool for CRM 4.0(http://mscrmbulkdataexport.codeplex.com/workitem/list/basic) to work with CRM 2011.

Change the app.config of the tool

http://mscrmuk.blogspot.com/2011/02/using-crm-40-assemblies-on-crm-2011.html

And add references to the 64 bit version of Microsoft.crm.sdk and Microsoft.crm.sdktypeproxy dlls. (Which we can get from its SDK)

http://www.microsoft.com/downloads/en/confirmation.aspx?familyid=82e632a7-faf9-41e0-8ec1-a2662aae9dfb&displaylang=en

http://www.box.net/shared/z6z1dcby0k

Hope it helps.

Configuring Forms Based Authentication (FBA) for SharePoint 2010

Create a new web application from Central Administration.

Select Authentication as Claims Based Authentication

Check Enable FBA checkbox and specify Membership provider name and role manager name as SqlMembers and SqlRoles.

Click on Ok to create the web application.

After successful creation of the web application create a site collection.

Navigate to C:\Windows\Microsoft.NET\Framework64\v2.0.50727 and run aspnew_regsql.exe tool there.

Follow the screen shots below to create a new database named MYFBADB.

After successful creation of the database add the following information(highlighted in yellow) to the web.config file of our FBA application

Next open the web.config of the Central admin site and add the same information added above

</SharePoint>
    <connectionStrings>
        <add
name=“SqlConn“
connectionString=“server=crm2011;database= MYFBADB;Trusted_Connection=true“ />
    </connectionStrings>
<system.web>

Lastly add the following configuration information in the web.config file of the SecurityTokenServiceApplication (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\SecurityToken)

    </system.net>
    <connectionStrings>
        <add
name=“SqlConn“
connectionString=“server=crm2011;database= MYFBADB;Trusted_Connection=true“ />
    </connectionStrings>    <system.web>
        <membership
defaultProvider=“SqlMembers“>
            <providers>
                <add
connectionStringName=“SqlConn“
applicationName=“/“
name=“SqlMembers“
type=“System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a“ />
            </providers>
        </membership>
        <roleManager
enabled=“true“
defaultProvider=“SqlRoles“>
            <providers>
                <add
connectionStringName=“SqlConn“
applicationName=“/“
name=“SqlRoles“
type=“System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a“/>
            </providers>
        </roleManager>
    </system.web>

That’s it.

Adding User to SharePoint Group through a custom ASP.NET web service.

I had a requirement to create a web service which would be used to add user to a SharePoint group. The code for it

[WebMethod]
public string AddSharePointUser(string username,string password, string email){
string statusInfo = “”;
try{
string SharePointUrl = ConfigurationManager.AppSettings[“SharePointUrl”].ToString();
string SharePointGroup = ConfigurationManager.AppSettings[“SharePointGroup”].ToString();
SPSecurity.RunWithElevatedPrivileges(delegate(){
using (SPSite oSiteCollection = new
SPSite(SharePointUrl)){
oSiteCollection.AllowUnsafeUpdates = true;
using (SPWeb oWebsite = oSiteCollection.OpenWeb()){
oWebsite.AllowUnsafeUpdates = true;
SPUser spUser = oWebsite.EnsureUser(username);
SPGroup spGroup = oWebsite.SiteGroups[SharePointGroup];