Deploying SQL Server 2016 Basic Availability Groups Without Active Directory. Part 2: Configuring SQL Server
Posted by Edwin M Sarmiento on November 23, 2017

In the previous blog post, I’ve walked you thru the process of creating the Windows Server 2016 Failover Cluster  (WSFC) that is not joined to an Active Directory Domain. It is very important that you get the underlying WSFC properly configured and stabilized before you even attempt to create the SQL Server 2016 Always On Basic Availability Group. The availability and reliability of your SQL Server 2016 Always On Basic Availability Group depends so much on the WSFC.

If you have previously configured Always On Availability Groups, you will notice that most of the steps provided are similar to configuring it with Active Directory. But because there is no centralized directory service for managing accounts, you will need to rely on certificates for authenticating communication between replicas. You need to use T-SQL to accomplish those tasks.

Microsoft SQL Server logo

 

(more…)

Appreciate how useful this article was to you?
No Ratings Yet
Loading...
Deploying SQL Server 2016 Basic Availability Groups Without Active Directory. Part 1: Building the Platform
Posted by Edwin M Sarmiento on October 31, 2017

Introduction

When Availability Groups were introduced in SQL Server 2012, they were only available in Enterprise Edition. This made it challenging to move from Database Mirroring to Availability Groups, especially if you’re running Standard Edition.  To upgrade and migrate from Database Mirroring in Standard Edition, you either choose to upgrade to a more expensive Enterprise Edition license and implement Availability Groups or stick with Database Mirroring and hope that everything works despite being deprecated.

SQL Server 2016 introduced Basic Availability Groups in Standard Edition, allowing customers to run some form of limited Availability Groups. Customers now have a viable replacement for Database Mirroring in Standard Edition. However, unlike Database Mirroring, Availability Groups require a Windows Server Failover Cluster (WSFC). SQL Server database administrators now need to be highly skilled in designing, implementing and managing a WSFC outside of SQL Server. Because the availability of the SQL Server databases relies heavily on the WSFC.

SQL Server 2016 logo

(more…)

Appreciate how useful this article was to you?
No Ratings Yet
Loading...
Installing System Center Configuration Manager 1610 (Current Branch) on Windows Server 2016 with SQL Server 2016. PART 2
Posted by Nicolas Prigent on March 16, 2017

Microsofr System Center Configuration Manager

Thanks to the previous part, we have SQL Server 2016 installed and configured. Before running the SCCM installation process, let’s remember the architecture we are implementing.

(more…)

Appreciate how useful this article was to you?
No Ratings Yet
Loading...
Installing System Center Configuration Manager 1610 (Current Branch) on Windows Server 2016 with SQL Server 2016. PART1
Posted by Nicolas Prigent on March 14, 2017

Microsoft System Center Configuration Manager

On November 17th  2016, Microsoft SCCM Team has released version 1610 for the Current Branch (CB) of System Center Configuration Manager that includes some great new features and product enhancements.

SCCM 1610 includes lots of new features and enhancements in Windows 10 and Office 365 management, application management, end user experience, client management and also includes new functionality in hybrid mode with Microsoft Intune.

(more…)

Appreciate how useful this article was to you?
No Ratings Yet
Loading...