Home > Uncategorized > Fixing “The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly”

Fixing “The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly”

January 10, 2012 Leave a comment Go to comments

Visual Studio 2010 and SQL Server Express have an uneasy alliance, at best.  When you install Visual Studio 2010 it installs SQL Server Express 2008 for you, but only the database engine, not SQL Server Management Studio.  If you mess with SQL Server Express in order to install the management tools, or upgrade to 2008 R2, or install the Advanced Services version, things break and you can no longer reliably use the Visual Studio database projects.

In particular, if you remove SQL Server Express 2008 and install SQL Server Express 2008 R2, you’ll probably run into an issue where if you try to open a schema object in a Visual Studio database project you’ll get an error that says:

The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly.

The fix for this problem can be found here.  Here’s the short version:

  1. Locate your Visual Studio 2010 installation media.
  2. In the \WCU\DAC folder, you’ll find three MSIs: DACFramework_enu.msi, DACProjectSystemSetup_enu.msi, and TSqlLanguageService_enu.msi.  Run and install each of them.
  3. Reapply Visual Studio 2010 SP1.

You should be back to a working state.

About these ads
Categories: Uncategorized
  1. kkkk
    March 26, 2012 at 8:32 pm | #1

    Thanks. It;s Work, Fix My VS2010 Problem

  2. WoofPuppy
    May 31, 2012 at 9:29 am | #2

    Worked for me too!

  3. Lin-art
    June 5, 2012 at 12:18 am | #3

    For Sql 2012 + VS 2010 use the new release of the SQL Server Data Tools for VS2010 http://msdn.microsoft.com/en-us/data/hh297027

    • Jonathan
      July 17, 2013 at 1:28 pm | #4

      Thanks for the tip, it worked for me!

  4. Jesper
    October 1, 2012 at 7:05 pm | #5

    Yes, it worked.

  5. amclint
    October 3, 2012 at 11:28 am | #6

    Thanks for posting this up.

  6. Marius Els
    October 10, 2012 at 5:59 am | #7

    Thanks, I can also verify that the solution works

  7. October 12, 2012 at 11:50 am | #8

    Thanks, this solution works. This was driving me crazy.

  8. shimon
    October 24, 2012 at 4:41 pm | #9

    Lin-art :
    For Sql 2012 + VS 2010 use the new release of the SQL Server Data Tools for VS2010 http://msdn.microsoft.com/en-us/data/hh297027

    good!

  9. shimon
    October 24, 2012 at 4:58 pm | #10

    also visual studio command prompt – rightclick run as administrator
    run:
    devenv.exe /resetskippkgs
    should solve the messages

  10. shimon
    October 25, 2012 at 5:33 am | #11

    oops that didn’t worked
    what worked was

    installing (don’t uninstall them when before you install SQLSERVER 2012)

    Microsoft SQL Server 2008 R2 Data-Tier Application Framework with this command:
    \WCU\DAC\DACFramework_enu.msi

    Microsoft SQL Server 2008 R2 Data-Tier Application Project:
    \WCU\DAC\DACProjectSystemSetup_enu.msi

    Microsoft SQL Server 2008 R2 Transact-SQL Language Service:
    \WCU\DAC\TSqlLanguageService_enu.msi

    if you make a layout as described below it contains the msi files mentioned above

    the above solved just f# message

    also after repairing Visual Studio 2010 had to Reapply Visual Studio 2010 SP1.
    download
    http://www.microsoft.com/en-us/download/details.aspx?id=23691
    run:
    VS10sp1-KB983509.exe /createlayout “%TEMP%\VS2010SP1″
    then run setup

    if i just ran without making a layout I had many msi files ware missing

    all this happend because i have removed sql server 2008 and tried to install sql server 2012
    but it failed it said need visual studio setup
    then i repaired the visual studio so it became missing sp1
    then i with a repaired visual studio i could install sql server 2012
    so then i got errors in visual studio and so i got these packages installed and seems like it worked out finally

  11. Carlos Faddul
    November 23, 2012 at 10:47 am | #12

    It worked perfectly.Thank you

  12. November 25, 2012 at 7:20 pm | #13

    Yep, it worked perfectly.

  13. December 13, 2012 at 9:50 am | #14

    Hey Eric – Just a note to say thanks.

    This not only fixed the packages not loading exceptions, it also fixed another problem, in which the .NET Runtime Optimization Engine was running nonstop and eating up all my CPU time.

  14. An T Nguyen
    December 19, 2012 at 8:06 pm | #15

    Thank you very much, youve saved my life <3

  15. January 15, 2013 at 6:10 am | #16

    It worked perfectly for me… Unfortunately, I am facing a different issue now. Errors List, Task List windows are getting displayed under View Menu. Any idea, how to fix this ?

  16. January 15, 2013 at 11:25 am | #17

    @Swaminathan, I think the menu items for displaying the Errors list and Task list windows is located on the View top-level menu by default, so I don’t think there’s anything wrong there. At least it’s that way for me on VS 2012. You can move stuff around with Tools | Customize | Command tab.

    Or maybe I didn’t understand your question?

    • January 16, 2013 at 1:53 am | #18

      Oops.. that was a big typo there.. I meant to say they are NOT getting displayed under View Menu..However, I just tried doing a devenv /resetsettings today and I have got them back now.. :-)

  17. zu
    January 24, 2013 at 5:00 pm | #19

    It doesn’t work for me, because DACProjectSystemSetup_enu.msi doesn’t install, it keeps asking for source, even though the file is there… the other two install with no problems… I don’t get it. What can I do to install DACProjectSystemSetup_enu.msi?

  18. Ákos Pfeff
    January 25, 2013 at 2:50 am | #20

    Worked, thanks!

  19. vivek
    April 9, 2013 at 6:24 am | #21

    thanks this is very helpfull for me

  20. Vinsens
    May 2, 2013 at 7:57 pm | #22

    wow.. It’s work :D

  21. May 8, 2013 at 12:54 pm | #23

    Great! I spent a couple of hours, stuck with this issue. Reinstalled SQL Server…
    Thank you. That works.

  22. Mark
    June 27, 2013 at 7:11 pm | #24

    Champ ! Cheers

  23. VG
    August 1, 2013 at 8:38 am | #25

    Works ! After many hours of unsuccessful attempts trying other things the steps on this page work.

  24. Esk
    January 11, 2014 at 10:21 pm | #26

    Thank you,now it’s works.

  1. April 17, 2012 at 11:33 am | #1
  2. December 25, 2012 at 11:00 am | #2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: