How Can I Install #SCCM / #Configmgr 2012 SP1 Beta CAS + Primary Site with SLQ Server 2008 R2- Part 1

 

While Installing SCCM 2012 SP1 Beta on My Hyper-V,I had some trouble with SQL server Collation and some prerequisites like .net framework etc.

Thought of sharing the step by step installation of SCCM 2012 SP1 Beta .This might be helpful to you .

In this post,I will go through the installation of SQL server 2008 R2 SP1 CU6.

For Installation of Central Administration Site http://eskonr.com/2012/09/how-can-i-install-sccm-2012-sp1-beta-casprimary-with-sql-server-2008-r2/

for Installation of Primary Site attaching to CAS.

For SCCM 2012 SP1 Beta Prerequisites,Please refer http://eskonr.com/2012/09/sccm-2012-sp1-beta-prerequisites/

For Supported configurations of SCCM 2012 SP1 Beta Please refer  TechNet Guide http://technet.microsoft.com/en-us/library/gg682077.aspx

Download Full Version of SCCM 2012 SP1 Beta here http://eskonr.com/2012/09/sccm-2012-sp1-beta-is-available-to-download/

Setup :

I have One domain ESKONR.COM running on Windows server 2008 R2 with DNS role installed on it.

Create Required account for the installation(I go with sccmadmin with domain admin Privileges) and configuration (like NAAccount,Client push installation Account,Report Viewers Group,DomainJoin Account etc).

all the Servers are running on Windows server 2008 R2 Operating System.

For SQL server requirements, Please refer my Previous Post

Installation of CAS:

1.Install IIS Role with Features like BITS,.Net Framework 3.5 SP1,Remote Differential Compression and other roles what you need (RSAT etc).

2.Make your partitions Ready For SQL,SCCM ,Distribution Point and Sources files.

3. Create NO_SMS_ON_DRIVE.SMS and place it on drives except the drive where you want to store the packages as Distribution Point.

4.Start the installation of SQL server ( I choose to Go with SQL server 2008 R2 SP1 with CU6)

P.S: You May not find brief description about all the screen shots except some if something is interesting to Know.

Start the Installation of SQL server 2008 R2 :

clip_image002

clip_image002[4]

clip_image002[8]

clip_image002[10]

clip_image002[12]

clip_image002[14]

clip_image002[16]

You must use a dedicated instance of SQL Server for each site.. I go with Default Instance.

clip_image002[18]

clip_image002[20]

clip_image002[22]

At each site, both the instance of SQL Server in use for the site database and the site database must use the following collation: SQL_Latin1_General_CP1_CI_AS.

clip_image002[24]

Configuration Manager requires Windows authentication to validate connections to the database.

clip_image002[26]

clip_image002[28]

Select the Drive to store the database information.

clip_image002[30]

clip_image002[32]

clip_image002[34]

clip_image002[36]

clip_image002[38]

Now we are done the Installation of SQL Server 2008 R2.

As SCCM 2012 SP1 Beta requires SQL server 2008 R2 SP1 with min CU6.So Lets do that Now.

Start the installation of SQL Server 2008 R2 SP1 with all next, next, next and close at the end Smile .

Start the installation of SQL server 2008 R2 SP1 CU 6 with all next, next, next and close at the end Smile

Now lets do the simple configurations (Set a Fixed Amount of Memory) on SQL server  and enabling of Name Pipes.

When you use a database server that is co-located with the site server, limit the memory for SQL Server to 50 to 80 percent of the available addressable system memory.

When you use a dedicated SQL Server, limit the memory for SQL Server to 80 to 90 percent of the available addressable system memory.

Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory in the buffer pool used by an instance of SQL Server for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio. For more information about how to set a fixed amount of memory For more info how Set a Fixed Amount of Memory (SQL Server Management Studio).

Open the SQL server management Studio and go properties of the server. clip_image002[40]

clip_image002[42]

Allocate memory I go with 1024 MB.

clip_image002[44]

Next to Enable Named Pipes from SQL Server configuration Manager

clip_image002[46]

clip_image002[48]

Enable Named Pipes and restart SQL server agent service.

Follow the next Post to Start the Installation of SCCM 2012 SP1 Beta Central Administration Site http://eskonr.com/2012/09/how-can-i-install-sccm-2012-sp1-beta-casprimary-with-sql-server-2008-r2/

Leave a Reply