SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Application Server Role


Application Server Role

Author
Message
MO-933989
MO-933989
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 157
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
Silverfox
Silverfox
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6496 Visits: 1161
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
MO-933989
MO-933989
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 157
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?
xxdbxx
xxdbxx
SSC Veteran
SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)

Group: General Forum Members
Points: 238 Visits: 195
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
techresearch7777777
techresearch7777777
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 198
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search