what are the pros/cons of 2005 SQL install without IIS on 2003 server

I'm doing a big migration from 2000 to 2005 SQL (about 50 big dbs) and just setting up my test lab to begin the scripting test scenarios.  What are the pros/cons of installing IIS for 2005 SQL?  Can you give me some URL addresses to any articles that directly address this specific topic?
ksuchyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
Sure...http://www.microsoft.com/technet/serviceproviders/apps1_5/CMSU_DH_Plan_CONC_Best_Practices.mspx?mfr=true

Check the installer language.  IIS is not a requirement.  It's telling you that if you expect to use IIS, perhaps with HTTP endpoints, it may not function.  Having said that, IIS doesn't have to be on the same machine as SQL Server in order for things to work right.

FWIW, I have about 130 SQL Servers and none of them have IIS on them.
0
 
Chris MangusDatabase AdministratorCommented:
I haven't installed IIS on any of my SQL 2005 servers.  Our policy is to never run IIS on the same server as SQL Server, according to Microsoft Best Practices.
0
 
ksuchyAuthor Commented:
Hi Cmangus,

Thank you for this quick input.  I appreciate your help.

I just took another look at the old db server, which does have IIS.  My boss, who knows alot more about SQL than I do, also told me his recommendation is to install IIS.  As I look around the web, there are plenty of sites that show that IIS is being installed by MOST shops, when they install SQL 2005 (for instance, see this site: http://www.campus.ncl.ac.uk/databases/sqlser/SQL2005/setupsql2005.html)

Can you provide me a URL address to a site which shows that NOT installing IIS is a recommended best practice of MS?   That would seem somewhat incredible to me, given that the SQL installer min. requ's wizard give an "error" if IIS is not installed, and every single IIS webpage I have seen thus far indicate that MS assumes you are going to be installing IIS also.

Regards,
K
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
ksuchyAuthor Commented:
Basically, I'm looking for the PROs and the CONs of installing/not installing IIS on a server devoted exclusively to SQL 2005.  We are concerned over security, possible extra maintenance due to IIS, and of course, with providing a good suite of functionality to our db customers.
0
 
ksuchyAuthor Commented:
Cmangus,

Thanks so much (again) for your help cmangus, I'm very grateful for your expertise.

One last request before I award point:  is there any way that you could give me one more hyperlink (please?), perhaps to an article or webpage which tells me what we will be forgoing (missing) by not installing IIS?

Kindest Regards,
Kathy
0
 
Chris MangusDatabase AdministratorCommented:
I believe that the only reason the install wizard checks for it is because you need IIS to use Reporting Services.

You may want to wait to award points to give other EE members time to chime in.
0
 
Chris MangusDatabase AdministratorCommented:
Books on line mentions this point about needing IIS for Reporting Services...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm
0
 
ksuchyAuthor Commented:
gotcha.  will wait until the morning.

~k
0
 
ksuchyAuthor Commented:
Hi Cmangus,

Well, I'm going to just give you full points for your one post which was semi-useful and close this question now that it has been filled up with posts (discouraging many others from taking a quick peek).  I'm sorry, but as far as I can tell, you are wrong about not installing IIS being a "best security practice" for SQL 2005, although I do not doubt that you have alot of experience in this.  The link you provided is indeed a discussion of SQL security best practices, but the closest it comes to this kind of statement is that you should not install SQL server on an IIS Server --- where the wording is clearly indicating that where one is using a machine primarily as a "web server" don't try to stack up and use it as a SQL server also.  That is a completely separate idea from the need for IIS on your SQL 2005 server in order to get full functionality (but not publishing via DNS any websites alias going to it, other than for Reporting Services in SQL).  

Going back to my ORIGINAL and repeatedly stated question, namely, "what are the CONS" I will have to find the answer myself as to what are the main disadvantages, including what is lost with Reporting Services.

Thanks again for your attempts to assist on this,
~Kathy
0
 
Chris MangusDatabase AdministratorCommented:
No problem.  If you do find of some functionality that doesn't work, other than Reporting Services please let me know about it.  I've been in the SQL Server game for about 15 years now and haven't seen anything break yet, but that doesn't mean something won't. :)

Chris / chrism@peoriaaz.gov
0
All Courses

From novice to tech pro — start learning today.