Saturday, December 29, 2007

SQL Server 2005 on Vista

Latest adventure has been moving my development environment to a new laptop (with more RAM, etc) Installing SQL Server 2005 on Vista was a challenge for some reason..

Using the MSDN-provided SQL Server Developer Edition, ran into the error "The feature(s) specified are not valid for this edition of SQL Server" Which features(s)?

Backed off doing a full install, and instead installed in this order
  1. Workstation components
  2. Database engine
  3. Reporting Services

Reporting services did not configure itself automatically during the install, but not a big deal to do it afterward using the Reporting Services Configuration console in SQL 2005.