SQL Server and IIS
-
I was recently told that Microsoft does not support having IIS and SQL Server on the same machine. Anyone have any comments or experience with this. I know on my development domain both are running on the same box with no problems, although obviously I'm not serving 100(0)'s of pages or transactions a minute.
-
I was recently told that Microsoft does not support having IIS and SQL Server on the same machine. Anyone have any comments or experience with this. I know on my development domain both are running on the same box with no problems, although obviously I'm not serving 100(0)'s of pages or transactions a minute.
It is certainly preferable to have them on seperate boxes, but it is not required. I always run SQL and IIS on the same machine in my development environments. I never have enough machines to dedicate two to development. In most production environments, I have run them seperate. I have run them on the same machine in low traffic production environments, but I wouldn't try to push it to far. I ran into a bug with IIS4 and ASP2 on NT4 where I counld not get it to access a remote datasource consistently. This was the only instance where I HAD to run SQL and IIS on the same machine. This was on a production intranet and was not hit too hard, and I did not have any problems. (well outside of bugs :-D ) Jason Jystad Cito Technologies www.citotech.net >------------------------------------------------< "Luckily," he went on, "you have come to exactly the right place with your interesting problem, for there is no such word as 'impossible' in my dictionary. In fact," he added, brandishing the abused book, "everything between 'herring' and 'marmalade' seems to be missing." -- Dirk Gently (Douglas Adams) >------------------------------------------------<
-
I was recently told that Microsoft does not support having IIS and SQL Server on the same machine. Anyone have any comments or experience with this. I know on my development domain both are running on the same box with no problems, although obviously I'm not serving 100(0)'s of pages or transactions a minute.
There are no restrictions on having them on the same box. The rule of thumb is that for higher demand environments you want to look at seperating applications on to their own servers. Cheers! Colin