Jump to content


  • 0
jt65

SCCM 2012 Install - Can't connect to SQL

Question

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?

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.