using SCCM 2012 in a LAB - Part 1. Installation

[Limpan]

Firstly, I must say I appreciate your clear and concise guides but I have one question regarding this one.

 

Why is it that I should put my SQL install in D:\Program Files ? Why is it that C:\Program Files won't do? If it's a question of storage space, approximately how much should I compensate with to be able to put the SQL install at it's default location (C:)?

[anyweb]

D:\ is just a suggestion, you can put it wherever you want, but seeing as most people frequently run out of space on C:\ due to poor planning i'd suggest another drive letter other than C:\, also SQL is IO intensive (disk read/write) and if possible you should try and install on it's own hard disc.

 

Also you don't want to mix SQL or other programs (Configuration Manager) with the operating system, think about performance ..

[Limpan]

So the answer was that simple. Thanks.

[dalmatina]

Hi!

 

Is sql 2012 supported with final (RTM) Version of sccm 2012?

 

regards

 

EDIT:

 

Tried to install one hyper-v machine with sql2012 and one with sccm2012. (both in the domain) and cannot install sccm

 

Have the same error like here:

 

http://www.configurationmanager2012.com/Configuration-Manager-02.html

 

what to do?

 

 

Have no "new" option described here:

 

*** Create a SSL certificate and assign it to the SQL Network properties!

In the CA (Certificate Authority MMC snap-in) right click Cert Template container and select "Manage"

For this I duplicated a new certificate template from the computer cert

(Name appropriately: Example = SCCM SQL Cert)

(I recommend the validity period increased and allow private key to be exported)

(Change to just server Authentication)

(Subject Name from DNS)

(On the security TAB, add the SQL server computer object)

(On the security TAB, add an AD account object that will make the request)

 

In the CA (Certificate Authority MMC snap-in) right click Cert Template container and select "New" / Certificate Template to issue and select the newly created template.

Reboot the CA (This will make the template available to all machines in the domain immediately)

Login to the SQL server (with the account you specified on the template security TAB), open the Computer Certificate Snap-in and request a new certificate selecting the newly created cert template (SCCM SQL Cert)

Once this is done you can now specify this certificate on the SQL Networking properties.

[anyweb]

no, SQL Server 2012 is not yet supported so don't use it until it is. The supported versions of SQL Server are listed in my Configuration Manager 2012 RTM guide here.

[CrapCleaner]

Hi all,

 

Im really stuck during the prerequisites check of SCCM2012. I'm setting up a stand-alone primairy site server on a small virtual environment for testing puroposes.

 

I have 2 issues that I don't understand.There are also a few other warnings but these are quite easy to solve. The two warnings on top are cracking my brain for two days now.

 

1st issue is a schema extensions warning. I have taken care of the schema extension and the creation of the System Management container with proper delegated rights. Here is the log file from my DC:

 

<06-14-2012 17:21:53> Modifying Active Directory Schema - with SMS extensions.

<06-14-2012 17:21:53> DS Root:CN=Schema,CN=Configuration,DC=demo,DC=lan

<06-14-2012 17:21:54> Defined attribute cn=MS-SMS-Site-Code.

<06-14-2012 17:21:55> Defined attribute cn=mS-SMS-Assignment-Site-Code.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-Site-Boundaries.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-Roaming-Boundaries.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-Default-MP.

<06-14-2012 17:21:55> Defined attribute cn=mS-SMS-Device-Management-Point.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-MP-Name.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-MP-Address.

<06-14-2012 17:21:55> Defined attribute cn=mS-SMS-Health-State.

<06-14-2012 17:21:55> Defined attribute cn=mS-SMS-Source-Forest.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-Ranged-IP-Low.

<06-14-2012 17:21:55> Defined attribute cn=MS-SMS-Ranged-IP-High.

<06-14-2012 17:21:55> Defined attribute cn=mS-SMS-Version.

<06-14-2012 17:21:55> Defined attribute cn=mS-SMS-Capabilities.

<06-14-2012 17:21:57> Defined class cn=MS-SMS-Management-Point.

<06-14-2012 17:21:57> Defined class cn=MS-SMS-Server-Locator-Point.

<06-14-2012 17:21:57> Defined class cn=MS-SMS-Site.

<06-14-2012 17:21:57> Defined class cn=MS-SMS-Roaming-Boundary-Range.

<06-14-2012 17:21:57> Successfully extended the Active Directory schema.

<06-14-2012 17:21:57> Please refer to the ConfigMgr documentation for instructions on the manual

<06-14-2012 17:21:57> configuration of access rights in active directory which may still

<06-14-2012 17:21:57> need to be performed. (Although the AD schema has now be extended,

<06-14-2012 17:21:57> AD must be configured to allow each ConfigMgr Site security rights to

<06-14-2012 17:21:57> publish in each of their domains.)

 

2nd Issue - Active Directory Domain Functional Level Check; Warning; The domain functional level is not configured for Windows Server 2003 or later. The domain functional level must be Windows Server 2003 or later if you will configure discovery to filter and remove stale computer records. Stale records are filtered by using the last logon timestamp for a computer. When you remove stale records, you can improve the performance of discovery. For more information about Active Directory domain functional levels, see http://go.microsoft..../?LinkID=226022.

 

My domain is running at 2008 R2 functional level as shown in the attached screenshot.

 

I really hope someone is able to give me push in the right direction.

Many thanks in advance!

[anyweb]

are you logged in with a domain user account when running the check (or just as a local account)

[pbloom]

Hello All,

 

I am having a problem getting sccm 2012 RC to recognizing my instllation of SQL 2008R2 SP1

when I run the ASSESS Server Readiness Please see the following SQL config below

 

Microsoft SQL Server Management Studio 10.50.2500.0

Microsoft Analysis Services Client Tools 10.50.2500.0

Microsoft Data Access Components (MDAC) 6.1.7601.17514

Microsoft MSXML 3.0 6.0

Microsoft Internet Explorer 9.0.8112.16421

Microsoft .NET Framework 2.0.50727.5456

Operating System 6.1.7601

Any Idears

 

Thanks

[anyweb]

you do realise that Configuration Manager 2012 has RTM'd already and that the RC is therefore redundant ?

[CrapCleaner]

are you logged in with a domain user account when running the check (or just as a local account)

 

Sorry for the late response.....I solved the issue after I found out other issues in my test environment.

The problem was caused by a duplicate SID :angry: . I cloned my template server twice and promoted one of the server to a DC.

It looks like everything is working fine after you add the second server to the domain but truth is totally different. Stupid of me but on the other hand unbelievable that Microsoft still allows us to add cloned servers to a domain.