locked
sql server installation on server 2003 64 bit domain controller RRS feed

  • Question

  • I keep receiving an error when attempting to install sql 2008 (from local cd via logmein) on a 64 bit Server 2003 domain controller.  The error occurs during the step: "Running post-Windows Installer configuration timing actions".  And it has "SqlEngineConfigAction_Install_confignonrc_Cpu64" under the progress bar at the time the error occurs. The pop-up box says "The following error has occurred: The specified user group 'SQLServerMSSQLUser$ComputerNameHere$MSSQLSERVER' does not exist.

    I have uninstalled & reinstalled several times. I've manually created the security group (local domain), SQLServerMSSQLUser$ComputerNameHere$MSSQLSERVER in an attempt to resolve the error.  But everytime I start w/ a new install - I get this same issue.


    Here is the log file:
    Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2068643839
      Exit facility code:            1203
      Exit error code:               1
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2009-05-04 09:47:38
      End time:                      2009-05-04 10:09:40
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090504_093724\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0x1B7EFB24%400xD3BEBD98%401211%401

    Machine Properties:
      Machine name:                  BusSPECIALIST
      Machine processor count:       8
      OS version:                    Windows Server 2003
      OS service pack:               Service Pack 2
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         F:\x64\setup\
      Installation edition:          STANDARD

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 Server15\SQLengine
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090504_093724\ConfigurationFile.ini
      ENABLERANU:                    False
      ERRORREPORTING:                False
      FEATURES:                      SQLENGINE,SSMS,ADV_SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   d:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      MEDIASOURCE:                   F:\
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 Server15\SQLengine
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           Server15\Smith,Server15\SQLengine,Server15\MSSQLSERVER,Server15\adminimstrator,Server15\Administrator
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    1
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090504_093724\ConfigurationFile.ini

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xD3BEBD98@1211@1
      Configuration error description: The specified user group 'SQLServerMSSQLUser$BusSpecialist$MSSQLSERVER' does not exist.
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090504_093724\Detail.txt

      Feature:                       Management Tools - Complete
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090504_093724\SystemConfigurationCheck_Report.htm

    Monday, May 4, 2009 2:00 PM

All replies

  • Don't install SQL on a DC. As per http://msdn.microsoft.com/en-us/library/ms143506.aspx#DC_Support:

    Installing SQL Server on a Domain Controller

    For security reasons, Microsoft recommends that you do not install SQL Server 2008 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

    • On Windows Server 2003, SQL Server services can run under a domain account or a local system account.
    • You cannot run SQL Server services on a domain controller under a local service account or a network service account.
    • After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
    • After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
    • SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
    • SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.

    Allan Hirt Blog: http://www.sqlha.com/blog Author: Pro SQL Server 2008 Failover Clustering (Apress - due out June, 2009)
    • Proposed as answer by Allan HirtMVP Monday, May 4, 2009 4:56 PM
    Monday, May 4, 2009 4:56 PM
  • Did you ever find the solution for this. I have tried to install for about 4 times but each time I am getting this error on file sqlEngineConfigAction_install_confignonrc_Cpu64 and error code 32.

    SQL Server 2008 64 bit on Windows Server 2008 64 bit. We even tried to use different media for different versions like SE and EE for SQL. Please help. Why is this happening to me. I am using domain users account for services to run under.


    Frenk

    Friday, June 28, 2013 2:01 PM