Home > MS Technologies, SCCM > SCCM 2012 : “A communication error has been detected between the specified site system and the site database computer”

SCCM 2012 : “A communication error has been detected between the specified site system and the site database computer”


Hi,

Currently, I am working on an important System Center project. During SCCM 2012 installation, I have encountered this error in the pre requisites checking step :

“Site System to SQL Server Communication;    Warning;    A communication error has been detected between the specified site system and the site database computer. This error can occur when the site database server is offline or if a valid SPN has not been registered in Active Directory Domain Services for the SQL Server instance hosting the site database. Setup cannot continue.”

In my case, the database server is hosted on a remote server. I have done all the necessary configurations. But this error occurred. I have applied consequently the suggestion of registering the SPN of the SQL instance. That did not solve my issue. Don’t forget of course to fix the SQL communication ports, because the dynamic ports when you have more than one instance cause many problems.

So I consulted the log file to analyze the issue and surprise ! I got these wonderful lines :

<09-16-2012 15:27:25> ERROR: Connected to SQL Server but failed to execute query IF NOT EXISTS (select * from master.sys.server_principals where name=’DOMAIN\SCCMCOMPUTERACCOUNT$’) BEGIN CREATE LOGIN [DOMAIN\SCCMCOMPUTERACCOUNT$] FROM WINDOWS; SELECT 1; END ELSE SELECT 0
<09-16-2012 15:27:25> save to ini file SQLCONNECT:DatabaseServerAccount\cmsql.
<09-16-2012 15:27:31> ERROR: Failed to connect to SQL Server SCCMCOMPUTERName.

So I have verified the logins section in my SQL Server and really the account was not created. What’s the matter?

To understand the issue, try to execute the T-SQL query and bingo! this account cannot be retrieved and verified.

In my case, the NetBios domain name is different from the domain name without DNS suffix. The wizard detects the domain name and simply extracts the NetBios name by removing the DNS suffix like .com for example.

Let us suppose that your domain name is CONTOSO.COM. the SCCM wizard just extracts CONTOSO and considers it as the NetBios name, even it is different. After that, an account name is generated for your SCCM computer account using the extracted NetBios name. if the real NetBios name is different so the generated account is false and does not exist.

What to do?

Simply execute the SQL request by putting the real account name. you will notice that the request is executed successfully. Don’t attribute privileges, the wizard does it for you.

Now, when you relaunch the wizard the error sill exists but don’t worry, you can continue without any problem.

You will also have the following AD container errors even you have configured the necessary settings :

<09-16-2012 15:27:14> ERROR: Site server does not have create child permission on AD ‘System Management’
<09-16-2012 15:27:14> WARN: Site server does not have delete child permission on AD ‘System Management’
<09-16-2012 15:27:16> SCCMComputerName; Verify site server permissions to publish to Active Directory.; Warning; The site server might be unable to publish to Active Directory. The computer account for the site server must have Full Control permissions to the System Management container in its Active Directory domain. You can ignore this warning if you have manually verified these permissions. For more information about your options to configure required permissions, see http://go.microsoft.com/fwlink/p/?LinkId=233190.

Don’t worry, the error is due to the same reason and you can install the SCCM without any problem.

After installation please check your SQL server to verify the database creation and that the account you have created previously is attributed the right rights. Please check also the System management container in the AD and verify the information publication.

Advertisements
Categories: MS Technologies, SCCM Tags:
  1. May 26, 2013 at 8:56 am

    Howdy very nice web site!! Man .. Excellent .
    . Superb .. I’ll bookmark your web site and take the feeds also? I’m satisfied to seek out numerous useful information right here in the publish, we
    need develop extra techniques on this regard, thank
    you for sharing. . . . . .

  2. August 10, 2014 at 4:16 pm

    Hello colleagues, its impressive post about cultureand completely explained, keep
    it up all the time.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: