Hi,

 

I am running an unattented installation of SQL on a server. I run it with the following configuration:

********************************************

;SQLSERVER2008 Configuration File

[SQLSERVER2008]

 

;************************* CORE ARGUMENTS *************************

; 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,REPLICATION,FULLTEXT,AS,RS,CONN,IS,BC,SDK,SSMS,ADV_SSMS,SNAC_SDK

 

; Setup will not display any user interface. ***

QUIET="True"

 

; Needed argument for silent installation

IACCEPTSQLSERVERLICENSETERMS="True"

 

;*************************** OPTIONAL *****************************

 

; Displays the command line parameters usage 

HELP="False"

 

; Specifies that the detailed Setup log should be piped to the console. ***

INDICATEPROGRESS="True"

 

; 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"

 

; Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.

ENU="True"

 

; 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 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="NT AUTHORITY\NETWORK SERVICE"

 

; 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"

 

; The name of the account that the Analysis Services service runs under. 

ASSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"

 

; 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="C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data"

 

; The location for the Analysis Services log files. 

ASLOGDIR="C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log"

 

; The location for the Analysis Services backup files. 

ASBACKUPDIR="C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup"

 

; The location for the Analysis Services temporary files. 

ASTEMPDIR="C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Temp"

 

; The location for the Analysis Services configuration files. 

ASCONFIGDIR="C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config"

 

; Specifies whether or not the MSOLAP provider is allowed to run in process. 

ASPROVIDERMSOLAP="1"

 

; Specifies the list of administrator accounts that need to be provisioned. 

ASSYSADMINACCOUNTS=”CRB\dsstest”

 

; Startup type for the SQL Server service. 

SQLSVCSTARTUPTYPE="Automatic"

 

; Specifies a Windows collation or an SQL collation to use for the Database Engine. 

SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"

 

; Account for SQL Server service: Domain\User or system account. 

SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"

 

; Windows account(s) to provision as SQL Server system administrators. 

SQLSYSADMINACCOUNTS=”CRB\dsstest”

 

; 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"

 

; 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="Automatic"

 

; Specifies which account the report server NT service should execute under.  When omitted or when the value is empty string, the default built-in account for the current operating system.

; The username part of RSSVCACCOUNT is a maximum of 20 characters long and

; The domain part of RSSVCACCOUNT is a maximum of 254 characters long. 

RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"

 

; 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="DefaultNativeMode"

 

; Full-Text filter launcher service account

FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE"

********************************* I run the installation with the user crb\dsstest, but i get the following error: 2011-12-28 12:58:47 Slp: Hosting object: Microsoft.SqlServer.Configuration.AnalysisServices.ASConfigurationPublic failed validation 2011-12-28 12:58:47 Slp: Validation for setting 'ASSYSADMINACCOUNTS' failed. Error message: ”CRB\dsstest” - User or group does not exists. 2011-12-28 12:58:47 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction" threw an exception during execution. 2011-12-28 12:58:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: ”CRB\dsstest” - User or group does not exists. ---> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: ”CRB\dsstest” - User or group does not exists. ---> System.ApplicationException: ”CRB\dsstest” - User or group does not exists. 2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace --- 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace --- 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue() 2011-12-28 12:58:47 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution. 2011-12-28 12:58:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: ”CRB\dsstest” - User or group does not exists. ---> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: ”CRB\dsstest” - User or group does not exists. ---> System.ApplicationException: ”CRB\dsstest” - User or group does not exists. 2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace --- 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace --- 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue() 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue() 2011-12-28 12:58:47 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution. 2011-12-28 12:58:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: ”CRB\dsstest” - User or group does not exists. ---> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: ”CRB\dsstest” - User or group does not exists. ---> System.ApplicationException: ”CRB\dsstest” - User or group does not exists. 2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace --- 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace --- 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue() 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue() 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 2011-12-28 12:58:49 Slp: Received request to add the following file to Watson reporting: C:\Users\dsstest\AppData\Local\Temp\tmp8278.tmp 2011-12-28 12:59:02 Slp: The following is an exception stack listing the exceptions in outermost to innermost order 2011-12-28 12:59:02 Slp: Inner exceptions are being indented 2011-12-28 12:59:02 Slp:  2011-12-28 12:59:02 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException 2011-12-28 12:59:02 Slp:     Message:  2011-12-28 12:59:02 Slp:         ”CRB\dsstest” - User or group does not exists. 2011-12-28 12:59:02 Slp:     Data:  2011-12-28 12:59:02 Slp:       SQL.Setup.FailureCategory = InputSettingValidationFailure 2011-12-28 12:59:02 Slp:       DisableWatson = true 2011-12-28 12:59:02 Slp:     Stack:  2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs) 2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId) 2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 2011-12-28 12:59:02 Slp:     Inner exception type: System.ApplicationException 2011-12-28 12:59:02 Slp:         Message:  2011-12-28 12:59:02 Slp:                 ”CRB\dsstest” - User or group does not exists. 2011-12-28 12:59:02 Slp:  2011-12-28 12:59:02 Slp: ---------------------------------------------------------------------- 2011-12-28 12:59:02 Slp:  2011-12-28 12:59:02 Slp: Error result: -2068578304 2011-12-28 12:59:02 Slp: Result facility code: 1204 2011-12-28 12:59:02 Slp: Result error code: 0 Can anyone help me?

