-
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…
-
Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 4 – Install first 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. Low-level design Service accounts, user accounts and groups SQL DB Servers – Service accounts sercontsqlfcic0cm0a Service account: SQL Server Agent Member Of Domain Users sercontsqlfcic0cm0d Service account: SQL Server Database Services (Database…