CODEWITHSUNDEEP
sql-serversql-server-2008business-intelligence
RG-3
RG-3

Reputation: 6188

Can I integrate BIDS with SQL Server 2008 R2?

I installed SQL Server 2008 R2. Now I want to install BIDS in this SQL Server. Can I install it from this link:

http://www.microsoft.com/downloads/en/details.aspx?familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

Is this going to work? Thank you!

Upvotes: 1

Views: 6241

Answers (2)

adolf garlic
adolf garlic

Reputation: 3096

BIDS is part of the SQL Server Client Tools which will be visible as one of the options when you try and install SQL Server. There is no real need to install it on the server as you can connect remotely.

You can see it here under 'shared features'. Just select that and untick all the other options when running it on the machine on which you wish to install it.

Upvotes: 3

bobs
bobs

Reputation: 22224

BIDS is not installed on the SQL Server. It is a development environment that uses Visual Studio. You can install BIDS from your SQL Server 2008R2 installation media, but you can also get the express 2005 version from your link. You should be able to connect to your SQL Server using either approach.

Upvotes: 0

Related Questions