SQL Server – v2005 – Report Creation Tools

Background

I am trying to create Custom Reports to be ran against a SQL Server v2005 Instance.

Unfortunately, having problems accessing my Business Intelligence Development (BIDS) .

Here is what the Start Screen looks like:

startup-v2005

 

Add BIDS To Existing Installation

Tried numerous times to augment my v2005 installation with BIDs.

GUI

yourupgradeisblocked

Textual

Name: Microsoft SQL Server 2005 Tools (64-bit)
Reason: Your upgrade is blocked. For more information about upgrade support, see the “Version and Edition Upgrades” and “Hardware and Software Requirements” topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Other Options

Considered other options…

SQL Server Data Tools (SSDT) – BI

SSDT-BI Version SQL Server Engine Version Supported Link
SSDT-BI for Visual Studio 2015 SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 and 2008 R2 Link
SSDT-BI for Visual Studio 2013 SQL Server 2014, SQL Server 2012, SQL Server 2008 and 2008 R2 Link
SSDT-BI for Visual Studio 2012 SQL Server 2014, SQL Server 2012, SQL Server 2008 and 2008 R2 Link

 

 

Unfortunately, SQL Server 2005 does not seem to be supported by any of the available versions of SSDT-BI.

 

Microsoft® SQL Server – Express Edition

Version SQL Server Engine Version Supported Link
Microsoft® SQL Server® 2008 R2 SP2 – Express Edition v2008, v2008/R2 Link

 

 

 

Did not check whether one can target v2005 engine…Just wanted to include for completeness.

 

SQL Server Express Edition Toolkit

Version SQL Server Engine Version Supported Link
v2005 v2005 Link

 

We can see that it appears that “Microsoft SQL Server 2005 Express Edition Toolkit” supports SQL Server v2005.

 

Downloaded

Downloaded v2005 Express Edition Toolkit from here.

Installation

Feature Selection

featureselection

 

Successfully installed the software.

Experience

Able to successfully create Reports.

References

Microsoft

  1. Developer Network – SQL Server Tools Download SQL Server Data Tools \ Download SQL Server Data Tools (SSDT)
    Link
  2. Developer Network – SQL Server Tools Download SQL Server Data Tools \ Previous releases of SQL Server Data Tools (SSDT and
    Link

 

Blogs

  1. PMAN’s LAB
    Link

Leave a Reply

Please log in using one of these methods to post your comment:

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