Hi,

First of all please check your configured user name & if it exists then check for the Group it belongs to.

And still if you get error please provide the error details. So we can help to find the solution.

Cheers,

- Sekilha

Hi,

 

I have tried to chech if it exists. If I add the user dsstest during the normal installation it is found. I am also logged in as the user dsstest. Then everything should be okay rigth, or is there anything else i can check?

 

The following are the error details:

*****************************************************

2011-12-28 12:58:47 AS: Action: (Validation) Validating SysAdmin Accounts

2011-12-28 12:58:47 AS: Action: Validation User Account (”CRB\dsstest”)

2011-12-28 12:58:47 AS: Action: Validating Account

2011-12-28 12:58:47 AS: Data: Account=”CRB\dsstest”

2011-12-28 12:58:47 AS: Data: Account After Mapping = ”CRB\dsstest”

2011-12-28 12:58:47 Slp: Sco: Attempting to get account sid for user account ”CRB\dsstest”

2011-12-28 12:58:47 Slp: Sco: Attempting to get sid for user account ”CRB\dsstest”

2011-12-28 12:58:47 Slp: Sco: GetSidForAccount normalized accountName ”CRB\dsstest” parameter to ”CRB\dsstest”

2011-12-28 12:58:47 Slp: Sco: Failed when querying buffer size

2011-12-28 12:58:47 AS: Warning: Failed to retrieved Account SID. Reason: No mapping between account names and security IDs was done.

 

2011-12-28 12:58:47 AS: Result: Error

2011-12-28 12:58:47 AS: Result: Invalid

2011-12-28 12:58:47 AS: Result: (Validation) Complete

2011-12-28 12:58:47 AS: Action: (Validation) Validating Collation for Analysis Service

2011-12-28 12:58:47 AS: Action: (Validation) Validating Collation Entry

2011-12-28 12:58:47 AS: Data:  Latin1_General_CI_AS

2011-12-28 12:58:47 AS: Action: (Utility) Validate Collation Entry

2011-12-28 12:58:47 AS: Data: Latin1_General_CI_AS

2011-12-28 12:58:47 AS: Result: (Utility) Valid

2011-12-28 12:58:47 AS: Result: (Validation) Success

2011-12-28 12:58:47 AS: Action: (Validation) Validating Collation Match

2011-12-28 12:58:47 AS: Data: ASCollation=Latin1_General_CI_AS,SQLCollation=

2011-12-28 12:58:47 AS: Result: (Validation) Success

2011-12-28 12:58:47 AS: Action: Detect Whether it is Valid Collation

