BIDS and SQL Server 2008 Reporting Services install

0
votes

We would like to start using SQL Server 2008 R2 Reporting Services in our company, but we are using SQL Server 2008 Enterprise Database Engine on a standalone server and have Visual Studio 2010 Ultimate on our programming PCs.

From what I understand, we need Visual Studio 2008 for BIDS to install. Is it necessary that the SQL Server 2008 Database Engine AND Visual Studio 2008 be on THE SAME machine to install BIDS?

Can I use any of the Visual Studio 2008 Express versions?

2
visual-studio-2010sql-server-2008visual-studio-2008reporting-servicesbids
no its not like that the vs2010 and mssql2008 should be on same machine – Rashmi Kant Shrivastwa
paste your problem here what exactly you want – Rashmi Kant Shrivastwa
According to this and this it's not compatible. I've been told that I need Visual Studio 2008 for this. I have tried to install the Express version but still don't see BIDS. – Rick

2 Answers

1
votes

Just to clarify, you don't need to install any version of Visual Studio 2008 before installing BIDS.

When you install the SQL Server 2008 R2 client tools on your PC, this will include a version of Visual Studio 2008 with the business intelligence components installed.

From memory the requirement for Visual Studio 2008 is due to an incompatibility between Visual Studio 2010 and the Integration Services project type.

0
votes

Yes, you can use Express Visual Studio

No, you don't need to install the DB engine. When you run the install, BIDS is listed under "client components" (or similar). The SQL Server install routine will install VS Express for you too.