Its not supported on Home Basic

You don't need IIS for SQL Server to work.

If you use Visual Web Developer 2005/2008 Express Edition, they have there own embedded IIS web server called WebDev.exe that runs automatically when you run your site in debug.

I have XP Home Basic and I installed Apache/PHP/MySql using xampp for windows for doing other web stuff.

ok thanks for the response, so there is nothing extra I need to do for SQL to work when I debug via VS2005?

You will need to add a plugin if you use Lamp for any ASP pages.

If you have never installed Lamp, id recommend Xampp:

http://www.apachefriends.org/en/xampp.html

I thought lamp was Linux/Apache/Mysql/PHP is that right ?

Yes that's right. xampp is for Xp/Apache/MySql/Php I can't remember what the extra p is for, possibly PhpMyAdmin for administering MySql with a GUI.

ok thanks a lot for the information. I have used it breifly before, found it useful

You might also come to find that php is cooler than asp, and quite possibly never look back.

I found the opposite, so you never can tell.

@OP: as mentioned, Visual Web Developer 2005 and 2008 have their own web server. It's not exactly the same as IIS, but you can use it to test and debug your web applications before deploying them to a web server.