BIDS DOWNLOAD

Question

BIDS DOWNLOAD

VastSQL

SSC-Dedicated

Points: 36144
More actions
May 6, 2010 at 7:27 am

#218644

Hi Experts,
In one of our machine we have installed standard edition of SQL Server 2008 and now we need to install BIDS on that.
Where can we download the setup for that????

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Install it off the SQL Server DVD. It is included in Standard edition (but not workgroup, web or express).

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 2

Thanks Gail,

The server is in remote location and we dont have CD for the setup.

Can we download it from any site??

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You could download the entire of SQL Evaluation version, it'll probably be in there. It's not a separate download afaik.

Why are you installing BIDs on a server in the first place? It's a client tool, not something that you need or should have on a server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 4

This is the closest I've seen.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&displaylang=en

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 5

GilaMonster (5/6/2010)
You could download the entire of SQL Evaluation version, it'll probably be in there. It's not a separate download afaik.
Why are you installing BIDs on a server in the first place? It's a client tool, not something that you need or should have on a server.

We have serer installed on that remote machine and now we are asked to install BIDS??

Thanks everyone

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Ratheesh.K.Nair (5/6/2010)
GilaMonster (5/6/2010)
You could download the entire of SQL Evaluation version, it'll probably be in there. It's not a separate download afaik.
Why are you installing BIDs on a server in the first place? It's a client tool, not something that you need or should have on a server.
We have serer installed on that remote machine and now we are asked to install BIDS??

Did you ask why? There's no reason for that to be on a server, BIDs should be installed on client machines so that people can develop SSIS, SSAS and SSRS. It's not needed on a server unless people expect to remote in and work directly on the server itself.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 7

Thanks Gail,

That server is dedicated for SSIS but they forgot to install BIDS 😛

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Again, it doesn't need to be installed on the server.

If they (or you) insist, you need to find the SQL installation DVD and install from there. The link that Steve gave is only SSRS (check the details of what's included)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 9

GilaMonster (5/7/2010)

Again, it doesn't need to be installed on the server.

Then how can i create a new integration service package there in that server??

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

Ratheesh.K.Nair (5/7/2010)
Then how can i create a new integration service package there in that server??

Development work should be done on development workstations, ie desktops, not on the server directly. You don't need BIDs to run SSIS, just to design and develop.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass