In this walkthrough we will learn How to install Business Intelligence Development Studio (BIDS) on Visual Studio 2012 and Sql Server 2008
The Business Intelligence Development Studio (BIDS) is an add-on to Visual Studio 2012 and Sql Server 2008. The BIDS includes the SSIS - Sql Server Integration Services templates for developing SSIS projects on Visual Studio 2012. Here we'll see step by step how to install it :
How to install Business Intelligence Development Studio (BIDS) on Visual Studio 2012 Sql Server 2008
Download it to your machine and run it as administrator:
Click the "Install" button :
Make sure that the Business Intelligence for Visual Studio 2012 box is checked :
Click "Next" :
Check that the installation has been successful :
Now let's see how it has the Visual Studio 2012 upgraded. Before the installation, Visual Studio 2012 templates for new projects looked like this :
Now, after the installation, the Visual Studio 2012 templates include the ones for Business Intelligence , SSIS between them:
Now you can create a new SSIS - Sql Server Integration Services project using the Business Intelligence Development Studio (BIDS) on Visual Studio 2012 and Sql Server 2008 :
In this walk-through we've learned how to install the Business Intelligence Development Studio (BIDS) on Visual Studio 2012 and Sql Server 2008 .
In this walkthrough we will learn how to take care of the "Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies" error in a Dynamics CRM 2013 (2011) related .Net application .
The "Could not load file or assembly Microsoft.IdentityModel" exception
Dynamics CRM 2011 - 2013 uses the Windows Identity Foundation in order to contact the Organization Web Service.
The "Could not load file or assembly 'Microsoft.IdentityModel" Exception's message tells us explicitly of the need of reference and loading an "assembly".
However, the error message is misleading, since you wont have to reference certain assembly from your .Net project. Instead, you'll need to install a Windows's update : .
Check that your machine complains with the Microsoft Identity Foundation 's System Requirements.
Check the "Install Instructions" to see which package is appropriate for your machine : And download the one you need (the 64 bit package, for instance):
Locate the downloaded package and open it:
Then follow the install steps until you finish the setup (notice that this is an update for Windows, the update KB974405):
After you finish the installation, you will be tempted to follow the leads from the Exception message , "Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies" , by adding some assembly to your project:
But, where is the assembly?
Remember, this is an update for Windows , and not an assembly: the error message can mislead us ... You don't have to search some assembly, neither close-open your Visual Studio nor restart your machine. Actually, you don't have to do anything: just run again your .Net application, and you'll find that now is working perfectly.
In this walk-through we've review how to fix the "Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies" error in a Dynamics CRM 2013 (2011) related .Net application .
