-
Building Microsoft SQL Server AlwaysOn Availability Groups – Part 2 – Create cluster and configure OS
Storage We do not need any clustered disk for this type of SQL cluster that we will create but unless you do not want to store all database data and logs on the C volume (not recommended in the production environment) you need enough local disks. In our case we do not need too many…
-
Building Microsoft SQL Server AlwaysOn Availability Groups – Part 1 – Design
It is not always easy to divide Low-level Design and High-Level Design. How to differentiate between high-level and low-level design depends on the entity that we refer to. When we need to design our cloud then high-level decision could be choice of the technology that makes our SQL Servers highly-available. But when we talk about our…
-
Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 7 – Manually configure Reporting Services
When you install standalone SQL Server (apply for standalone and also standalone for AlwaysOn Availability Groups) you can select Install and configure Reporting Services and installer does simple configuration of the Reporting Services that is suitable for most of the applications. There is a reason why the default choice for Reporting Services during installation of…
-
Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 6 – Install another instance
This article is not part of the System Center Cloud series but we will use the final product to host System Center database instances. Low-level design Service accounts, user accounts and groups Pre-create another set of service accounts that will be used for the new instance in the Active Directory. It is best practice to have…
-
Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 5 – Install second node
This article is not part of the System Center Cloud series but we will use the final product to host System Center database instances. Install .NET Framework 3.5 SP1 on SCSM servers There is a known bug that SQL Server installer is not able to install .NET Framework 3.5 and therefore it is good idea to…