Installing Visual Studio for SQL Reporting Services Development

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

Running the main SQL Server 2008 Installation to install the Visual Studio extension for working with SRS Reports

Running the main SQL Server 2008 Installation to install the Visual Studio extension for working with SRS Reports

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.

Selecting the Business Intelligence Development Studio component to install from the various SQL Server 2008 components

Selecting the Business Intelligence Development Studio component to install from the various SQL Server 2008 components

With this feature selected, the Business Intelligence Development Studio will be exclusively installed onto the workstation or laptop involved.

Finished installation for the Business Intelligence Development Studio component

Finished installation for the Business Intelligence Development Studio component

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.

Completed Business Intelligence Development Studio Installation on the Windows Start Bar

Completed Business Intelligence Development Studio Installation on the Windows Start Bar

This will result in allowing the creation of new Reporting Projects for developing new SRS Reports for inclusion to a MSCRM Solution.

New SRS Reporting Project via Business Intelligence addition to Visual Studio

New SRS Reporting Project via Business Intelligence addition to Visual Studio

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.

Advertisements
This entry was posted in Installation and Setup, SQL Reporting Services. Bookmark the permalink.

2 Responses to Installing Visual Studio for SQL Reporting Services Development

  1. Sal says:

    I’m really inspired with your writing skills and also with the format to your weblog. Is that this a paid subject or did you customize it your self? Anyway stay up the nice quality writing, it’s uncommon to peer a great blog like this one nowadays.
    .

  2. Corey Tollerud says:

    Beautiful! saved me a major headache. Thanks for picking up Microsoft’s documentation slack!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s