Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?
Not sure I understand your point/question.

Yes IIS and asp work together and will be used on the webserver but if you want to pass the data from the webform to the database then the database will need to reside on the same server that's all I'm saying.