2011-12-28 12:58:47 AS: Data: Collation = Latin1_General_CI_AS

2011-12-28 12:58:47 AS: Action: (Utility) Retrieving embedded content

2011-12-28 12:58:47 AS: Data: Resource Name =Microsoft.SqlServer.Configuration.ASExtension.LCIDs.xml

2011-12-28 12:58:47 AS: Result: (Utility) Success

2011-12-28 12:58:47 AS: Data: Locale ID=0x0409

2011-12-28 12:58:47 AS: Result: Valid

2011-12-28 12:58:47 AS: Result: (Validation) Success

2011-12-28 12:58:47 AS: Action: Validating Start Mode

2011-12-28 12:58:47 AS: Result: Success

2011-12-28 12:58:47 AS: Action: Validating Allow in Process

2011-12-28 12:58:47 AS: Data: AllowInProcess=1

2011-12-28 12:58:47 AS: Result: Success

2011-12-28 12:58:47 AS: Result: (Validation) Success

2011-12-28 12:58:47 AS: ----------------------------------------------

2011-12-28 12:58:47 Slp: Hosting object: Microsoft.SqlServer.Configuration.AnalysisServices.ASConfigurationPublic failed validation

2011-12-28 12:58:47 Slp: Validation for setting 'ASSYSADMINACCOUNTS' failed. Error message: ”CRB\dsstest” - User or group does not exists.

2011-12-28 12:58:47 Slp: Validation for setting 'ASSYSADMINACCOUNTS' failed. Error message: ”CRB\aml021” - User or group does not exists.

2011-12-28 12:58:47 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction" threw an exception during execution.

2011-12-28 12:58:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: ”CRB\dsstest” - User or group does not exists. ---> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: ”CRB\dsstest” - User or group does not exists. ---> System.ApplicationException: ”CRB\dsstest” - User or group does not exists.

2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace ---

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace ---

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()

2011-12-28 12:58:47 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution.

2011-12-28 12:58:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: ”CRB\dsstest” - User or group does not exists. ---> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: ”CRB\dsstest” - User or group does not exists. ---> System.ApplicationException: ”CRB\dsstest” - User or group does not exists.

2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace ---

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace ---

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()

2011-12-28 12:58:47 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution.

2011-12-28 12:58:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: ”CRB\dsstest” - User or group does not exists. ---> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: ”CRB\dsstest” - User or group does not exists. ---> System.ApplicationException: ”CRB\dsstest” - User or group does not exists.

2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace ---

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    --- End of inner exception stack trace ---

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2011-12-28 12:58:47 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2011-12-28 12:58:49 Slp: Received request to add the following file to Watson reporting: C:\Users\dsstest\AppData\Local\Temp\tmp8278.tmp

2011-12-28 12:59:02 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

2011-12-28 12:59:02 Slp: Inner exceptions are being indented

2011-12-28 12:59:02 Slp:

2011-12-28 12:59:02 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException

2011-12-28 12:59:02 Slp:     Message:

2011-12-28 12:59:02 Slp:         ”CRB\dsstest” - User or group does not exists.

2011-12-28 12:59:02 Slp:     Data:

2011-12-28 12:59:02 Slp:       SQL.Setup.FailureCategory = InputSettingValidationFailure

2011-12-28 12:59:02 Slp:       DisableWatson = true

2011-12-28 12:59:02 Slp:     Stack:

2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)

2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)

2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2011-12-28 12:59:02 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2011-12-28 12:59:02 Slp:     Inner exception type: System.ApplicationException

2011-12-28 12:59:02 Slp:         Message:

2011-12-28 12:59:02 Slp:                 ”CRB\dsstest” - User or group does not exists.

2011-12-28 12:59:02 Slp:

2011-12-28 12:59:02 Slp: ----------------------------------------------------------------------

2011-12-28 12:59:02 Slp:

2011-12-28 12:59:02 Slp: Error result: -2068578304

