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:
Add BIDS To Existing Installation
Tried numerous times to augment my v2005 installation with BIDs.
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.
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.
Considered other options…
SQL Server Data Tools (SSDT) – BI
Unfortunately, SQL Server 2005 does not seem to be supported by any of the available versions of SSDT-BI.
Microsoft® SQL Server – Express Edition
Did not check whether one can target v2005 engine…Just wanted to include for completeness.
SQL Server Express Edition Toolkit
We can see that it appears that “Microsoft SQL Server 2005 Express Edition Toolkit” supports SQL Server v2005.
Downloaded v2005 Express Edition Toolkit from here.
Successfully installed the software.
Able to successfully create Reports.
- Developer Network – SQL Server Tools Download SQL Server Data Tools \ Download SQL Server Data Tools (SSDT)
- Developer Network – SQL Server Tools Download SQL Server Data Tools \ Previous releases of SQL Server Data Tools (SSDT and
- PMAN’s LAB