anyweb Posted March 20, 2012 Report post Posted March 20, 2012 good info, did you not see this though, see the Note: ? Step 11. Install SQL Server 2008 Note: Perform the following on the SCCM 2012 server as SMSadmin Quote Share this post Link to post Share on other sites More sharing options...
PolishPaul Posted March 29, 2012 Report post Posted March 29, 2012 regarding step "Step 4. Delegate Permission to the System Management Container" Is there any MS/Technet documentation about this delegation? I coudn't find any (looking in the SCCM2012 docs) Any reference you can point me to? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted March 29, 2012 Report post Posted March 29, 2012 try this link 1 Quote Share this post Link to post Share on other sites More sharing options...
Steve Murphy Posted April 6, 2012 Report post Posted April 6, 2012 Hello - I am currently running 2007 on my domain, and I am getting ready to install 2012. I previously delegated permission to the system management container in 2007. I am planning to run side-by-side for the next month or two. If I Delegate Permission to the System Management Container for 2012, what does that do to 2007? I don't even know if it is possible, but if I delegate to my new 2012 server, will that cause a bunch of problems? Thanks for your help, Murf Quote Share this post Link to post Share on other sites More sharing options...
Peter van der Woude Posted April 7, 2012 Report post Posted April 7, 2012 Assuming you will use different servername and sitecode, it will just write it's atributes next to the existing ones. About what it does to your (overlapping) boundaries, you might like this post: http://www.petervanderwoude.nl/post/overlapping-boundaries-and-configmgr-2012/ 1 Quote Share this post Link to post Share on other sites More sharing options...
Steve Murphy Posted April 8, 2012 Report post Posted April 8, 2012 (edited) Thank you Peter. That was exactly what I needed. Next question... I will be installing the CAS because in the future I will have multiple campuses that will need primary sites. Do I delegate control of the system management container to the CAS server? I have read in plenty of places that the CAS does not manage clients, so I'm a little confused on this point. Thanks again for your help! Murf EDIT - Just found this in the original post. Note: Repeat the above for Each site server that you install in a Hierarchy. Edited April 9, 2012 by Steve Murphy Quote Share this post Link to post Share on other sites More sharing options...
csakg6s0 Posted April 10, 2012 Report post Posted April 10, 2012 Is it possible to use one sql server for both the CAS and Primary Server at one physical location...ie our headquarters wants to use an existing sql server to host both the instances for the CAS and the primary site. Quote Share this post Link to post Share on other sites More sharing options...
Kevin79 Posted April 11, 2012 Report post Posted April 11, 2012 I'm currently using SCCM 2007 with one primary site and 12 secondary sites at my remote locations. These locations don't need to do anything in SCCM, they just add computers to AD groups for software installation. When upgrading to SCCM 2012, should I keep the same structure or should I have a CAS? Quote Share this post Link to post Share on other sites More sharing options...
bb79 Posted April 11, 2012 Report post Posted April 11, 2012 Is this a good guide to follow for a side-by-side upgrade from SCCM 2007 to 2012 RTM? Thanks for your help. As always, awesome guides! Quote Share this post Link to post Share on other sites More sharing options...
Yassein Subratty Posted April 12, 2012 Report post Posted April 12, 2012 HI, Can we use server 2003 32bit as active directory for sccm 2012 rc2? Quote Share this post Link to post Share on other sites More sharing options...
Yassein Subratty Posted April 12, 2012 Report post Posted April 12, 2012 will i face any issue when the schema is extend on windows server 2003 32bit? Quote Share this post Link to post Share on other sites More sharing options...
Surya Posted April 17, 2012 Report post Posted April 17, 2012 Required SQL Server Collation Hi Everyone, i'm trying to install the latest release of cm on my existing sql server, but the setup keeps failing with the "Required SQL Server Collation: Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operating system and require GB18030 support. For information about changing your SQL Server instance and database collations, see http://go.microsoft.com/fwlink/p/?LinkID=234541. For information about enabling GB18030 support, see http://go.microsoft.com/fwlink/p/?LinkId=234542." anyway to fix this without altering the language of the entire server? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted April 17, 2012 Report post Posted April 17, 2012 did you read this post yet ? it tells you how to do it during SQL setup http://www.niallbrady.com/2012/03/13/about-to-install-configuration-manager-2012-check-your-sql-collation-first/ Quote Share this post Link to post Share on other sites More sharing options...
lyf4ce Posted April 19, 2012 Report post Posted April 19, 2012 Is it ok to use SQL 2012? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted April 19, 2012 Report post Posted April 19, 2012 Is it ok to use SQL 2012? nope, it's not supported at this point, use the supported versions listed here. Quote Share this post Link to post Share on other sites More sharing options...
bogaert91 Posted April 27, 2012 Report post Posted April 27, 2012 I've got a question. How do i make a network account a local administrator? Now is the group domain admins member of local administrator and i don't want an domain admin as local admin. Quote Share this post Link to post Share on other sites More sharing options...
Oneone Posted April 28, 2012 Report post Posted April 28, 2012 I've got a question. How do i make a network account a local administrator? Now is the group domain admins member of local administrator and i don't want an domain admin as local admin. You login to the machine you want to add the account to, then you ad the account to the administrators group on that machine. Quote Share this post Link to post Share on other sites More sharing options...
bogaert91 Posted May 7, 2012 Report post Posted May 7, 2012 You login to the machine you want to add the account to, then you ad the account to the administrators group on that machine. Yes I know but i want to do that automaticly when it installs a new machine with Sccm. Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted May 7, 2012 Report post Posted May 7, 2012 then script it,. add a Run Command Line step in your task sequence to do as follows:- cmd /c net localgroup "Administrators" domain\%USERNAME%" /add %USERNAME% is a variable but you can hard code it Quote Share this post Link to post Share on other sites More sharing options...
bogaert91 Posted May 7, 2012 Report post Posted May 7, 2012 then script it,. add a Run Command Line step in your task sequence to do as follows:- cmd /c net localgroup "Administrators" domain\%USERNAME%" /add %USERNAME% is a variable but you can hard code it Thank you!! Quote Share this post Link to post Share on other sites More sharing options...
Limpan Posted May 13, 2012 Report post Posted May 13, 2012 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:)? Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted May 13, 2012 Report post Posted May 13, 2012 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 .. Quote Share this post Link to post Share on other sites More sharing options...
Limpan Posted May 14, 2012 Report post Posted May 14, 2012 So the answer was that simple. Thanks. Quote Share this post Link to post Share on other sites More sharing options...
dalmatina Posted May 24, 2012 Report post Posted May 24, 2012 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. Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted May 24, 2012 Report post Posted May 24, 2012 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. Quote Share this post Link to post Share on other sites More sharing options...