How to get Business Intelligence Development Studio?

Question

I need Business Intelligence Development Studio (BIDS) installed on my workstation (Win XP/x86). I don't need the SQL server itself since I will be developing and deploying against another server.

I installed SQL Server 2005 Express Advanced Services with the reporting services component enabled, but this didn't give me BIDS it appears.

Is there any standalone installation for BIDS or do I have to install the full SQL Server 2005 to get BIDS? I'm pretty sure I've read that SSRS is 'free' since it's included in the express edition, but does this not include the development environment?

Solution 1

You can install SQL Server 2005 with client tools without installing the database engine, or other SQL Server services. Do you have access to a enterprise/standard/development dvd/cd of sql server 2005?

If not the free/express version of BIDS is available for download from Microsoft. I do not know if it has a full feature set compared to the full version, anyone care to comment?

Solution 2

When you install SQL Server 2005, it can flake out and not install BIDS if you're not careful. You need to make sure the part 'Workstation components' (IIRC) is selected for installation.

Comments

[SomeGuy]

Note that this version has big limitations as it "provides the ability to create and edit Reporting Services projects that are reporting on LOCAL relational data in local SQL Server EXPRESS databases.