Secondary Site Install Fails during Prereq check

All replies

• 

  

  0

  Sign in to vote

  i have install SCCM 2012  with CU1 and later to CU2 with SQL 2008 R2 which is workign fine. now i am trying to install a secondary site and it is failing at the prerequisite "[Failed]:Setup is unable to verify that the Server Service is started." the ConfigMgrsetup log is below

  INFO: Attempting to   load resource DLL... INFO: Registered type   hysite.mticontoso.com MASTER for hysite.mticontoso.com master INFO: Registered type SMS Master for   hysite.mticontoso.com master INFO: Registered type   hysite.mticontoso.com CM_CHK for hysite.mticontoso.com CM_CHK INFO: Registered type SMS ACCESS for   hysite.mticontoso.com CM_CHK INFO: Prerequisite rules for secondary   site fresh installation are being run. INFO: File   C:\Windows\sms_account_test_svc.exe does not exist. No zapping needed. INFO: File   \\hysite.mticontoso.com\admin$\sms_lanman_test_svc.exe does not exist. No   zapping needed. INFO: File   \\hysite.mticontoso.com\admin$\sms_lanman_test_svc.exe does not exist. No   zapping needed. CWmiRegistry::WmiOpen: Failed to read key   SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL on   hysite.mticontoso.com CWmiRegistry::WmiOpen: Failed to read key   SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL on   hysite.mticontoso.com CWmiRegistry::GetValues: Failed to get   values from SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL CWmiRegistry::GetValues: Failed to   connect to registry on machine hysite.mticontoso.com. Error code: 2 CWmiRegistry::WmiOpen: Failed to read key   SOFTWARE\Microsoft\SMS on hysite.mticontoso.com CWmiRegistry::WmiOpen: Failed to read key   SOFTWARE\Policies\Microsoft\WindowsFirewall\DomainProfile on   hysite.mticontoso.com CWmiRegistry::GetDWORD: Failed to get   DWORD value DoNotAllowExceptions CWmiRegistry::GetDWORD: Failed to get   DWORD value DefaultInboundAction CWmiRegistry::GetDWORD: Failed to get   DWORD value DefaultOutboundAction CWmiRegistry::WmiOpen: Failed to read key   SOFTWARE\Policies\Microsoft\WindowsFirewall\FirewallRules on   hysite.mticontoso.com CWmiRegistry::GetValues: Failed to get   values from SOFTWARE\Policies\Microsoft\WindowsFirewall\FirewallRules CWmiRegistry::GetValues: Failed to   connect to registry on machine hysite.mticontoso.com. Error code: 2 INFO: File   \\hysite.mticontoso.com\admin$\sms_get_ADPERMS_svc.exe does not exist. No   zapping needed. INFO: File   \\hysite.mticontoso.com\admin$\sms_get_ADPERMS_svc.exe does not exist. No   zapping needed. INFO: File   C:\Windows\sms_wmi_test_svc.exe does not exist. No zapping needed. INFO: hysite.mticontoso.com is a 64 bit   operating system.

  i verified the server service whics is started and is using local system account. Secondary server is in local admin group of my primary server. The system management contain does exist and added secondary site with full control.

  as of now i followed the steps in this link http://microsoftteched.com/2012/04/24/how-to-install-sccm-2012-secondary-site/ Please let me know where i am going wrong. -Vrkumar01

  ---

  
  The account of the primary site server has to be member of the admins on the secondary.
  No need to install CU1 and CU2 (it's *cumulative*!); install SP1 (and CU1 for SP1 instead).
  

  ---

  Torsten Meringer | http://www.mssccmfaq.de

  
  

  • Edited by TorstenMMVP Wednesday, March 27, 2013 3:32 PM

  Wednesday, March 27, 2013 3:31 PM
• 

  

  0

  Sign in to vote

  how did you run the prereq check?

  ---

  Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals

  Wednesday, March 27, 2013 3:37 PM
• 

  

  0

  Sign in to vote

  Yes it is already been a member of secondary server.

  -Vrkumar01

  ---

  RajKumar

  Wednesday, March 27, 2013 4:07 PM
• 

  

  0

  Sign in to vote

  Thanks for the reply Kent

  As mentioned in your blog http://blog.coretech.dk/kea/installing-a-secondary-site-in-system-center-2012-configuration-manager/ i followed the same steps to for the prereq check and it passed with out any errors. and here is the link and the log output.

  ConfigMgrPrereq.log on the secondary site server.

  <03-27-2013   21:42:38> ********************************************

  <03-27-2013 21:42:38> ******* Start Prerequisite checking. *******

  <03-27-2013 21:42:38>   ********************************************

  <03-27-2013 21:42:38> Commandline   :

  prereqchk.exe  /SEC hysite.mticontoso.com   /INSTALLSQLEXPRESS /Ssbport 4022 /Sqlport 1433

  <03-27-2013 21:42:38> Check Type:   Secondary site

  Site Server: hysite.mticontoso.com,

  SQL Server: hysite.mticontoso.com,

  SQL Named Instance: ,

  Install Folder: ,

  Setup Source Folder:

  <03-27-2013 21:42:38>   ********************************************

  <03-27-2013 21:42:38> *******   Start Prerequisite checking. *******

  <03-27-2013 21:42:38>   ********************************************

  <03-27-2013 21:43:39> INFO:   Executing prerequisite functions...

  <03-27-2013 21:43:39> ===== INFO:   Prerequisite Type & Server: SITE_SEC:hysite.mticontoso.com =====

  <03-27-2013 21:43:39>   <<<RuleCategory: Access Permissions>>>

  <03-27-2013 21:43:39>   <<<CategoryDesc: Checking access permissions...>>>

  <03-27-2013 21:43:39>   hysite.mticontoso.com;      Administrative rights on site system;    Passed

  <03-27-2013 21:43:39> INFO:   CheckLocalSys is Admin of <hysite.mticontoso.com>.

  <03-27-2013 21:43:39>   hysite.mticontoso.com;    Site server   computer account administrative rights;      Passed

  <03-27-2013 21:43:39>   INFO:CheckSiteSystemtoSQLConnectivity <hysite.mticontoso.com>

  <03-27-2013 21:43:39> INFO:   Installing SQL Server Express, skipping SQL Server connectivity check.

  <03-27-2013 21:43:39>   hysite.mticontoso.com;    Site System   to SQL Server Communication;    Passed

  <03-27-2013 21:43:39>   <<<RuleCategory: System Requirements>>>

  <03-27-2013 21:43:39>   <<<CategoryDesc: Checking system requirements for   ConfigMgr...>>>

  <03-27-2013 21:43:39> INFO: Check   Lanman service: <hysite.mticontoso.com>.

  <03-27-2013 21:43:45> INFO:lanman   test loop count:11.

  <03-27-2013 21:43:45> INFO: lanman   Return result <1>

  <03-27-2013 21:43:47>   hysite.mticontoso.com;    Check Server   Service is running;    Passed

  <03-27-2013 21:43:47> INFO: Target   computer is a Windows server.

  <03-27-2013 21:43:47>   hysite.mticontoso.com;    Unsupported   site server operating system version for Setup;    Passed

  <03-27-2013 21:43:47>   hysite.mticontoso.com;    Domain   membership;    Passed

  <03-27-2013 21:43:47> INFO: Using   default system drive.

  <03-27-2013 21:43:48> INFO: Free   disk space on target C:\. = 81060 MB

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Free disk   space on site server;    Passed

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Pending   system restart;    Passed

  <03-27-2013 21:43:48>   <<<RuleCategory: Dependent Components>>>

  <03-27-2013 21:43:48>   <<<CategoryDesc: Checking dependent components for   ConfigMgr...>>>

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Microsoft XML   Core Services 6.0 (MSXML60);    Passed

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Microsoft   Remote Differential Compression (RDC) library registered;    Passed

  <03-27-2013 21:43:48> INFO:   Checking Windows Installer version on hysite.mticontoso.com.

  <03-27-2013 21:43:48> INFO: Path   of Windows Installer is <C:\Windows\system32\msi.dll>.

  <03-27-2013 21:43:48> INFO:   Msi.dll version is: <5.0.7600.16992> .

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Microsoft   Windows Installer;    Passed

  <03-27-2013 21:43:48> INFO: Start   Checking InstallSQLExpress on site server: hysite.mticontoso.com, SQL Server   instance CONFIGMGRSEC

  <03-27-2013 21:43:48> INFO: SQL   Server Instance Names key was not found

  <03-27-2013 21:43:48> INFO:   IsPortUsedByAnySqlInstance port 1433.

  <03-27-2013 21:43:48> INFO: SQL   Server Instance Names key was not found

  <03-27-2013 21:43:48> INFO: TCP   port 1433 is not in use by any other SQL Server instances.

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    SQL Server on   Secondary Site;    Passed

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Existing   Configuration Manager server components on secondary site server;    Passed

  <03-27-2013 21:43:48> INFO:   Stand-alone primary site. Skip checking firewall settings for SQL Server

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Firewall   exception for SQL Server;    Passed

  <03-27-2013 21:43:48> INFO: SQL   Server computer <hysite.mticontoso.com>

  <03-27-2013 21:43:48> INFO: SQL   Server named instance <>

  <03-27-2013 21:43:48> INFO:   Install SQL Server Express on secondary site, skip checking.

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    SQL Server   service running account;    Passed

  <03-27-2013 21:43:48> INFO: SQL   Server computer <hysite.mticontoso.com>

  <03-27-2013 21:43:48> INFO: SQL   Server named instance <>

  <03-27-2013 21:43:48> INFO:   Install SQL Server Express on secondary site, skip checking.

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Dedicated SQL   Server instance;    Passed

  <03-27-2013 21:43:48> INFO:   CheckSQLCollationSecondary

  <03-27-2013 21:43:48> INFO:   Installing SQL Server Express; skipping

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Parent/child   database collation;    Passed

  <03-27-2013 21:43:48> INFO:   Checking .NET framework versions 3.5...

  <03-27-2013 21:43:48> INFO: .NET   is installed

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Minimum .NET   Framework version for Configuration Manager site server;    Passed

  <03-27-2013 21:43:48> INFO:   CheckInstallSourceVersion <>

  <03-27-2013 21:43:48> INFO: Setup   Source Directory not specified. Version must be correct since we use the   primary's binaries as the source.

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Setup Source   Version;    Passed

  <03-27-2013 21:43:48>   INFO:CheckInstallSourcePath <hysite.mticontoso.com>

  <03-27-2013 21:43:48> INFO: Setup   Source Directory not specified.

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Setup Source   Folder;    Passed

  <03-27-2013 21:43:48> INFO: Enter   CheckSecSiteSqlOnSameMachine.

  <03-27-2013 21:43:48> INFO:   Installing SQL Server Express, skipping SQL Server check.

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    SQL Server on   the Secondary Site Computer;    Passed

  <03-27-2013 21:43:48>   INFO:CheckSupportedFQDNFormat <hysite.mticontoso.com>

  <03-27-2013 21:43:48> INFO:   NetBIOS <HYSITE10>

  <03-27-2013 21:43:48> INFO: FQDN   <hysite.mticontoso.com>

  <03-27-2013 21:43:48>   hysite.mticontoso.com;    Primary   FQDN;    Passed

  <03-27-2013 21:43:54> INFO:get   ADPERMS test loop count:11.

  <03-27-2013 21:43:54> INFO:   SMS_GET_ADPERMS_SERVICE Return result <7>

  <03-27-2013 21:43:54> INFO: site   server has access permission to AD

  <03-27-2013 21:43:56>   hysite.mticontoso.com;    Verify site   server permissions to publish to Active Directory.;    Passed

  <03-27-2013 21:44:01> INFO:test   wmi loop count:5.

  <03-27-2013 21:44:01> INFO:   SMS_WMI_TEST_SERVICE exit loop at 5.

  <03-27-2013 21:44:01> INFO:   SMS_WMI_TEST_SERVICE Return result <0>

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    Remote   Connection to WMI on Secondary Site;      Passed

  <03-27-2013 21:44:03> INFO: Check   required collation of Sql Server.

  <03-27-2013 21:44:03> INFO: LangID   <409>

  <03-27-2013 21:44:03> INFO:   Installing SQL Server Express, skipping check for reqired collation of SQL   Server.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    Required SQL   Server Collation;    Passed

  <03-27-2013 21:44:03> ===== INFO:   Prerequisite Type & Server: SQL:hysite.mticontoso.com =====

  <03-27-2013 21:44:03>   <<<RuleCategory: Access Permissions>>>

  <03-27-2013 21:44:03>   <<<CategoryDesc: Checking access permissions...>>>

  <03-27-2013 21:44:03> INFO:   Skipping check for sysadmin role on SQL Server or SQL Express for Secondary   site server.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    SQL Server   sysadmin rights;    Passed

  <03-27-2013 21:44:03> INFO: The   rule 'Site server computer account administrative rights' has been run on   server 'hysite.mticontoso.com', skipped.

  <03-27-2013 21:44:03> INFO:   Installing SQL Server Express, skipping Windows integrated security check.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    SQL Server   security mode;    Passed

  <03-27-2013 21:44:03>   <<<RuleCategory: System Requirements>>>

  <03-27-2013 21:44:03>   <<<CategoryDesc: Checking system requirements for   ConfigMgr...>>>

  <03-27-2013 21:44:03> INFO: The   rule 'Domain membership' has been run on server 'hysite.mticontoso.com',   skipped.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    Check SQL   Agent Logon;    Passed

  <03-27-2013 21:44:03> INFO:   Secondary site,  skip checking for SQL   Server agent enabled.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    Check SQL   Agent service status;    Passed

  <03-27-2013 21:44:03> INFO: The   rule 'Pending system restart' has been run on server 'hysite.mticontoso.com',   skipped.

  <03-27-2013 21:44:03>   <<<RuleCategory: Dependent Components>>>

  <03-27-2013 21:44:03>   <<<CategoryDesc: Checking dependent components for   ConfigMgr...>>>

  <03-27-2013 21:44:03> INFO:   Installing SQL Server Express, skipping SQL Server version check.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    SQL Server   version;    Passed

  <03-27-2013 21:44:03> INFO:   Checking if SQL Server memory is limited.

  <03-27-2013 21:44:03> INFO:   Installing SQL Server Express, skipping SQL Server memory check.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    Configuration   for SQL Server memory usage;    Passed

  <03-27-2013 21:44:03> INFO:   Checking if SQL Server memory is configured to reserve minimum memory.

  <03-27-2013 21:44:03> INFO:   Installing SQL Server Express, skipping SQL Server memory allocation check.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    SQL Server   process memory allocation;    Passed

  <03-27-2013 21:44:03> INFO:   Installing SQL Server Express, skipping SQL Server case insensitive   validation.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;      Case-insensitive collation on SQL Server;    Passed

  <03-27-2013 21:44:03> INFO: Check   Machine FQDN: <hysite.mticontoso.com>.

  <03-27-2013 21:44:03> INFO:   getaddrinfo returned success.

  <03-27-2013 21:44:03>   hysite.mticontoso.com;    Validate FQDN   of SQL Server Computer;    Passed

  <03-27-2013 21:44:03> INFO: The   rule 'Primary FQDN' has been run on server 'hysite.mticontoso.com', skipped.

  <03-27-2013 21:44:03>   ***************************************************

  <03-27-2013 21:44:03> *******   Prerequisite checking is completed. *******

  <03-27-2013 21:44:03>   ***************************************************

  <03-27-2013 21:44:03> INFO:   Updating Prerequisite checking result into the registry

  <03-27-2013 21:44:03> INFO:   Connecting to hysite.mticontoso.com registry

  <03-27-2013 21:44:03> INFO:   Setting registry values

  -vrkumar01

  ---

  RajKumar

  Wednesday, March 27, 2013 4:20 PM
• 

  

  0

  Sign in to vote

  To add to the above on the secondary site server ConfigMgrSetup.log

  INFO: Attempting   to load resource DLL...

  INFO: Registered type   hysite.mticontoso.com MASTER for hysite.mticontoso.com master

  INFO: Registered type SMS Master for   hysite.mticontoso.com master

  INFO: Registered type   hysite.mticontoso.com CM_CHK for hysite.mticontoso.com CM_CHK

  INFO: Registered type SMS ACCESS for   hysite.mticontoso.com CM_CHK

  INFO: Attempting to load resource DLL...

  *** [08001][17][Microsoft][ODBC SQL   Server Driver][Shared Memory]SQL Server does not exist or access denied.

  *** [01000][2][Microsoft][ODBC SQL Server   Driver][Shared Memory]ConnectionOpen (Connect()).

  *** Failed to connect to the SQL Server.

  ERROR: Failed to connect to SQL Server   'master' db.

  ERROR: Failed to determine if SQL Server   hysite.mticontoso.com is clustered.

  INFO: Prerequisite rules for secondary   site fresh installation are being run.

  INFO: File   \\hysite.mticontoso.com\admin$\sms_lanman_test_svc.exe does not exist. No   zapping needed.

  INFO: File   \\hysite.mticontoso.com\admin$\sms_get_ADPERMS_svc.exe does not exist. No   zapping needed.

  INFO: File   C:\Windows\sms_wmi_test_svc.exe does not exist. No zapping needed.

  INFO: hysite.mticontoso.com is a 64 bit   operating system.

  +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

  On the smstsvc.log

  <03-27-2013   21:43:45> INFO: start checking Lanman Servic

  <03-27-2013 21:43:45> INFO:   CheckLanmanServer on server <hysite.mticontoso.com>.

  <03-27-2013 21:43:45> INFO: Lanman   started 1.

  <03-27-2013 21:43:45> INFO: Lanman   State Running.

  <03-27-2013 21:43:45> INFO:   CheckLanmanServer return <TRUE>

  <03-27-2013 21:43:53> INFO:   Domain:<mticontoso.com>, Computer:<HYSITE$>.

  <03-27-2013 21:43:53>   INFO:ADsOpenObject <LDAP://CN=System   Management,CN=System,DC=mticontoso,DC=com>.

  <03-27-2013 21:43:53>   ERROR: ADsOpenObject <LDAP://CN=System   Management,CN=System,DC=mticontoso,DC=com> return 0.

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\CPSCCM01$>

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\CPSCCM01$>

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\CPSCCM01$>

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\CPSCCM01$>

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\Domain Admins>

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\CPSCCM01$>

  <03-27-2013 21:43:54> INFO: Trustee   <mticontoso\hysite$>

  <03-27-2013 21:43:54> INFO: Domain   <mticontoso>, User account: <hysite$>

  <03-27-2013 21:43:54> INFO:   user:<hysite$>, Read:0, write:0, delete:1, Full:0.

  <03-27-2013 21:43:54> INFO:   User:<hysite$>, Create Child:1, Delete Child:1.

  ---

  RajKumar

  Wednesday, March 27, 2013 4:31 PM
• 

  

  0

  Sign in to vote

  We identified the problem & it is a firwall issue between 2 sites and our network guy enabled the rule permit any in/out. This worked like charm.

  -Vrkumar01

  ---

  RajKumar

  • Marked as answer by vrkumar01 Thursday, August 7, 2014 6:10 PM

  Friday, March 29, 2013 4:54 AM