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?
Best Answer
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?