Installing SQL Server 2005 Business Intelligence Development Studio on Windows 7

Posted on 2011-05-06
Last Modified: 2013-11-05
Does anyone know the proper way to install this application on a Window 7 machine.  There are so many technotes.  I have tried a bunch but to no avail, I know you need to install sp3 but I need to install the sql management studio first and it won't let me.  I did it once and it was a total pain, just wanted to do some leg work first.

Thanks in advance!
Question by:mwebb_sdmc
    LVL 21

    Expert Comment

    by:Alpesh Patel
    If you install a Full version of SQL Server, it comes with package. Just select the BIDS, SSIS, SSRS, SSAS.
    LVL 16

    Expert Comment

    Well, all you will have to do is install sql server and all the rest are included in the package.. such as SSIS, SSRS and SSAS

    you wil have to Rt click on the exe file and then run it as Administrator..

    Let me know the exact problem..will try to help you
    LVL 12

    Accepted Solution

    With Windows 7, you can only install SQL 2005 or 2008 tools so you wull have to install SQL 2005 or 2008 tools and customise your installation to include Business Intelligence Development Studio.

    Please note that you do not have to make a full installation (if you do not need it) because this will install a database server which you might not need on your machine.

    I'm trying to focus on getting you to have Business Intelligence Development studio on your Windows 7 host.

    Before SQL 2005, (i.e with SQL 2000), being able to do Business intelligence development meant installing SQL 2000 reporting services. One had to install SQL server 2000, Visual studio dot net as prerequisites, then install SQL 2000 reporting services separately which would then include Biz intelligence dev studio. This is not the case any more.

    Follow the guide and you will have it please, thanks.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now