Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

Security for Failover Clustering • Windows • Domain account needed for creation and administration • Requires Create Computer Objects right on Computers OU • If cannot give CCO, must create CNO and VCO manually • Domain account NOT used to run the cluster service; runs in a special context • SQL Server • Still requires service accounts • Use a Service SID during the installation process • Only need to be domain users NOT domain admins • Do not need to be added to the local Administrator group unless using something like xp_cmdshell (which is off by default)

MSDTC, SQL Server 2008/R2, and Windows Server 2008 R2 • OS supports multiple DTCs – no longer need to share one per Windows failover cluster • Installation options • Old way: DTC in its own group (with its own IP, disk) • One DTC per SQL Server instance • Old way + bind to instance • Put in same group with SQL Server • Do not cluster DTC at all; clustered SQL Server will “negotiate down” to use a local DTC if nothing clustered • Use MSDTC instance installed to the local group • Else • Use the mapped instance of MSDTC • Else • Use the cluster's default instance of MSDTC • Else • Use the local machine's instance of MSDTC

Summary • Validation is key to a successful SQL Server failover clustering implementation • PowerShell is a powerful alternative to a GUI-based administration scheme for failover clustering with Windows Server 2008 R2 • Installing, upgrading, and patching is very different with SQL Server 2008 (and SQL Server 2008 R2) failover clustering • The story for the Microsoft Distributed Transaction Coordinator is very different with Windows Server 2008/R2 • Virtualization may be an option for clustering in your environment • Live Migration is a good story if you are using Hyper-V

Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. DAT Track Scratch 2 Win • Find the DAT Track Surface Table in the Yellow Section of the TLC • Try your luck to win a Zune HD • Simply scratch the game pieces on the DAT Track Surface Table and Match 3 Zune HDs to win