Best Practices: Building a home System Center Test environment Part IV

Part IV (Installing SQL)

At this point depending on which System Center Product you are installing you may need to spin up more VMs. With SCOM you can create an all in one domain controller, SQL, SCOM Management Server though ultimately it is better to create a distributed environment with each of these items on a different VM. To save a bit on instruction writing I am going to create an all-in-one SCOM environment, but ultimately from this point it is easy to take what you have already learned to create a distributed environment. For excellent documentation on how to spin up test environments for each System Center product once you have Hyper-V and a domain controller in place I recommend taking a look at Kevin Holman’s quickstart guides:

http://blogs.technet.com/b/kevinholman/archive/2013/10/18/opsmgr-2012-r2-quickstart-deployment-guide.aspx

http://blogs.technet.com/b/kevinholman/archive/2013/10/30/configmgr-2012-r2-quickstart-deployment-guide.aspx

http://blogs.technet.com/b/kevinholman/archive/2013/10/18/orchestrator-2012-r2-quickstart-deployment-guide.aspx

https://blogs.technet.com/b/kevinholman/archive/2013/10/18/service-manager-2012-r2-quickstart-deployment-guide.aspx

http://blogs.technet.com/b/kevinholman/archive/2013/10/18/app-controller-2012-r2-quickstart-deployment-guide.aspx

http://blogs.technet.com/b/kevinholman/archive/2013/11/07/dpm-2012-r2-quickstart-deployment-guide.aspx

https://blogs.technet.com/b/kevinholman/archive/2013/10/18/scvmm-2012-r2-quickstart-deployment-guide.aspx

Since screenshots can sometimes be a little bit more helpful I will walk you through a slightly more visual guide to installing SQL and then SCOM in Part V

Log into the Domain Controller with your sysctr account

Download SQL 2012 enterprise edition with SP1 x64

Right click and mount the media

Run setup

Select New SQL Server stand-alone

Click OK

Click Next

Click I Accept & Next

Click Next

Click Next

SQL Server All Features with Defaults– Next

Uncheck Distributed Replay Controller and Distributed Replay Client — Click Next

Click Next

Click Next

Click Next

Best practices would be to use individual accounts rather than a single account, but we will use the sysctr account

Click Next

Click Next

Add Current User — Click Next

Click Next

Click Next

Click Install

Click Close

Now on to Part V Installing Operations Manager 2012 R2

Leave a Reply

Your email address will not be published. Required fields are marked *

The contents of this site are provided “AS IS” with no warranties, or rights conferred. Example code could harm your environment, and is not intended for production use. Content represents point in time snapshots of information and may no longer be accurate. (I work @ MSFT. Thoughts and opinions are my own.)