Install SCVMM Part 2 – Database

In the first post of this series we have gone through the process of describing and installing all necessary components for a successful SCVMM install, in this second post I will describe the database installation which will be used by our SCVMM install to store data about the infrastructure.

Install SCVMM – Database Installation

As described in the previous post we will be deploying SQL 2012 on the same machine where we will install SCVMM, this kind of deployment is fine for lab environment and smaller scale deployments but I discourage using it in a production environment.

Once Windows 2012 R2 has been installed, updated and configured it is time to start with SQL 2012 installation, insert the CD/ISO and start installation selecting the Stand alone installation option from the Installation menu:

Install SCVMM

Wait for the pre-requisite checker to run if any of the checks fails at this stage just go back to your OS and fix any reported problem, just hit Ok when ready to proceed and download any update that is available at installation time:

Install SCVMM SQLInstall SCVMM

In the next couple of screens you will be asked to accept license agreement and enter a license key, I am using the option to install a trial version of SQL 2012, just click on next until you reach the Setup Role page where you will select SQL Server Feature Installation

Install SCVMM SQL

In the feature Selection screen select Database Engine Service from the Instance Features section, this is the only component needed to install SCVMM but if you’re using a shared DB Server you can select additional components and to make your life easier I suggest to install both Management Tools – Basic and Management Tools – Complete from the Shared Feature section:

Install SCVMM SQL 5Install SCVMM SQL 6

Just hit next in the Installation Rule page and select to install a default instance in the Instance Configuration page unless you have a specific need for a named instance:

Install SCVMM

Just hit next until you reach the Server Configuration screen where you need to configure the account used by Windows to manage SQL Services, in part 1 of the series we have created a dedicated accountfor the purpose, it is configured in this screen:

Install SCVMM

You can leave the Collation settings to its default but be aware that if you’re using a shared DB server and plan to install System Center Configuration Manager database on the same server you will need to change the collation to  SQL_Latin1_General_CP1_CI_AS otherwise SCCM will throw an error at installation time.

In the Database Engine Configuration add your account and any additional account to the SQL Administrators group this can be configured later on but doing it now will save some time, I’ve added my personal account and a generic service account named SQL Admin

Install SCVMM

Just click next until reaching the Install screen, review the summary and if everything is correct just proceed with the installation, allow sufficient time for all components and then install all available SQL updates.

Install SCVMMSQL for SCVMM

Install SCVMM – What’s next?

This marks the end of the second part of this series, we have prepared the base OS, installed all requisite software and deployed the database server that will be used in our next post to install SCVMM.

Stay tuned and take a moment to share the post or leave any comment which is always welcome!

Advertisements

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