Error when installing SCCM 2012 even when following guides!!

[amitpatel08]

Hi

 

I wonder if anyone can help with an issue installing SCCM 2012. I have installed all pre reqs and SQL Server 2008 SP2 CU9, with a default SQL Server instance.

 

When doing the install i am getting the error:

 

"Setup failed to configure SQL Service Broker. Possible cause: Each Configuration Manager site must have its own SQL Server instance. Verify that the SQL Server instance is not in use by another Configuration Manager site."

 

This happens during the: Configuring Data Replication Service.

 

I have confirmed that SQL Server 2008 was the only install of SQL Server on the machine.

 

I don't have the logs at the moment. I can post them later.

 

Anyone have any ideas?

[anyweb]

where are you seeing that error ? in the logs or in the setup installation console, can you post the ConfigMgrSetup.log file here please ? did you add the installation account (SMSadmin) as a sysadmin on your sql server as described below ?

 

SQL Server security

 

You will also want to think about what security to grant your users, Grant the Server2008r2\Smsadmin the SQL server sysadmin role by adding the user to the SQL server security Logins (do this by logging on to the server as a local administrator in SQL Server Enterprise). See the below screenshot.

 

[amitpatel08]

Hi Anyweb

 

I saw that error in the install console. Also, i did not add the installation account as a sysadmin in SQL Server. Pardon my ignorance but i am not a DBA/SQL expert, but would this pose a major problem.

 

I will post the log as soon as i can. I think there was an error regarding the SQL Server Native Client and the Broker Service.

 

Any other ideas until i post the log?

[amitpatel08]

Hi

 

Please find the log file that you shed some light into this issue:

 

Can any out there help?

 

 

INFO: 'ECH-EXCHSRV02.middx.com' is a valid FQDN. Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: SQL Connection succeeded. Connection: ECH-EXCHSRV02.MIDDX.COM MASTER, Type: Secure Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: Registered type SMS_ACCESS for ECH-EXCHSRV02.middx.com CM_NAS Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: SQL Connection succeeded. Connection: SMS_ACCESS, Type: Secure Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: Registered type SMS_ACCESS for ECH-EXCHSRV02.middx.com CM_NAS Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: SQL Connection succeeded. Connection: SMS_ACCESS, Type: Secure Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: Registered type SMS_ACCESS for ECH-EXCHSRV02.middx.com CM_NAS Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: SQL Connection succeeded. Connection: SMS_ACCESS, Type: Secure Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: Configuring SQL Server service broker... Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure Configuration Manager Setup 20/04/2001 08:08:25 4732 (0x127C)

*** [42000][28055][Microsoft]

[sql Server]The certificate 'ConfigMgrEndpointCert' is not valid for endpoint authentication. The certificate must have a private key encrypted with the database master key and current UTC date has to be between the certificate start date and the certificate expiration date. Configuration Manager Setup 20/04/2001 08:08:26 4732 (0x127C)

ERROR: SQL Server error: [42000][28055][Microsoft][sql Server Native Client 10.0][sql Server]The certificate 'ConfigMgrEndpointCert' is not valid for endpoint authentication. The certificate must have a private key encrypted with the database master key and current UTC date has to be between the certificate start date and the certificate expiration date. Configuration Manager Setup 20/04/2001 08:08:26 4732 (0x127C)

ERROR: Failed to execute spConfigureServiceBroker Configuration Manager Setup 20/04/2001 08:08:26 4732 (0x127C)

~===================== Completed Configuration Manager 2012 Server Setup ===================== Configuration Manager Setup 20/04/2001 08:08:26 4732 (0x127C)

<04-20-2001 08:14:01> ***************************************************** 01/01/1601 00:00:00 1991596907 (0x76B55B6B)

<04-20-2001 08:14:01> ***** Exiting ConfigMgr 2012 Setup Bootstrapper ***** 01/01/1601 00:00:00 1991596907 (0x76B55B6B)

<04-20-2001 08:14:01> ***************************************************** 01/01/1601 00:00:00 1991596907 (0x76B55B6B)

[amitpatel08]

I have resolved my issue. I must have been blind, it is clearly in the logs:

 

The certificate must have a private key encrypted with the database master key and current UTC date has to be between the certificate start date and the certificate expiration date. Configuration Manager Setup 20/04/2001 08:08:26 4732 (0x127C)

 

The date on the Server was incorrect. DOH!!

 

Fixed the date and that fixed the problem.

 

Thanks for your help.

[anyweb]

thanks for posting the resolution ! and good luck with the rest of it

[Stephan van der Plas]

Hello all,

 

I have exactly the same error, during update to SP1. In my case there is no time issue.

 

In the configmgrsetup.log, I see the following:

 

 

INFO: Creating local group ConfigMgr_DViewAccess on SQL-DB002.insourceict.local for distributed view access. Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

INFO: DRS components are installed and configured. Configuration Manager Setup 1-1-1601 0:00:00 2944 (0x0B80)

Call NetLocalGroupAdd on server <\\SQL-DB002.insourceict.local> Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

INFO: Registered type SMS_ACCESS for SQL-DB002.insourceict.local iictsqldb002\CM_P00 Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

INFO: SQL Connection succeeded. Connection: SMS_ACCESS, Type: Secure Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

*** IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name='SRVP00-025\ConfigMgr_DViewAccess') BEGIN CREATE LOGIN [sRVP00-025\ConfigMgr_DViewAccess] FROM WINDOWS END Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

*** [42000][15025][Microsoft]

[sql Server]The server principal 'SRVP00-025\ConfigMgr_DViewAccess' already exists. Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

ERROR: SQL Server error: [42000][15025][Microsoft][sql Server Native Client 11.0][sql Server]The server principal 'SRVP00-025\ConfigMgr_DViewAccess' already exists. Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

INFO: Executing SQL Server command: <IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name='SRVP00-025\ConfigMgr_DViewAccess') BEGIN CREATE LOGIN [sRVP00-025\ConfigMgr_DViewAccess] FROM WINDOWS END> Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

ERROR: ExecuteSqlCommand failed to execute IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name='SRVP00-025\ConfigMgr_DViewAccess') BEGIN CREATE LOGIN [sRVP00-025\ConfigMgr_DViewAccess] FROM WINDOWS END, SQL error <> Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

ERROR: Failed to create group for distributed view access. Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

~===================== Failed Configuration Manager 2012 Server Setup - Upgrade ===================== Configuration Manager Setup 1-1-1601 0:00:00 3304 (0x0CE8)

The SQL instance is SQL-DB002 clustered on 2 windows server 2008 R2 machines (SRV-002 and SRV-025). Is that the source of the issue?