SQL Server Express 2005 Business Intelligence Development Studio

Posted on 2006-04-27
Last Modified: 2010-05-18
Hi experts,

I am upgrading my MSDE 2000 to SQL Server Express 2005. I installed the Advanced Edition and Toolkit. I think I should be able to create reports using Business Intelligence Development Studio, but I can't find Business Intelligence Development Studio menu. There is a Microsoft Visual Studio 2005 menu instead, but with which I can't create reports. Because there is no report project option available.

I noticed I got an warning message during the setup while installing the last item "Workstation component, Books online and development Tools", which said "Warning 28123. Warning: SQL Server cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online".
Could somebody help me out?
Question by:snow_moon
    LVL 3

    Author Comment

    I finally get the Business Intelligence Development Studio up and running. I don't know why exactly. I just uninstalled SQL Express and cleaned the registry entries of all versions of SQL Server. Then it worked.
    LVL 28

    Expert Comment

    >For more information, see 'Version and Edition Upgrades'
    you should uninstall every thing related to sql server 2005 CTP version or 2005 any other edition before you do installation for sql express edition.

    Accepted Solution

    PAQed with points refunded (250)

    Community Support Moderator

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now