locked
Installing Microsoft SQL Server 2008 AdventureWorks Database in SQL Server 2008 Express:There is a problem with windows installer package...... RRS feed

  • Question

  • a script required for this install to complete could not run.
    Any assistance would be greatly appreciated.

    Running with Vista and Visual Studio 2008.
    • Edited by CoolerKing Friday, May 15, 2009 9:27 AM
    Friday, May 15, 2009 9:26 AM

All replies

  • Which package did you download and tried to install ?

    -jens
    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Friday, May 15, 2009 9:28 AM
  • http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?

    From this site;

    http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407

    Apologies just realised that these links may not have given much of a clue.

    From the download page i went for
    SQL2008.AdventureWorks_All_Databases.x86.msi

    Can anybody advise as to what the error is and any solutions available.

    Friday, May 15, 2009 9:34 AM
  • Hi CoolerKing,

    This error is almost always associated with an installer package that has been corrupted during download, usually caused by a network issue. Downloading the package anew usually solves the problem, but in some cases the download manager tries to "help" by picking up a partial download from your temp directory and restarting from the middle, which can result in corruption on every download attemt. I typically recommend that you clear your Temp folder before trying the to download the package again. But before you do, let's get to your second question (you haven't asked it yet, but you will)...

    The AdventureWorks database requires that Fulltext Search be enabled in SQL Server in order to be attached and Fulltext Search is not included in the core SQL Express package and therefore attach will fail. You have two options:

    1. Upgrade to SQL Express with Advanced Services, which does include Fulltest Search.
    2. Install AdventureWorks2008LT, which is a smaller, simpler database with a streamlined schema.

    If you want to use AdventureWorks2008LT you'll want to download the ZIP file version which just has the mdf/ldf files that you can copy into your .\DATA directory and attach. You won't be able to install AdventureWorks2008LT from the main "all databases" package because it populates its data from AdventureWorks208, which as I've indicated, won't attach. (This is why the ZIP version of the LT database exists.)

    If you actually need the full AdventureWorks2008 (eg. You're working through examples that use this database as the sample data) then you'll need to install Express Advanced. Check out the FAQ at the top of this forum to get information on how to upgrade between different editions of SQL Server 2008, there are some steps that are required that you'll miss if you don't know about them in advance.

    Regards,
    Mike


    If this post answers your question, please mark it as an Answer - it will help others searching the forum. This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, May 15, 2009 9:51 PM
  • Hi CoolerKing,

    do you have additional questions or was your problem solved ? If yes, please don´t forget to mark the answer to help other people finding the solution at the top of the list :-)

    -Jens
    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Monday, May 25, 2009 6:35 AM