Installation Problems SCCM 2012 with SQL 2008R2   4 comments

anyone who’s trying to install SCCM 2012 needs to do a check if there environment is ready for SCCM 2012.

Well and most of the items are AD or SQL related and easy to fix. this will not be a long story only the quick fixes. the installation guides and all other stuff is already on the Web so here it is.

get SCCM 2012 here : http://www.microsoft.com/en-us/server-cloud/system-center/configuration-manager-2012.aspx

here are all the supported SQL configs : http://technet.microsoft.com/en-us/library/gg682077.aspx

SQL 2008R2 is supported only if you have Hotfix KB2603910 and this required for using SQL 2008 R2 with ConfigMgr 2012RC. http://support.microsoft.com/kb/2603910 thanks : @matthewwhite https://twitter.com/#!/matthewwhite

sccm 2012 prerequisites :

As all of you know, one of the first installation steps is the Update Prerequisite Components.
If you don’t have access to internet on your SCCM server then you have to download the required updates on another computer, import the folder on the SCCM server and have SCCM setup pointing to the folder.
In the previous version (SCCM 2007) the command was Setup.exe /downloads <target dir>. In SCCM 2012 this has changed, and the new command is SetupDL.exe <target dir>.
The SetupDL.exe file is located in the SMSSETUP\BIN\X64 directory.

But what about SQL what version should I use on the RC version?

The clear message “Configuration Manager sites require SQL Server 2008 SP1 with Cumulative Update 10 or higher for site database operations to succeed. SQL Server 2008 SP2 and SQL Server 2008 R2 are not supported.” says that this requirement is hard.
Please note that even SQL Server 2008 SP2 is not supported

The big gotcha in SCCM 2012 Beta 2 is the tedious requirement for SQL Server 2008 SP1 with Cumulative Update 10. Not SQL Server 2008 R2 or even SQL Server 2008 SP2. Ultra specific, which I cant imagine that will remain this way for RC/RTM and should support SQL Server 2008 R2 (and Denali).

But does it really not Work ? lets find out. First when I started the RC setup there was this AD error I do not have a screen shot but is says ad no access etc .I have full access.

FIX : Create the System center object and give the SCCM server Full access. start adsiedit.msc

 

image imageimageimage

Now that the computer has full Access on the AD container we have one error less.

My SQL server 2008R2 image  and it is a cluster Winking smile as an cluster MVP every thing should be clusterd or atleast you should try to do this.

as the default SQL is using dynamic ports, yes it is , this is a great security thing no more 1433 etc but how to check the SQL port. yes there is your error.

go set the SQL ports on fixed how ? image Go to the SQL configuration manager and change the port at the bottom remove the 0 and on tcp port fill in 1433 and you are done. Restart the SQL services and start the SCCM setup.

this can’t be all ? yes it is if you have a healthy server it is .

Now that the SCCM 2012 setup is running and there are no errors or warnings I believe SCCM will run just fine Winking smile

My VM has 1 CPU 3.2ghz and 2GB mem and a 200Gb C drive but more CPU and memory is better. I has also a own WSUS and WDS installed.

clip_image002clip_image002[4]clip_image002[6]clip_image002[8]

Yes my SCVMM 2012 has also a WSUS and my home Corp server Has also a WSUS server why well I have 8 WSUS servers in my testlab ;-( crazy

my guess the NEXT version of wsus will fix this. oh and you can’t link them no top/down tier WSUS servers.

and please do test the endpoint protection in SCCM all my VM’s are protected now easy step.

 

 

Technorati Tags: ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Windows Live Tags: Installation,Problems,SCCM,check,stuff,manager,Update,Prerequisite,Components,computer,folder,Setup,SetupDL,file,SMSSETUP,Configuration,Server,Cumulative,database,Beta,Ultra,support,Denali,Work,shot,Create,System,object,Full,container,cluster,port,Restart,WSUS,SCVMM,Corp,test,easy,here,microsoft,center,aspx,version,command,target,should,says,error,ports,also,servers
WordPress Tags: Installation,Problems,SCCM,check,stuff,manager,Update,Prerequisite,Components,computer,folder,Setup,SetupDL,file,SMSSETUP,Configuration,Server,Cumulative,database,Beta,Ultra,support,Denali,Work,shot,Create,System,object,Full,container,cluster,port,Restart,WSUS,SCVMM,Corp,test,easy,here,microsoft,center,aspx,version,command,target,should,says,error,ports,also,servers

Advertisements

4 responses to “Installation Problems SCCM 2012 with SQL 2008R2

Subscribe to comments with RSS.

  1. Rob,

    I recently went to an event with Wally Mead and he said that SQL 2008 R2 is supported with SCCM 2012 RC, but you need a hotfix (which hasn’t been released yet, it’s only available for SQL 2008 at the moment).

    KB2603910 is the one you want.

    • you are right, the sql problems are in general and it was not to show that R2 is working but more solve the issues with the prereq. I do not have this update on my SQL cluster 😉 I don’t need support on my lab servers.
      I added the KB to my Post thanks.

  2. Thanks Rob 🙂

    I have just written a quick blog on the _officially_ supported SQL versions for the RC:

    http://systemcenterblog.hardac.co.uk/2011/11/sql-support-in-configmgr-2012-rc.html

    Matt

  3. continuously i used to read smaller posts that as
    well clear their motive, and that is also happening with this post which I am reading at this time.

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

  • Twitter

  • %d bloggers like this: