Post reply

Are there issues with Installing IIS on SQL Server 2005 to support Web Services

  • January 21, 2007 at 4:10 pm

    #115825

    I'm being asked to install IIS on SQL Server 2005 to support Web Services.  I'm wondering if there are any issues with doing this?  Our environment:

    - Database Server support 20+/- applicaitions

    - Can't use Native XML Web Services because of System.Reflection name space are not supported.

    I'm looking for some advice from you guys.  If you have some white papers to backup your opinion I would like those, so I can read more to understand the pros and cons of installing IIS on our web server.

    Gregory A. Larsen, MVP

  • January 21, 2007 at 11:53 pm

    #684603

    There is no problem installing IIS on SQL server 2005. IIS is required to intall REPORTING SERVICES...

    IIS 5.0 or later is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations.

    http://msdn2.microsoft.com/en-US/library/ms143506.aspx

     

    http://msdn2.microsoft.com/en-US/library/ms143748.aspx

    MohammedU
    Microsoft SQL Server MVP

  • January 22, 2007 at 6:17 am

    #684658

    I kind of thought there where some security issues with installing IIS on a SQL Server machine.  Am I wrong in thinking this?

    Is IIS required if you install Reporting Services on an IIS machine, and only use sql server for the reporting services databases?  Also does this two box configuration for SQL Server require additional licenses SQL Server licenses for the IIS machine even though SQL Server is not installed on that machine.

    Gregory A. Larsen, MVP

  • January 22, 2007 at 12:12 pm

    #684765

    I don't think you required when you install RS on IIS box but you do need licence if you install RS on a non-sql server box.

    All components (AS,RS,SSIS) of sql server are free when you install with sql server othere wise you have to pay seperate lincence fees

    MohammedU
    Microsoft SQL Server MVP

  • January 22, 2007 at 8:58 pm

    #684842

    Thank you that is what I thought.

    Gregory A. Larsen, MVP

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply