SQL Server 2005
Browse to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txt
SQL Server 2008
Browse to C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt
Search the file using keywords "error" and "failed" to find the nature of any installation problems.