SCCM 2012 Install - Can't connect to SQL

[jt65]

I am trying to install SCCM 2012 in my lab so I can test the upgrade from SCCM 2007. My server is Windows 2008 x64 R2 with SP1, and I've installed SQL 2008 x64 R2 Standard with SP1 and CU6 and configured a named instance.

 

When I run the system assessment, I get the following errors/warnings:

 

1. SQL Server service running account.

2. Verify site server permissions to publish to Active Directory

3. Required SQL Server Collation

4. SQL Server sysadmin rights

 

I think these are all bogus. My SQL services are using an AD user account, I have verified that my server account has full control of the System Management container AND descendent objects (that one has burned me more than once), I am using the SQL _Latin1_General_CP1_CI_AS collation, and Iam using my account to install SCCM and I know that I am a sysadmin. I fiddled around with these for a while and then assumed it was because I was using a named instance, so the assessment tool didn't know where to connect to test SQL.

 

I mention this all because when the SCCM installation tried to connect to SQL, it fails.

 

I receive an error stating "Setup is unable to connect to SQL Server with the connection information provided.

 

I have verified that I have entered the information correctly I ahve verified that my instance is not using dynamic ports. It's using 1433. I don't have a firewall, and I know that my account has sufficient permissions within SQL. I opened the SQL Management Studio and created a database just to make sure.

 

I CAN use a named instance with SCCM 2012, can't I? Or am I way off base with thinking it's my named instance?

[RButler]

I ran into this at a customer who had a similar setup. I ended up having to perform an unattended install of the SCCM primary site server.

• First I created a basic Setup.ini file with the following content:
  
  • [identification]
    
  • Action=InstallPrimarySite
    
  • [Options]
    
  • ProductID=<XXXXX-XXXXX-XXXXX-XXXXX-XXXXX or Eval>
    
  • SiteCode=<YourSiteCode>
    
  • SiteName=<YourSiteName>
    
  • SMSInstallDir=D: \Microsoft Configuration Manager
    
  • SDKServer=<FQDNofSiteServer>
    
  • PrerequisiteComp=1
    
  • PrerequisitePath=D:\Microsoft Configuration Manager\Updates\RTM
    
  • AdminConsole=1
    
  • JoinCEIP=0
    
  • RoleCommunicationProtocol=HTTPorHTTPS
    
  • ClientsUsePKICertificate=0
    
  • AddServerLanguages=
    
  • AddClientLanguages=
    
  • DeleteServerLanguages=
    
  • [sqlConfigOptions]
    
  • SQLServerName=<FQDNofYourSQLServer>
    
  • DatabaseName=<SQLServerName\<SQLInstanceName>
    
  • SQLSSBPort=4022
    

  [*]Next I ran Setup.exe /Script D:\SourceFiles\Setup.ini

  [*]Finally using the CMTrace.exe tool I monitored the C:\ConfigMgrSetup.log

More details on the ini file can be found here: http://technet.microsoft.com/library/gg712320.aspx#BKMK_CommandLineOptions

Hope this helps.

-Robert