Post reply

SQL Server 2008 R2 Failover Cluster, Which windows server roles are recommended and which ones not recommended to be installed?

  • June 11, 2012 at 8:00 am

    #392480

    Hi,

    SQL Server 2008 R2 Failover Cluster, Which windows server roles are recommended and which ones not recommended to be installed?

    I'm asking because both of the servers of my 2 node SQL Server failover cluster have application server and web server roles, but I'm wondering if there is a risk of having the web server installed.

    Thanks for your help

    APA

  • June 12, 2012 at 9:54 am

    #1499896

    I wouldn't recommend running webserver roles on your SQL boxes unless you need some of the components for specific reasons. You would have to check with your sysadmins to see why those components were installed.

    Some application service roles are required such as .Net Framework and probably distributed transactions. Again, check with your sysadmins on the reasons behind particulars component installs.


    Shamless self promotion - read my blog http://sirsql.net

  • June 12, 2012 at 3:04 pm

    #1500067

    APA0876 (6/11/2012)

    Hi,

    SQL Server 2008 R2 Failover Cluster, Which windows server roles are recommended and which ones not recommended to be installed?

    I'm asking because both of the servers of my 2 node SQL Server failover cluster have application server and web server roles, but I'm wondering if there is a risk of having the web server installed.

    Thanks for your help

    APA

    you do not need the web server role installed

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • June 12, 2012 at 7:52 pm

    #1500122

    Thanks for your answers I totally agree,

    Web server uninstalled

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

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