locked
Trouble installing Business Intelligence Developement Studio. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have Visual Stuido 2010 installed on my machine and I installed SQL Server 2008 Developer Ed. Now, it appears that the BIDS did not install with SQL Server. When I try to run install again to try to add it, it does not show up as an option. Do I need to uninstall both of them and start over? Also, I saw a note saying that BIDS does not work with VS 2010. So, does that mean that I have to run SQL Server installation first?
    Friday, February 11, 2011 9:09 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    The workaround is given in Books Online:

    “Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects for SQL Server 2008 and SQL Server 2008 R2. To work around this issue, you can install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.”

     http://msdn.microsoft.com/en-us/library/ms173767.aspx

     http://social.msdn.microsoft.com/Forums/en/vssetup/thread/d6372b71-c4c0-4ed6-b110-2f1a8279a1cb

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by WeiLin Qiao Wednesday, February 16, 2011 1:51 AM
    • Marked as answer by WeiLin Qiao Monday, February 21, 2011 12:51 PM
    Friday, February 11, 2011 9:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
     

    Hi ArchmageZylon,

     

    Just as Alberto mentioned, the Business Intelligence Development Studio(BIDS) for SQL Server 2008/2008 R2 just uses Visual Studio 2008 Shell, so we could not create the BIDS projects in Visual Studio 2010.

     

    Actually, if we select this feature Business Intelligence Developer Studio while installing SQL Server 2008, the Visual Studio 2008 shell is installed as well, then we could create BIDS projects by using BIDS directly.

     

    To open the Business Intelligence Development Studio, please follow one of the below methods:
     

    • Start -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Business Intelligence Development Studio
    • Start -> All Programs -> Microsoft Visual Studio 2008 ->  Microsoft Visual Studio 2008

     

    If there are any progress, please feel free to let me know.

     

    Thanks,

    Weilin Qiao

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Alberto MorilloMVP Wednesday, February 16, 2011 11:13 AM
    • Marked as answer by WeiLin Qiao Monday, February 21, 2011 12:51 PM
    Wednesday, February 16, 2011 5:57 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    The workaround is given in Books Online:

    “Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects for SQL Server 2008 and SQL Server 2008 R2. To work around this issue, you can install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.”

     http://msdn.microsoft.com/en-us/library/ms173767.aspx

     http://social.msdn.microsoft.com/Forums/en/vssetup/thread/d6372b71-c4c0-4ed6-b110-2f1a8279a1cb

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by WeiLin Qiao Wednesday, February 16, 2011 1:51 AM
    • Marked as answer by WeiLin Qiao Monday, February 21, 2011 12:51 PM
    Friday, February 11, 2011 9:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
     

    Hi ArchmageZylon,

     

    Just as Alberto mentioned, the Business Intelligence Development Studio(BIDS) for SQL Server 2008/2008 R2 just uses Visual Studio 2008 Shell, so we could not create the BIDS projects in Visual Studio 2010.

     

    Actually, if we select this feature Business Intelligence Developer Studio while installing SQL Server 2008, the Visual Studio 2008 shell is installed as well, then we could create BIDS projects by using BIDS directly.

     

    To open the Business Intelligence Development Studio, please follow one of the below methods:
     

    • Start -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Business Intelligence Development Studio
    • Start -> All Programs -> Microsoft Visual Studio 2008 ->  Microsoft Visual Studio 2008

     

    If there are any progress, please feel free to let me know.

     

    Thanks,

    Weilin Qiao

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Alberto MorilloMVP Wednesday, February 16, 2011 11:13 AM
    • Marked as answer by WeiLin Qiao Monday, February 21, 2011 12:51 PM
    Wednesday, February 16, 2011 5:57 AM