SQL 2005 Cannot INSTALL : IIS NOT FOUND ???

  • Thread starter Martin \(Martin Lee\)
  • Start date
M

Martin \(Martin Lee\)

I am using Window Vista (Home Premium)

And I want to install SQL SERVER 2005 (Enterprise Edition) in my computer.

During the SQL installation, it told me that my computer have not yet
install IIS.

However, I know I have activated the IIS ( because I can open "localhost" in
IE )



My question is:

Why SQL Server installation tell me I had not installed IIS ? How to solve
this problem?

Is that because SQL Enterprise Edition doesn't fit for window Vista Home
Premium? If so, which SQL version I should use?

Thank you!

Martin
 
S

Steve Drake

Its looking for IIS6 you have IIS7.

You need to install the backwards comp bits of IIS

see

http://support.microsoft.com/kb/920201

hope this helps...

PS

If you don't wont the IIS feature of SQL 2005, don't worry about this error,
also, if you just wont to 'play' with SQL you can install the 2008 CTP.
 
S

Steve Drake

To answer you Q regarding what version of SQL.

What do you want todo with SQL?

Developer, is the same as Enterprise, you can do all the same things.
Or... Will SQL Express do you?
Or.. what about the CTP of 2008?

Note, Developer is the same as Enterprise but it will not optimize SQL
statements that use index views. You need to use a table hint . The
optimizer works like the standard version of SQL, not Ent. If that gone over
your head then it don't concern you :)

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top