error during installation

[louwie]

During installation I receive an error:

 

 

ConfigMgrSettupWizard.log shows:

 

7-11-2012 11:30:39: ConfigMgrSetupWizard Verbose: 1 : Report progress callback. Progress stage: 50, Progress state: 0.

7-11-2012 11:30:39: ConfigMgrSetupWizard Verbose: 1 : Received setup progress [Evaluating setup environment] from native code.

7-11-2012 11:30:41: ConfigMgrSetupWizard Verbose: 1 : Report failure callback. Failure: 103.

7-11-2012 11:30:41: ConfigMgrSetupWizard Information: 1 : Cancelling asynchronous threads...

7-11-2012 11:30:41: ConfigMgrSetupWizard Information: 1 : Notified monitoring threads to exit.

7-11-2012 11:30:41: ConfigMgrSetupWizard Information: 1 : All monitoring threads have completed.

7-11-2012 11:30:41: ConfigMgrSetupWizard Information: 1 : Released callback GC handle

7-11-2012 11:30:41: ConfigMgrSetupWizard Verbose: 1 : Received error [Could not connect or execute SQL query.] from native code.

7-11-2012 11:30:41: ConfigMgrSetupWizard Verbose: 1 : Completed the site installation thread.

 

ConfigMgrSetup.log shows:

 

 

INFO: SCCMACC01.test.local is a 64 bit operating system. Configuration Manager Setup 7-11-2012 11:30:10 896 (0x0380)

~===================== << Starting Configuration Manager 2012 Setup >> ===================== Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: ConfigMgr2012 Setup was started by local\sccm. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Command line specified was: "D:\Temp\sourceSCCM\SMSSETUP\BIN\X64\SetupWpf.exe" Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

FQDN for server SCCMACC01 is SCCMACC01.test.local Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Target computer is a 64 bit operating system. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Checking for existing setup information. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Checking for existing SQL information. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Verifying the registry entry for Asset Intelligence installation Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Setting the default CSV folder path Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: No language packs detected. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Configuration Manager Build Number = 7711 Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Configuration Manager Version = 5.0 Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Configuration Manager Minimum Build Number = 800 Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Verifying Configuration Manager Active Directory Schema Extensions. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Found DS Root:CN=Schema,CN=Configuration,DC=local,dc=local Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Verifying Configuration Manager Active Directory Schema Extensions. Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Found DS Root:CN=Schema,CN=Configuration,DC=local,dc=local Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: Validating characters in path from Apps\Microsoft Configuration Manager Configuration Manager Setup 7-11-2012 11:30:39 1904 (0x0770)

INFO: VL or OEM Product Key was specified. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: Installing Full version. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: 'sccmacc01.test.local' is a valid FQDN. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: 'sccmacc01.test.local' is a valid FQDN. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

ERROR: Failed to connect to registry to determine if Configuration Manager console is installed. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: 'sqlserver.test.local' is a valid FQDN. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: This is a named instance SQL Server. Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: SQL Server instance name (pSetupInf->SqlInstName): sccm Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: SQL Server master database (pSetupInf->SqlMasterDB): sccm\master Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: Site SQL Server database name (pSetupInf->SqlDatabaseName): sccm\CM_A01 Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

INFO: Site SQL Server computer name (pSetupInf->SqlServer): sqlserver.test.local Configuration Manager Setup 7-11-2012 11:30:40 1904 (0x0770)

~===================== Failed Configuration Manager 2012 Server Setup ===================== Configuration Manager Setup 7-11-2012 11:30:41 1904 (0x0770)

 

(domain name and netbios names changed)

 

Installation account has the sysadmin role on the sql server and the computeraccount also.

 

Sql server is a remote computer SQL server 2008 R2 with sp2

 

Can anyone help me?

[anyweb]

is the installation account a local admin on the sql server ?

[louwie]

Yes it is, the installation domain account is a member of the local admin group on the appl server and also on the remote sql server. Even the computeraccount is a member off the local admin group and added in the sql management studio to the sccm instance and has the sysadmin role.

[louwie]

problem fixed; settings in tcp/ip properties of the sql instance service. ip1, ip2, ip3 and ipall all set to enabled and filled in the tcp port.

 

another question: installation account and computeraccount are member of the local admin group. When the installation is finished, are these rights still necessary?

[sxleilong]

problem fixed; settings in tcp/ip properties of the sql instance service. ip1, ip2, ip3 and ipall all set to enabled and filled in the tcp port.

 

another question: installation account and computeraccount are member of the local admin group. When the installation is finished, are these rights still necessary?

 

Hi

Just open IP2 and IP4 will be work well~