Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Application Server Role Expand / Collapse
Author
Message
Posted Wednesday, July 08, 2009 8:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 05, 2013 8:11 AM
Points: 5, Visits: 153
Hi,

Can you tell me if the Application Server Role is required for SQL2008 in a cluster.

The SQL install does not flag it as a prerequisite but some installation docs mention it.

What does it do in the cluster environment?

Many Thanks

Mark
Post #749294
Posted Friday, August 21, 2009 5:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:43 AM
Points: 2,723, Visits: 1,090
MO (7/8/2009)
Hi,

Can you tell me if the Application Server Role is required for SQL2008 in a cluster.

The SQL install does not flag it as a prerequisite but some installation docs mention it.

What does it do in the cluster environment?

Many Thanks

Mark


Hi Mark,

Are you talking about a SQL 2008 cluster install on a windows 2008 cluster, if that is the case, the following article might help

http://www.mssqltips.com/tip.asp?tip=1687

normally the application role is used to facilitate the use of MSDTC and other tools.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #774914
Posted Tuesday, August 25, 2009 4:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 05, 2013 8:11 AM
Points: 5, Visits: 153
Thanks for the reply. Yes we are running SQL2008 on Windows 2008.

I had spotted that article. It states that you have to add the application server role but doesn't give any explanation why.

However I also found this technet article http://technet.microsoft.com/en-us/library/cc754024(WS.10).aspx which states that 'Not every server application benefits from the installation of the Application Server role. For example, the Application Server role is not necessary to support Microsoft Exchange Server or Microsoft SQL Server on Windows Server 2008'

Any idea which is correct?
Post #776532
Posted Monday, October 12, 2009 6:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 28, 2014 12:56 PM
Points: 24, Visits: 188
Silverfox's post did contain the answer but I will explain somewhat further. If you want to have MSDTC installed in your cluster then YES you must install the Application Server Role. BUT....You are only installing a small portion of it. You will only need to enable Distributed Transactions/Incoming & Outgoing Remote Transactions. If you do not see a need for MSDTC then no it is not required for a SQL Cluster installation. But, on a side note, during the install it does look for it - you can continue without it but it does make the install process cleaner.

db
Post #801531
Posted Monday, September 30, 2013 5:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 2, Visits: 79
Since I'm aiming to configure MSDTC after our 2nd & final node SQL 2008 cluster install is it recommended to enable this Application Server Role prior to my 1st node install or is it ok to do this after 2nd node install and any recommendation on either enabling or excluding the 'WS-Atomic Transactions' option also? Thanks in advance.
Post #1500229
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse