none
The credentials you provided for the Integration Services service are invalid. To continue, provide a valid account and password for the Integration Services service. RRS feed

  • Question

  • I've read about it a bit but I don't really understand what the issue could really be. This is the full error log:

    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):           -2068578304
      Exit facility code:            1204
      Exit error code:               0
      Exit message:                  The credentials you provided for the Integration Services service are invalid. To continue, provide a valid account and password for the Integration Services service.
      Start time:                    2012-11-09 09:13:15
      End time:                      2012-11-09 09:13:58
      Requested action:              Install
    
    Machine Properties:
      Machine name:                  MSDEV0026
      Machine processor count:       4
      OS version:                    Windows Server 2008 R2
      OS service pack:               Service Pack 1
      OS region:                     Schweiz
      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 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         C:\Users\Administrator\Desktop\Installationsfiles\SQL Server 2008 R2 Enterprise\SQL Server 2008 R2 Enterprise\x64\setup\
      Installation edition:          ENTERPRISE
    
    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 SWISSCOMSWD\SA-SWD-Account1
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Automatic
      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:\Users\Administrator\Desktop\PowerShellScripts\Automatische Installation\scripts\Applications\SQL Server 2008 R2 Enterprise\ServerConfig.ini
      CUSOURCE:                      
      ENABLERANU:                    False
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,BIDS,CONN,IS,BC,BOL,SSMS,ADV_SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
      FTSVCPASSWORD:                 *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Users\Administrator\Desktop\SQL_Server\Default\Systemdata
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                     
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  C:\Users\Administrator\Desktop\SQL_Dump\Default
      SQLCOLLATION:                  Latin1_General_CI_AS
      SQLSVCACCOUNT:                 SWISSCOMSWD\SA-SWD-Account1
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           SWISSCOMSWD\Domain Admins
      SQLTEMPDBDIR:                  C:\Users\Administrator\Desktop\SQL_Server\Default\SystemData\TempDB
      SQLTEMPDBLOGDIR:               C:\Users\Administrator\Desktop\SQL_Server\Default\SystemLog\TempDB
      SQLUSERDBDIR:                  C:\Users\Administrator\Desktop\SQL_Server\Default\UserData
      SQLUSERDBLOGDIR:               C:\Users\Administrator\Desktop\SQL_Server\Default\UserLog
      SQMREPORTING:                  False
      TCPENABLED:                    1
      UIMODE:                        Normal
      X86:                           False
    
      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121109_091208\ConfigurationFile.ini
    
    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Full-Text Search
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Integration Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Client Tools Connectivity
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Management Tools - Complete
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Client Tools Backwards Compatibility
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       Business Intelligence Development Studio
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
      Feature:                       SQL Server Books Online
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed
    
    Rules with failures:
    
    Global rules:
    
    Scenario specific rules:
    
    Rules report file:               The rule result report file is not available.
    
    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented
    
    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException
        Message: 
            The credentials you provided for the Integration Services service are invalid. To continue, provide a valid account and password for the Integration Services service.
        Data: 
          SQL.Setup.FailureCategory = InputSettingValidationFailure
          DisableWatson = true
        Stack: 
            at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)
            at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    

    And here you can see the configfile, I'm using to silently install sql server:

    ;SQLSERVER2008 Configuration File
    [SQLSERVER2008]
    
    ;Aktuelle INI Version: 01.11.2010 / hb / V. 1.2 / SQL Server 2008 R2
    
    ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance. 
    
    INSTANCEID="MSSQLSERVER"
    
    ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. 
    
    ACTION="Install"
    
    ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components. 
    
    FEATURES=SQLENGINE,FULLTEXT,REPLICATION,BIDS,CONN,IS,BC,BOL,SSMS,ADV_SSMS
    
    ; Displays the command line parameters usage 
    
    HELP="False"
    
    ; Specifies that the detailed Setup log should be piped to the console. 
    
    INDICATEPROGRESS="False"
    
    ; Setup will not display any user interface. 
    
    QUIET="False"
    
    ; Setup will display progress only without any user interaction. 
    
    QUIETSIMPLE="False"
    
    ; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system. 
    
    X86="False"
    
    ; Detailed help for command line argument ENU has not been defined yet. 
    
    ENU="True"
    
    ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI, and AutoAdvance for a simplied UI. 
    
    UIMODE="Normal"
    
    ; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature. 
    
    ERRORREPORTING="False"
    
    ; Specify the root installation directory for native shared components. 
    
    INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
    
    ; Specify the root installation directory for the WOW64 shared components. 
    
    INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
    
    ; Specify the installation directory. 
    
    INSTANCEDIR="C:\Users\Administrator\Desktop\SQL_Server\Default\Systemdata"
    
    ; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature. 
    
    SQMREPORTING="False"
    
    ; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS). 
    
    INSTANCENAME="MSSQLSERVER"
    
    ; Agent account name 
    
    AGTSVCACCOUNT="SWISSCOMSWD\SA-SWD-Account1"
    
    ; Auto-start service after installation.  
    
    AGTSVCSTARTUPTYPE="Automatic"
    
    ; Startup type for Integration Services. 
    
    ISSVCSTARTUPTYPE="Automatic"
    
    ; Account for Integration Services: Domain\User or system account. 
    
    ISSVCACCOUNT="NT AUTHORITY\NetworkService"
    
    ; Controls the service startup type setting after the service has been created. 
    
    ASSVCSTARTUPTYPE="Automatic"
    
    ; The collation to be used by Analysis Services. 
    
    ASCOLLATION="Latin1_General_CI_AS"
    
    ; The location for the Analysis Services data files. 
    
    ASDATADIR="Data"
    
    ; The location for the Analysis Services log files. 
    
    ASLOGDIR="Log"
    
    ; The location for the Analysis Services backup files. 
    
    ASBACKUPDIR="Backup"
    
    ; The location for the Analysis Services temporary files. 
    
    ASTEMPDIR="Temp"
    
    ; The location for the Analysis Services configuration files. 
    
    ASCONFIGDIR="Config"
    
    ; Specifies whether or not the MSOLAP provider is allowed to run in process. 
    
    ASPROVIDERMSOLAP="1"
    
    ; A port number used to connect to the SharePoint Central Administration web application. 
    
    FARMADMINPORT="0"
    
    ; Startup type for the SQL Server service. 
    
    SQLSVCSTARTUPTYPE="Automatic"
    
    ; Level to enable FILESTREAM feature at (0, 1, 2 or 3). 
    
    FILESTREAMLEVEL="0"
    
    ; Set to "1" to enable RANU for SQL Server Express. 
    
    ENABLERANU="False"
    
    ; Specifies a Windows collation or an SQL collation to use for the Database Engine. 
    
    SQLCOLLATION="Latin1_General_CI_AS"
    
    ; Account for SQL Server service: Domain\User or system account. 
    
    SQLSVCACCOUNT="SWISSCOMSWD\SA-SWD-Account1"
    
    ; Windows account(s) to provision as SQL Server system administrators. 
    
    SQLSYSADMINACCOUNTS="SWISSCOMSWD\Domain Admins"
    
    ; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication. 
    
    SECURITYMODE="SQL"
    SAPWD="Passw0rd"
    
    ; Default directory for the Database Engine backup files. 
    
    SQLBACKUPDIR="C:\Users\Administrator\Desktop\SQL_Dump\Default"
    
    ; Default directory for the Database Engine user databases. 
    
    SQLUSERDBDIR="C:\Users\Administrator\Desktop\SQL_Server\Default\UserData"
    
    ; Default directory for the Database Engine user database logs. 
    
    SQLUSERDBLOGDIR="C:\Users\Administrator\Desktop\SQL_Server\Default\UserLog"
    
    ; Directory for Database Engine TempDB files. 
    
    SQLTEMPDBDIR="C:\Users\Administrator\Desktop\SQL_Server\Default\SystemData\TempDB"
    
    ; Directory for the Database Engine TempDB log files. 
    
    SQLTEMPDBLOGDIR="C:\Users\Administrator\Desktop\SQL_Server\Default\SystemLog\TempDB"
    
    ; Provision current user as a Database Engine system administrator for SQL Server 2008 Express. 
    
    ADDCURRENTUSERASSQLADMIN="False"
    
    ; Specify 0 to disable or 1 to enable the TCP/IP protocol. 
    
    TCPENABLED="1"
    
    ; Specify 0 to disable or 1 to enable the Named Pipes protocol. 
    
    NPENABLED="0"
    
    ; Startup type for Browser Service. 
    
    BROWSERSVCSTARTUPTYPE="Disabled"
    
    ; Specifies how the startup mode of the report server NT service.  When 
    ; Manual - Service startup is manual mode (default).
    ; Automatic - Service startup is automatic mode.
    ; Disabled - Service is disabled 
    
    RSSVCSTARTUPTYPE="Automatic"
    
    ; Specifies which mode report server is installed in.  
    ; Default value: “FilesOnly”  
    
    RSINSTALLMODE="FilesOnlyMode"
    
    ; Add description of input argument FTSVCACCOUNT 
    
    FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE"
    

    I thought it could be because of this line:

    SQLSYSADMINACCOUNTS="SWISSCOMSWD\Domain Admins"

    But I didn't really find out why, because when checking through the AD, the name should be correct.

    I hope you can help me out there.


    The following is my signature:

    Powershell Programmer & Advanced Lua Programmer

    Location: Switzerland

    Beside that, whenever you see a reply, you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the main question of the thread, click "Alternate TextMark As Answer" (if you opened the thread).

    Please contact me, before reporting me, thank you.

    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('577076797174-87661607769657424-8687168065964').substring(($_*2),2))})-replace' '

    Friday, November 9, 2012 8:20 AM

Answers

  • Yes it was that one there, I had to use an account I created with AD and also it's password. It does work now.

    The following is my signature:

    Powershell Programmer & Advanced Lua Programmer

    Location: Switzerland

    Beside that, whenever you see a reply, you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the main question of the thread, click "Alternate TextMark As Answer" (if you opened the thread).

    Please contact me, before reporting me, thank you.

    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('577076797174-87661607769657424-8687168065964').substring(($_*2),2))})-replace' '

    Tuesday, November 13, 2012 9:17 AM

All replies

  • Oh, looks more like it's that one here:

    ISSVCACCOUNT="NT AUTHORITY\NetworkService"


    The following is my signature:

    Powershell Programmer & Advanced Lua Programmer

    Location: Switzerland

    Beside that, whenever you see a reply, you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the main question of the thread, click "Alternate TextMark As Answer" (if you opened the thread).

    Please contact me, before reporting me, thank you.

    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('577076797174-87661607769657424-8687168065964').substring(($_*2),2))})-replace' '

    Friday, November 9, 2012 8:22 AM
  • Yes it was that one there, I had to use an account I created with AD and also it's password. It does work now.

    The following is my signature:

    Powershell Programmer & Advanced Lua Programmer

    Location: Switzerland

    Beside that, whenever you see a reply, you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the main question of the thread, click "Alternate TextMark As Answer" (if you opened the thread).

    Please contact me, before reporting me, thank you.

    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('577076797174-87661607769657424-8687168065964').substring(($_*2),2))})-replace' '

    Tuesday, November 13, 2012 9:17 AM