Installing SQL2005 SP2 on Vista

We have been having fun installing SQL2005 Developer Edition on Vista PCs with Reporting Services, you need the SP2 for Vista, but installation of  this kept stalling with authentication problems.

Turns out this is the process to follow:

  1. Do a default Install SQL 2005 Dev. Edition
  2. Run the Reporting Service Configuration Tools, make sure that the Reporting Services Process is started.
  3. Make sure the new SQL service has also be started (via control panel)
  4. Run the SP2 package, we were having problems on the login verification page, it said we could not authenticate the Reporting Services login until we had done steps 2 and 3.