This Blog on SCCM 2012 SQL Clustering Saved my day.
This post is here to help you set up an instance of SQL Server with the intention of using it for storing the database for System Center Configuration Manager. It goes through the settings that need to be made during the installation to be compatible, as well as post-setup configuration required to get the server fully up and running.
I am installing everything on to a single Windows Server 2008 R2 Standard virtual machine for the purposes of this. In an ideal world, all the server roles (Domain Controller, SQL Server, SCCM roles) would (and should) be split out across multiple servers with fail-over redundancy etc in place.
The Windows Server machine is an Active Directory domain controller, DHCP and DNS server. It is set up this way to closely reflect as much as possible a real life situation. The server has had all Windows Updates installed (generally a good…
View original post 2,154 more words