[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL 2012 Enterprise

Posted on 2012-09-16
Medium Priority
Last Modified: 2012-09-17
Can you utilise always on availability group feature in SQL 2012 Enterprise if you have 2 instances installed on windows 2008 R2 server standard? I am trying to use the secondary read only databases for reporting services and BI and was wondering if we need to implement windows server clustering to get this functionality, even though the clustering will not be used in our environment. Thanks
Question by:helpits
1 Comment
LVL 30

Accepted Solution

Rich Weissler earned 1500 total points
ID: 38405612
SQL 2012 AlwaysOn Availability Groups requires that each server have Windows Failover Cluster installed.  I've read articles on how to get past the shared storage requirement while installing on Windows 2008 R2, but that feature (Failover Cluster) simply isn't available in Windows 2008 R2 Standard Edition.  To make use of AlwaysOn Availability Groups in SQL 2012, running Windows 2008 R2, you need the Enterprise or DataCenter version of the operating system.

(There are two technologies which both come under the heading of AlwaysOn - and both require Windows Failover Clusters... in the next version of Windows Server (2012), the requirements to build a cluster are relaxed somewhat.  I can't say for certain which version of Windows Server 2012 you'd need.)

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to install and use the NTBackup utility that comes with Windows Server.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question