SQL 2012 Enterprise

Posted on 2012-09-16
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 29

    Accepted Solution

    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

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
    This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now