Solved

Problems installing SCCM 2012

Posted on 2013-05-15
8
2,281 Views
Last Modified: 2013-05-28
I have been trying on and off the past couple of days to get SCCM 2012 to install in my small environment (50 systems). I have resolved all of the prerequisites except for those in regards to SQL. I'm getting the following (my attempts to resolve the issues are bold):

The logon account for the SQL Server service cannot be a local user account or LOCAL SERVICE.  You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.
The instance of SQL has been set to run as domain\sccm (service account), but error still shows up.


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.
I've confirmed through multiple installs of SQL 2008 R2 that the proper collation is used

Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance selected for site database installation, or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue.
During the install of SQL 2008 R2 I specified the computer account (domain\SCCM$) and domain\sccm (service account) have sysadmin rights

I thought that it might have to do with the version of SQL I'm using, say lacking a CU. I'm running SQL 2008 R2 10.50.4000 which I believe equates to 20008 R2 w/SP2 and no CU. This is a supported version according to here:http://technet.microsoft.com/en-us/library/gg682077.aspx

Any ideas what the problem could be?
0
Comment
Question by:futureman0
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39170485
SCCM would need the prescribed version. No use trying without it.

Please upload the logs in the root of c:\ for SCCM server here. (prereq etc)
0
 

Author Comment

by:futureman0
ID: 39171204
See Attached

I thought I was using an supported version of SQL - SQL 2008 R2 W/SP2 and no CU
PreReq.txt
0
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39171458
CUs are needed.

http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLSrvReq


The following table lists the SQL Server versions that are supported by System Center 2012 Configuration Manager.
 
SQL Server version       

SQL Server 2008

    Standard1

    Enterprise

    Datacenter

      

SP2
      

Minimum of cumulative update 9
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:futureman0
ID: 39171483
CU 9 is for SQL 2008 SP2, I have installed SQL 2008 R2 SP2
0
 

Author Comment

by:futureman0
ID: 39188922
Perhaps the issue is related to running SQL Express, can someone point me to the trial version of SQL 2008 R2 standard that will work with SCCM 2012?
0
 
LVL 4

Accepted Solution

by:
rlog earned 500 total points
ID: 39189965
In your output file "ERROR: Failed to connect to SQL Server database" is mentioned. I believe your connection string to the database server is the problem here. Please specify servername,port (use comma) to connect directly to sql server. You should not use dynamically set port for your server. Check also that SQL Browser replies (and that the fw port is open (udp 1434).
0
 

Author Comment

by:futureman0
ID: 39201197
I think what might have caused the issue was the SQL Browser service was set to disabled. Once I enabled it, re-verified what @rlog said to check, I was able to get SCCM installed.

Interesting enough, the "Assess server readiness" on the splash screen still fails with the same error - but going through the install process doesn't show any errors.
0
 
LVL 4

Expert Comment

by:rlog
ID: 39202448
As a general rule the sql browser is not enabled on dedicated systems. If your sccm database runs on a dedicated server I would set a fixed non-default port and specify the port in the connection string. On a general server where you host a number of different databases it's ok to run the sql browser on the server.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There’s a movement in Information Technology (IT), and while it’s hard to define, it is gaining momentum. Some call it “stream-lined IT;” others call it “thin-model IT.”
We take a look at some of the most common obstacles that IT teams run into as they work relentlessly to keep all the alarms and sirens from going off at once.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question