May 2, 2007 at 3:36 am
Hi all,
Does anyone know of any issues with IIS running on a Windows 2003 Advanced server with SQL 2000?
A colleague seems to think this could cause issues, but cannot recall what those issues are.
Thanks!
May 2, 2007 at 8:47 am
We've been running several servers with this configuration (and someof them in clusters) without any problems... so you should be fine
Dave
May 2, 2007 at 9:10 am
I wouldn't expect issues either. If you're serving pages on the web, it's a bad practice to have SQL on the same box as IIS for security reasons, but not functionality. Performance might suffer. I'd set the amount of RAM that SQL will use manually, not automatically.
May 3, 2007 at 8:35 am
If you have sufficient resources I tend to agree that there may not e performance issues. However another point of view is that a SQL Server is a server dedicated to SQL Server and SQL Server alone - SQL 101. This separation allows one to tune and optimize the SQL Server and the IIS Server independently for their respective application roles. Also as Steve states serving up web pages potentially means security issues if the IIS server faces the internet since usually web servers are in a DMZ and the SQL Server sits in the back office fire-walled off from everybody out on the web. Server maintenance is another potential issue to address. Application maintenance could also pose problems as well if your application configuration is comprised of multiple applications and databases.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
May 4, 2007 at 12:26 pm
I haven't had any problems doing this, and I'm running IIS on MSCS nodes. Probably not a concern.
May 4, 2007 at 12:51 pm
No no problem doing so as long as you have the hardware to support. I don't see any performane issues and would be aware of the security concerns as mentioned before.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply