-
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…
-
Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 2 – Distributed Transaction Coordinator (MSDTC)
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 guest (virtual) failover cluster Please continue to the Building guest (virtual) failover cluster series to learn how to create guest cluster from the virtual machines. Prerequisites Cluster: Microsoft Windows Server 2012 R2…