2011-12-28 12:59:02 Slp: Result facility code: 1204

2011-12-28 12:59:02 Slp: Result error code: 0
 
 
Do you need more information then above? The above chech do not fail for the network service:

2011-12-28 12:58:46 ACE: Formatting user name 'NT AUTHORITY\NETWORK SERVICE'

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\NETWORK SERVICE parameter to NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 ACE: Formatted user name is 'NT AUTHORITY\NETWORK SERVICE'

2011-12-28 12:58:46 ACE: ValidateUserNameAndPassword started with userName = 'NT AUTHORITY\NETWORK SERVICE', userNameRequired = 'True', mustBeDomainAcct = 'False'

2011-12-28 12:58:46 ACE: Validating username 'NT AUTHORITY\NETWORK SERVICE' and password '<empty>'

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\NETWORK SERVICE parameter to NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 ACE: Getting sid for service account 'NT AUTHORITY\NETWORK SERVICE'

2011-12-28 12:58:46 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\NETWORK SERVICE parameter to NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 ACE: SID for user account is 'S-1-5-20'

2011-12-28 12:58:46 ACE: Validating service account is not LocalService

2011-12-28 12:58:46 ACE: Validating service account is a user account

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 ACE: Validating service account can be used if current machine is domain controller

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\NETWORK SERVICE parameter to NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 ACE: Checking if service account must be a domain account

2011-12-28 12:58:46 ACE: ValidateUserNameAndPassword completed

2011-12-28 12:58:46 Slp: The configuration object document /Datastore/ProductSettings/SSIS/Public was found in the datastore.

2011-12-28 12:58:46 Slp: Sco: Attempting to get network service account name

2011-12-28 12:58:46 Slp: Sco: Attempting to get NT account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account from sid S-1-5-20

2011-12-28 12:58:46 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\NETWORK SERVICE parameter to NT AUTHORITY\NETWORK SERVICE

2011-12-28 12:58:46 Slp: The configuration object document /Datastore/ProductSettings/AS/Public was found in the datastore.

2011-12-28 12:58:46 AS: ----------------------------------------------

2011-12-28 12:58:46 AS: Action: Logging Input Values and it's Sources

2011-12-28 12:58:46 AS: Data: Parameter=ASSVCACCOUNT,Source=ConfigFile,Value=NT AUTHORITY\NETWORK SERVICE

Do you have any idea what is worong?

Hi SteensGaard,

Check the role of that account. It should be an Admin on your box. If it isn't, it doesn't have the rights to be assigned.

Hi Helpful,

The dsstest-user was already added to the Administrator group. I did it in the following way: Administrative Tools > Computer Management > Local Users and Groups > Groups.I open the Administrator group, then press "Add..." 

Thanks for the suggestion:)

BR

Brian

 

 

Earlier in the installation i get the following error:

Action: (Validation) Validating SysAdmin Accounts

Action: Validation User Account ("CRB\dsstest")

Action: Validating Account

Data: Account="CRB\dsstest"

Data: Account After Mapping = "CRB\dsstest"

Sco: Attempting to get account sid for user account "CRB\dsstest"

Sco: Attempting to get sid for user account "CRB\dsstest"

Sco: GetSidForAccount normalized accountName "CRB\dsstest" parameter to "CRB\dsstest"

Sco: Failed when querying buffer size

Warning: Failed to retrieved Account SID. Reason: No mapping between account names and security IDs was done.

Do anyone know this error?

 

Perhaps this experience will be helpful.  Brent Hu (MS) also include several KB articles that may help.

http://social.technet.microsoft.com/Forums/nl-NL/winserverGP/thread/144389b7-dda7-4de5-b218-ee02d9031299

RLF

 

Hi,

I know this is an old question, but I just fixed this particular error.
Turns out, my server hostname was too long for my development machine.

I removed some characters (ABC-DEFGHIJ-KLM-NOP became ABC-DEFGH- IJK) and now the unattended installation works fine.

Hope this helps someone.