Building our SQL server and SCCM SQL Instance

So now we are going to create and SQL server, this will also be our SCCM server further down the road.

So, follow the same process we used to create the File server and create an SQL server.

Add two additional drives for SQL DBs and SCCM packages, and MS Updates.

So, when you have done all that, let’s get installing SQL.

Firstly, if you do not have SQL Server 2012 you can get it from here:

Eval version

http://www.microsoft.com/en-us/download/details.aspx?id=29066

SP 2

http://www.microsoft.com/en-us/download/details.aspx?id=43340

Once installed and placed into your ISO folder and you have attached the new ISO folder to your XenConsole you can then place the SQL ISO into the DVD Drive.

sqlxenconsole

Run the setup file

Select Installation

New SQL Server Stand-alone installation or add features to an Existing installation

We are going to get our SQL server ready for SCCM at the same time.

Setting up Support Rules:

sqlsupport

Select Evaluation:

sqlproduct

Accept licensing terms.

Select any Product updates:

sqlproductupdates

Let the Install Setup complete:

sqlinstallsetup

You can ignore the Firewall warning:

sqlsetupsupportrules

Under Setup Roles, select SQL Server Feature Installation:

sqlsetuprole

Select the required Instance Features:

sqlinstancefeature

Allow Installation Rules to complete its check:

sqlinstallrules

Give the instance a name, or leave as default:

sqlinstancedefault

This will set our Citrix Instance as the default DB Instance, if you don’t want it to be default, selected Named Instance and change it to something more personal.

We want to point our DB to the additional Drive we created earlier. So select Instance Root Directory, and select the folder structure you created on your additional drive. Or choose the local folder location if you wish. I have placed the SQL DB Directory into the E drive where i wanted to store them.

Disk space check:

sqldiskspace

Change the standard SQL service accounts for the service account we created earlier, and change the startup service type to automatic for SQL Server Agent.

sqlserviceaccount

Add some security accounts, these should be the SQL-Admin group we created earlier, your current admin account and the service account.

sqlauthen

Check the Data directories screen to ensure they are going to where you want them to go…

sqldbengine

Do the same for analysis Services Configuration:

sqlanalysisservices

for Reporting Services Configuration we will do an install only:

sqlanalysisservicesconfig

Ignore the error reporting. unless you want it.

Let it run through the install:

sqlinstall

It should now be completed:

sqlcomplete

Our SQL Instance is now installed.

SCCM Instance

If you are going to be running through an SCCM install with me then we are going to install another SQL Instance. If not, then please skip to the next blog post.

So from the installer menu, we are going to select New SQL stand-alone installation.

sqlsecondinstance

Ensure Perform a new installation of SQL Server 2012 is selected.

sqlsccminstalltype

Select Evaluation for Product Key, and Accept the Licensing Terms.

Select Server Feature installation, add the same roles as we did before:

sqlsccmfeature

Move onto the Instance Configuration Page.

Change the name to WINSCCM, or whatever you want it to be called.

Change the DB directory to the already made folder structure we created on our additional attached drive.

sqlsccminstancename

Ensure Disk Space requirement is completed

sqldiskspace2

Again change the service accounts to one we created earlier. Change Startup process to Automatic for SQL Server Agent.

sqlsccmservicenames

Now select the TAB for Collation.

Change the Database Engine Collation to SQL_Latin1_General_CP1_CI_AS

sqlinstancecollation

OK that, and select Next. Add in your current user, and the SQL service account and Administrator groups. Select Next again.

Do the same for Analysis Service Configuration.

Under reporting services Configuration, just select Install.

Either opt in or out of error reporting.

Progress to install the new Instance. The second instance should now complete.

sqlsccmcomplete

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