Can SQL server 2012 BI data tools co-exist with SQL server 2008 BI studio?

  • After I install SQL server 2012 client tools on my computer that has SQL server 2008 client tools installed, the 2008 business management studio (BIDs 2008) no longer works.

    I got an error when adding a new SSIS package:

    TITLE: Microsoft Visual Studio

    An error prevented the view from loading.------------------------------

    ADDITIONAL INFORMATION:

    The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)

    So does that mean SQL server 2012 BI data tools cannot co-exist with SQL server 2008 BIDs?

    For we have some projects in 2008 some in 2012, it is good to have both to work on my computer?

    Thanks,

  • You may have to just repair the older version. They are supported on the same machine as I have 2005 up to 2012 SSMS and BI tools.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • Thank you, I do repair the BI using installation media for SQL server 2008.

    But it is still not working after repair. same error message when I add a new package to the SSIS project.

    The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)

    Any more suggestions?

    Thanks much

  • You might check to make sure if the tools are patched for both SQL Server and Visual Studio. Only other option after that would be to remove them and reinstall it.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • I copied 5 dll files from another 2008 instance in the C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8 folder to my computer.

    Then SSIS BI 2008 works, and I also tested data tools of 2012, it works too.

    So hopefully this replacement of files will not affect future use of BI 2012.

  • That's weird but then again Visual Studio co-installs often have all kinds of stupid issues.

    For the record I did have 2008 BIDS and SSDT 2012/BI installed on the same machine. Last year though I upgraded all my Reporting Services stuff to BIDS 2012. A few days ago I "upgraded" to a fresh VM with only SQL 2014 on it and VS 2013. SSDT-BI 2013 is such a broken embarrassment for Reporting Services work that it beggars belief.

    Preview a report? Okay we're going to pop up a console window (report processing preview host). And one will open for every single project you view in. And if you close it... VS 2013 preview ability dies until you close and restart it. There's a Microsoft Connect item that started a few months ago with 20+ votes now and no word from Microsoft at all. Idiots.

    In that way you're very fortunate to be stuck in BIDS.

  • Thanks for the information.

    Yes, I agree install different versions of Visual studio could cause all kinds of issues. esp, after unintall and then reinstall.

    Hope microsoft make all these simple to manage.

Viewing 7 posts - 1 through 6 (of 6 total)

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