December 2006 SQL Server 2005 Samples Web Refresh

Ever wanted to install the SQL Server 2005 samples on Vista? If so, I recommend using the lastest sample installers at https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en which we've recently updated for the December 2006 samples web refresh.  The bits that get installed are identical to the July 2006 web refresh except these installers are supported on Vista.  To run these samples you'll need SQL Server Express SP1 or SQL Server Express with Advanced Services SP1.  Other editions of SQL Server 2005 (Developer, Enterprise) won't be supporting Vista until SP2.  These installers provide full access to the person who is running the installation.  If your admin installed the samples, you should ask them to grant you full access if that is what you need.

There is no point to installing the December 2006 web refresh if you aren't using Vista and you already have the July 2006 web refresh installed. 

We are planning to release some new samples and some bug fixes in a future web refresh which will ship when SQL Server 2005 SP2 ships.  I'll blog about it once those bits are live.

Thanks to everyone who met us or provided feedback on samples at PASS here in Seattle.  It was great to meet some of you in person and get your input.

Comments

• Anonymous
  December 12, 2006
  The comment has been removed
• Anonymous
  December 12, 2006
  Bob,First AdventureWorksDB only installs the AdventureWorks database, not the AdventureWorksDW database.  Use the installer called AdventureWorksBI.msi to get that database.  You should uninstall previous version of the AdventureWorksBI.msi if present, and also you may need to delete that database using SQL Server Management Studio or SQL Server Management Studio Express depending on where the old database is attached.  Note that you should look for sample databases in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData.  The directory Microsoft SQL Server90ToolsSamplesAdventureWorks Analysis Server Project does not contain databases you can attach.  It has the AS project which you can use to deploy to create the Analysis Services database.  I apologize for the out of date link.  You can find current detailed installation instructions and information about the samples at http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/SQLServerDatabasesAndSamplesOverview.htm.--Bonnie [MSFT]
• Anonymous
  December 17, 2006
  The comment has been removed
• Anonymous
  December 28, 2006
  I still have MSDE as well as SQL Server Express 2005 installed on my workstation. I had AdventureWorks2000 installed in the NETSDK instance of MSDE. When I tried to install it (using dthe downloaded msi) to SS EXP 2005 the installer wouldn't allow it. Please provide a procedure to have AdventureWorks installed both in MSDE and in SQL Server Exp 2005. I don't see why there should be any conflict or why I have had all this aggravation. Thanks - LG
• Anonymous
  January 02, 2007
  LGWIZ,The SQL Server 2000 version of the AdventureWorks database is not supported on SQL Server Express 2005.  Please use the AdventureWorksDB.msi installer at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en for SQL Server Server Express 2005.--Bonnie [MSFT]
• Anonymous
  January 06, 2007
  I started out w/ SQL Express and installed that version's Adventureworks samples.  Finding that I really should have the developer edition, I deinstalled SQL Express and installed SQL Server 2005 Developer edition.  Now I find that I cannot deinstall the SQL Express samples and install the full version samples.  Suggestions?
• Anonymous
  January 08, 2007
  wer,What error message did you get when you tried to uninstall the Adventureworks samples? And is it the sample database or the sample code?--Bonnie [MSFT]