question

Howdy, Recently, we have started to use SQL Server Express 2008 R2 as well as 2012. In both instances, we are having issues installing with Group Policy. So, through Group Policy (Windows 2008 R2 Active Directory), we are running a script on computer boot through the domain network to install with System rights. The System Rights are the highest level which, of course, all scripts run through but we are receiving the following error from the log: Overall summary: Final result: Failed: see details below Exit code (Decimal): -2067922934 Exit facility code: 1214 Exit error code: 10 Exit message: The account that is running SQL Server Setup does not have one or all of the following rights: the right to back up files and directories, the right to manage auditing and the security log and the right to debug programs. To continue, use an account with both of these rights. For more information, see http://msdn.microsoft.com/en-us/library/ms813696.aspx, http://msdn.microsoft.com/en-us/library/ms813959.aspx and http://msdn.microsoft.com/en-us/library/ms813847.aspx. Start time: 2013-09-30 18:39:56 End time: 2013-09-30 18:41:12 Requested action: RunRules Machine Properties: Machine name: JPETERSON Machine processor count: 4 OS version: Windows 7 OS service pack: Service Pack 1 OS region: United States OS language: English (United States) OS architecture: x64 Process architecture: 32 Bit OS clustered: No Product features discovered: Product Instance Instance ID Feature Language Edition Version Clustered Package properties: Description: Microsoft SQL Server 2012 ProductName: SQL Server 2012 Type: RTM Version: 11 Installation location: C:\30985f2f86e6df75d6\x86\setup\ Installation edition: Express Slipstream: True User Input Settings: ACTION: RunRules CONFIGURATIONFILE: ENU: true FEATURES: SQLENGINE, CONN HELP: false IACCEPTSQLSERVERLICENSETERMS: true INDICATEPROGRESS: false INSTANCENAME: BRYANRES PID: ***** QUIET: true QUIETSIMPLE: false RULES: GlobalRules UIMODE: AutoAdvance X86: false Configuration file: C:\Program Files (x86)\Microsoft SQL Server\110\Setup Bootstrap\Log\20130930_183921\ConfigurationFile.ini Rules with failures: Global rules: There are no scenario-specific rules. Rules report file: C:\Program Files (x86)\Microsoft SQL Server\110\Setup Bootstrap\Log\20130930_183921\ SystemConfigurationCheck_Report.htm 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.Configuration.RulesEngineExtension.RulesEngineRuleFailureException Message: The account that is running SQL Server Setup does not have one or all of the following rights: the right to back up files and directories, the right to manage auditing and the security log and the right to debug programs. To continue, use an account with both of these rights. For more information, see http://msdn.microsoft.com/en-us/library/ms813696.aspx, http://msdn.microsoft.com/en-us/library/ms813959.aspx and http://msdn.microsoft.com/en-us/library/ms813847.aspx. HResult : 0x84be000a FacilityCode : 1214 (4be) ErrorCode : 10 (000a) Data: SQL.Setup.FailureCategory = RuleViolationFailure DisableWatson = true Stack: at Microsoft.SqlServer.Configuration.RulesEngineExtension.RunRulesAction.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, ServiceContainer context) If we log in as "Administrator", there is no issue installing. The issue is only when we try to run the script through Group Policy. This seems to happen often, specifically on Win 7 Enterprise/Pro 64-bit machines. I cannot tell you yet if there are issues on the Win 8 machines. Any ideas on how to fix or get around this issue without manual intervention i.e. logging in and doing a manual install? Thank you for your time.