Unable to access or login failed for user to connect with Content Database of Sharepoint 2010

I came across an issue while connecting U2UCaml Builder with my site collection using Sharepoint 2010 object model and i got SQL Exception  unable to connect to SQL :database login failed for user to connect with Content Database etc...

I checked for my user rights and  it is in Site Collection  Admin as well as Farm Admin group then i tried accessing the database directly from SQL Management Studio , it says database can't be accessible

so i came to a solution with following power shell commands, i thought to share with all.

1. Open your SharePoint 2010 Management Shell as an Administrator

2. Run the following script

  $app = Get-SPWebApplication -identity “yourwebappname”
  $app.GrantAccessToProcessIdentity(“domain\username”)

Unhandled exception occurred in the silverlight application sharepoint 2010

An unhandled exception occurred on the create page when trying to create new list  in SharePoint 2010 site.

It happens because Silverlight Application trying to connect to the WCF endpoints configured by the product for enabling Client Object Model, which gives error as security validation is set to Off for the Web Application

1. To set it to ON, Go To Central Admin -> Application Management ->Manage Web Applications

2. Select the appropriate web application -> General Settings -> enable the security settings

Get Set Lookup value using javascript in CRM 2011

Get a lookup value

var lookup = new Array();
lookup = Xrm.Page.getAttribute("attributename").getValue();
if (lookup != null) {
    var name = lookup[0].name;
    var id = lookup[0].id;
    var entityType = lookup[0].entityType;
}

Set a lookup value

var lookup = new Array();
lookup[0] = new Object();
lookup[0].id = recorid;
lookup[0].name = recordname;
lookup[0].entityType = entityname;
Xrm.Page.getAttribute("attributename").setValue(lookup

SharePoint 2010 Installation on Windows 7 or Vista

Microsoft has provided the ability to install SharePoint 2010 on windows 7 or Vista for the development purpose.


It requires manually install the prerequisites, and you must modify the config.xml file to get it to work. I recommend you follow the steps outlined at following MSDN link

http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx  

Here is the reason why i stated it only for development environment because


1. Single server install (that is, a basic install)
2. You cannot use real SQL Server.
3. Development-only environment.
4. Everything will be automatically configured using a system account or network service.

Invalid Action: The Selected Action Was Not valid

Problem : Some time we get an error after login to our crm organization which says "Invalid action: the selected action was not valid" as shown below

 

if you review the event log you will find following error description

Error Detail: Current active key (KeyType : CrmWRPCTokenKey) is expired. This can indicate that a key is not being regenerated properly. Current Active Key : CrmKey(Id:e1a5b215-d01e-de11-9d16-0003ffd0167c, ScaleGroupId:00000000-0000-0000-0000-000000000000, KeyType:CrmWRPCTokenKey, Expired:True, ValidOn:09/01/2012 15:16:36, ExpiresOn:10/02/2013 17:12:31, createdBy:NT AUTHORITY\NETWORK SERVICE. Key Setting :

Resolution:

Go to your services by running services.msc and Restarting the Microsoft CRM Asynchronous Processing Service

:)

Migration from CRM 4.0 to Microsoft Dynamics CRM 2011

If you don't have CRM 2011 Environment setup you need to first prepare it which is not the scope of this article. There are so many articles over the internet to Prepare CRM 2011 environment

Prerequisite for CRM 2011

•  Windows Server 2008 R2 64-bits machine
•  SQL Server 2008 / 2008R2 64 bits with SSRS
•  Active Directory

Step 1: Install CRM 2011 if not already installed

Step 2: Get a full backup of your current Organization SQL Server database on Dynamics CRM 4.0

Step 3: Restore the DB backup on the new SQL Server instance used for Dynamics CRM 2011

Step 4: Import organization from deployment manager

Within Deployment Manager, go to Organizations->Import Organization

Select the SQL Server instance and the Organization database to import. This corresponds to the restored DB on the SQL Server 2008/2008R2 instance used for Dynamics CRM 2011

Step 6: identify and Fix JavaScript Customizations

Reference: http://crm2011scriptconvert.codeplex.com

Step 7: identify and Fix Reports Customizations

Step 8 : Migrate Data

There are many techniques to migrate data in CRM some of are mentioned below

Data Migration Techniques
:

1.       Microsoft Dynamics CRM 2011 Import Data Wizard

2.       SQL Server Integration Services

3.       Direct CRM Web Services API Access

4.       SCRIBE

SCRIBE is most efficient technique requires no code and a medium level developer needed for it. 

http://www.scribesoft.com/