Installing SQL Server 2005 on Vista...

I am having the absolute worst luck installing SQL 2005 developers edition on my windows vista laptop. In class we have been using SQL 2000, but I bought a new laptop that has vista home premium preloaded so I need to use 2005 (says the solution analyzer). I have loaded all the IIS services and tried to install the first CD (it never asks for the 2nd one. During the system configuration check i get an "edition change check" waring and a "IIS feature requirement" warning. Once the install completes I cant find the query analyzer or any other SQL applications, just the configuration tools folder. I have tried running the latest service pack with no luck. I have visual studio loaded 2005 loaded as well and didnt have any issues with that, could anyone help me out?

Thanks in advance!

1. IIS warning message indicates that IIS is still configured correctly. Please double check whether you do check "IIS Backward Compatibility", which is required. In addition, IIS is required only if you want to install Reporting Sevices (RS). If RS will not be installed. You can ignore this information.

2. "Edition change check" message indicates that you have SQL Server 2005 products installed with version higher than SQL Server 2005 RTM. For example, you have installed SQL Server 2005 Express SP1. Please go to Control Panel --> Programs and Features, check whether "Microsoft SQLServer 2005" exists. Click on "Change" followed by "Report". You can see all of the SQL Server 2005 components has been installed on your machine.

3. If the second CD is not used, it means that you do not select Client components during setup. Or it is already installed in SQL Server 2005 Express SP1 (or SP2).

|||Where is the check for "IIS Backward Compatibility"?|||

In Vista,

1. Control Panel

2. Program Features

3. Turn Windows features on or off

4. Expand Internet Information Services

5. Expand Web Management Tools

6. Watch whether IIS 6 Management Compatibility is selected.

|||

I had the exact same problems you are having.

Take a look at this thread:

http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/632c78cc040085b1/9bb4823b76a07ebf?lnk=st&q=vista+sql+server+2005+install+problems&rnum=1&hl=en#9bb4823b76a07ebf

|||I have Windows Vista Home Premium installed. IIS with all its feature/components are installed on the system.

When I run the setup of SQL server 2005 standard or enterprise edition, I get the warning message that IIS7 is not installed. If I proceed, I don't get the option to install any server components.

I have crossed checked all IIS features are installed and I am able to open http://localhost also.

Does anybody know whats the problem?|||

I have not yet got SQL Server to install without the warning about IIS. IIS 7 does not have the same signature nor does it have the same version number.

Without knowing what the Setup routine checks for, you will not be able to force the requirement as Success without a lot of playing around it. Normally on a Client OS the version will most likely not show up correctly. Like Windows 2000 and Windows XP. 2000 had 5.0 IIS and XP had 5.1.

Ben Miller