Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

3 Answers 3

up vote 3 down vote accepted

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?

share|improve this answer
1  
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. –  SomeGuy Jun 8 '12 at 14:14

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.

share|improve this answer

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?

No, this does not have the full feature set compared to the full version. I'm not sure about the differences on the Reporting Services side, but the ability to use it with Analysis Services is unavailable in the free/express version.

-rp

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.