This is one for all you SQL and IIS specialists out there.
Lately, we’ve been getting many requests for installed SQL servers with a link to an IIS server for a web interface. At first it was only a couple so separate servers for the SQL instances and the IIS instances wasn’t a problem. But now as it grows, it’s going to become impractical to maintain single servers dedicated to that single function.
So, as I’m not an expert on SQL or IIS I’m hoping for some advice on how to manage this growing monstrosity.
First I’d like to know the “best practices” from experience, what worked, what didn’t and why if possible.
Second, can you put multiple IIS sites on a single server and have them pointing to their specific databases on separate SQL servers?
Third, can you put multiple IIS sites on a single server and multiple SQL databases on a single server and have them communicate properly to each other?
