Or Business Intelligence Development Studio to give the full name – I come across a bit of confusion around this as clients and some consultants tend to group this in with Visual Studio whereas Microsoft think of this as a SQL Server Component. This can lead to some confusion around how to setup a MSCRM Development Workstation to create or edit SRS Reports, and which is the correct component to install for open or creating SRS Reporting Projects. Particularly as the Business Intelligence Studio extension for Visual Studio is not available for general download and so is a google/bing search away to download or install.
The key here is that the required install for Visual Studio is driven from the main SQL Server 2008 or 2005 CD by running the main SQL Setup package – this can be run independently of Visual Studio (to install a version of Visual Studio that can only edit SRS Reports or Projects), or be installed as a snap-in extension to an existing installation of Visual Studio.
Running the Setup package from the main SQL Server CD will start the general SQL Server installation routine (which can be off-putting when just aiming to install the Business Intelligence Component!) which then allows us to start the choose the main ‘Stand-alone Server’ installation option from the Installation menu
This runs through the SQL Server checks and pre-requisities and installs the required pre-install components (which again gives fear that we may end up installing SQL Server on our Workstation, but fortunately this will not happen) but then gives us the option to choose which SQL Components or Features to install – and then from here we install just the Business Intelligence Development Studio and not the SQL Server Components.
With this feature selected, the Business Intelligence Development Studio will be exclusively installed onto the workstation or laptop involved.
This component will then appear twice in the main windows Start Menu – once under ‘Microsoft SQL Server 2008’ as a separate application for SQL Server Business Intelligence Development Studio, and also under the standard ‘Microsoft Visual Studio 2008’ as installing the studio will automatically have added the additional Business Intelligence Projects option to Visual Studio.
This will result in allowing the creation of new Reporting Projects for developing new SRS Reports for inclusion to a MSCRM Solution.
With this in place, we now have an additional Workstation or Laptop ready to develop or edit SRS Reports outside of the SQL Server itself.