NIGHTCD Posted April 27, 2012 Report post Posted April 27, 2012 Hello.. i have successfully installed the SCCM 2012 RC2 in an test environment. but when i try to install SCCM 2012 in an production environment it fails. so my questions is follow: - Do i have to install SQL 2008 on the SCCM2012 for the SMS Provider? - How can i do an workaround to use the SQL Cluster (SQL 2008 R2 CU4)? - I get an load of errors that state the SQL server is not installed on the SCCM 2012 server even if i have spesified the SQL Cluster as database server. NIGHTCD Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted April 27, 2012 Report post Posted April 27, 2012 have you seen this ? Configurations for the SQL Server Site Database Each System Center 2012 Configuration Manager site database can be installed on either the default instance or a named instance of a SQL Server installation. The SQL Server instance can be co-located with the site system server, or on a remote computer. When you use a remote SQL Server computer, the instance of SQL Server used to host the site database can also be configured as a SQL Server failover cluster in an active/passive cluster, or a multiple instance configuration. The site database site system role is the only System Center 2012 Configuration Manager site system role supported on an instance of a Windows Server cluster. If you use a SQL Server cluster for the site database, you must add the computer account of the site server to the Local Administrators group of each Windows Server cluster node computer. Note SQL Server database mirroring is not supported for the Configuration Manager site database. http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig Quote Share this post Link to post Share on other sites More sharing options...
NIGHTCD Posted April 27, 2012 Report post Posted April 27, 2012 Hello. thanks for the reply, i have managed to fix muliple errors. but i have one error left. - Required SQL Server Collation this error is probably releated to the SMS Provider? (that can not be installed on the SQL Server Cluster) anyone have a solutions to this? NIGHTCD Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted April 27, 2012 Report post Posted April 27, 2012 thanks for the reply, i have managed to fix muliple errors. how, please post so that others will learn as regards your collation did you see this post yet ? 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...
NIGHTCD Posted April 27, 2012 Report post Posted April 27, 2012 hello. thanks for the reply.. the only problem is that when i run the checks before install this problem occurs because it is pointing to the SCCM server and not the SQL server... so my question is if this is comming from the step when i where i provided the SMS Provider under the installation step.. NIGHTCD Quote Share this post Link to post Share on other sites More sharing options...
NIGHTCD Posted April 27, 2012 Report post Posted April 27, 2012 Do i need to have SQL server on the machine that shall host the SMS Provider? Quote Share this post Link to post Share on other sites More sharing options...
NIGHTCD Posted May 4, 2012 Report post Posted May 4, 2012 Anyone? Quote Share this post Link to post Share on other sites More sharing options...
Ajay Posted June 30, 2013 Report post Posted June 30, 2013 No.. SMS provider can be on any other server(preferably site server).. but definitely out side the cluster.. Quote Share this post Link to post Share on other sites More sharing options...
