This Blog on SCCM 2012 SQL Clustering Saved my day.

 

Thanks Matthew

Matthew Peters - A Blog

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s