I've just done another installation on SQL2008R2 and it works correctly;
For SQL2008 it uses the "mssql2005" DB gateway, so I'll modify my questions from above;
Which project skeleton are you choosing for your installation?
Does the skeleton/project have the appropriate
DEPLOY-mssql2005_*.sql scripts inside it's install folder? I have verified that each of the "barebones", "chelsea" and "fandango" skeletons in the community release have these files.
Do you get any "Debugging Information" on the installer screen, or just an error message?
Do your log files have any other exception messages or useful information in them?
If it's a custom skeleton export / existing project that you are trying to restore you need to check that the appropriate SQL scripts exist.
If your skeleton or project folder does not have an "install" folder with these files (
DEPLOY-mssql2005_*.sql, plus the
insert-*.sql scripts), then you don't have all the required files to be able to do an installation using the installer. In that case you have two options;
a) Log into the webtop of the working site and generate a Skeleton Export (from the Admin -> Developer Tools menu) which allows you to download the database schema and data (NOTE: Do not run this on a production system, because depending on how large the database is it can be very resource intensive and could affect your site).
b) Get a backup of the database and restore it in your development environment (RECOMMENDED!)
Hope that helps!