July 17, 2012 at 4:44 am
Hi
I am trying to install SQL Server 2008 Express from Window Application
I am using this command
"/qs /ACTION=Install /SkipRules=VSShellInstalledRule RebootRequiredCheck /HIDECONSOLE /FEATURES=SQL /INSTANCENAME=" + _InstanceName + " /SECURITYMODE=\"SQL\" /SQLSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" /SAPWD=" + _SAPassword + " /SQLSYSADMINACCOUNTS=\"BUILTIN\\ADMINISTRATORS\" /ENABLERANU=1 /AGTSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" /TCPENABLED=1 /ERRORREPORTING=1";
It gives some error
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: 2012-07-17 15:24:44
End time: 2012-07-17 15:31:36
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120717_152357\sql_engine_core_inst_Cpu32_1_3.log
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.4000.0
This is the log
=== Verbose logging started: 7/17/2012 15:31:31 Build type: SHIP UNICODE 5.00.7601.00 Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x86\setup100.exe ===
MSI (c) (88:9C) [15:31:31:134]: Resetting cached policy values
MSI (c) (88:9C) [15:31:31:134]: Machine policy value 'Debug' is 0
MSI (c) (88:9C) [15:31:31:134]: ******* RunEngine:
******* Product: l:\ba31376b3b92fbc8f394b3\x86\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
******* Action:
******* CommandLine: **********
MSI (c) (88:9C) [15:31:31:134]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (88:9C) [15:31:34:134]: Failed to grab execution mutex. System error 258.
MSI (c) (88:9C) [15:31:34:135]: Cloaking enabled.
MSI (c) (88:9C) [15:31:34:135]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (88:9C) [15:31:34:136]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (88:9C) [15:31:34:137]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (88:9C) [15:31:34:137]: MainEngineThread is returning 1618
=== Verbose logging stopped: 7/17/2012 15:31:34 ===
MSI (s) (48:80) [15:31:49:560]: User policy value 'DisableRollback' is 0
MSI (s) (48:80) [15:31:49:560]: Machine policy value 'DisableRollback' is 0
MSI (s) (48:80) [15:31:49:560]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (48:80) [15:31:49:560]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (48:80) [15:31:49:564]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (48:80) [15:31:49:565]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (48:80) [15:31:49:565]: Restoring environment variables
MSI (s) (48:80) [15:31:49:573]: Destroying RemoteAPI object.
MSI (s) (48:80) [15:31:49:573]: Custom Action Manager thread ending.
Any info need let me know
Thanks
With regards
DD
July 17, 2012 at 12:04 pm
The key error from the log file is: Failed to grab execution mutex. System error 258
This means you are trying to run recursive installs which isn't allowed. The install fails because another install is already in progress.
July 18, 2012 at 10:27 pm
Thanks robert for the reply.
Can u suggest or may be some links to install sql server through windows applications
July 19, 2012 at 12:07 am
From Books Online: Embedding SQL Server 2008 Express in an Application
December 20, 2012 at 6:23 am
Hi I am getting this error while executing this commands
"/qs " + //Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
"/ACTION=Install " + //Required to indicate the installation workflow
"/SkipRules=VSShellInstalledRule " +
"RebootRequiredCheck " +
"/HIDECONSOLE " + //Specifies that the console window is hidden or closed.
"/FEATURES=SQL " + //specifies components to install
"/IACCEPTSQLSERVERLICENSETERMS=true " +
//Adds the current user to the SQL Server sysadmin fixed server role.
//The /ADDCURRENTUSERASSQLADMIN parameter can be used when installing Express editions or when
// /Role=ALLFeatures_WithDefaults is used. For more information, see /ROLE below.
// Use of /ADDCURRENTUSERASSQLADMIN is optional, but either /ADDCURRENTUSERASSQLADMIN or
// /SQLSYSADMINACCOUNTS is required. Default values:
"/ADDCURRENTUSERASSQLADMIN=true " +
"/INSTANCENAME=" + _InstanceName + //Specifies a SQL Server instance name for the instance that is being completed.
" /SECURITYMODE=\"SQL\" " + //Specifies the security mode for SQL Server. If this parameter is not supplied, then Windows-only authentication mode is supported
"/SQLSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" " + //Specifies the startup account for the SQL Server service.
//"/SQLSVCPASSWORD=" + _SAPassword +
"/SAPWD=" + _SAPassword + //Specifies the password for the SQL Server sa account. Required when /SECURITYMODE=SQL
" /SQLSYSADMINACCOUNTS=\"BUILTIN\\ADMINISTRATORS\" " +
"/ENABLERANU=1 " + //Enables run-as credentials for SQL Server Express installations.
"/AGTSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" " +
"/TCPENABLED=1 " + //Specifies the state of the TCP protocol for the SQL Server service.
"/ERRORREPORTING=1"; //Specifies the error reporting for SQL Server
This is the error summary
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 both of the following rights: the right to back up files and directories, and the right to manage auditing and the security log. To continue, use an account with both of these rights. For more information, see http://msdn.microsoft.com/en-us/library/ms813696.aspx and http://msdn.microsoft.com/en-us/library/ms813959.aspx.
Start time: 2012-12-20 18:08:41
End time: 2012-12-20 18:09:14
Requested action: RunRules
Machine Properties:
Machine name: WIN7VPC
Machine processor count: 1
OS version: Windows 7
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS Database Engine Services 1033 Express Edition 10.1.2531.0 No
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS SQL Server Replication 1033 Express Edition 10.1.2531.0 No
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
Installation location: c:\1cbb4a1abf2c090986c6f40685\x86\setup Installation edition: EXPRESS
Slipstream: True
User Input Settings:
ACTION: RunRules
CONFIGURATIONFILE:
ENU: True
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FEATURES: SQL
HELP: False
INDICATEPROGRESS: False
INSTANCENAME: REPROQUO_SALES
PASSPHRASE: *****
QUIET: False
QUIETSIMPLE: True
RULES: GlobalRules
UIMODE: AutoAdvance
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121220_180837\ConfigurationFile.ini
Detailed results:
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121220_180837\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 both of the following rights: the right to back up files and directories, and the right to manage auditing and the security log. To continue, use an account with both of these rights. For more information, see http://msdn.microsoft.com/en-us/library/ms813696.aspx and http://msdn.microsoft.com/en-us/library/ms813959.aspx.
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)
As mentioned in this error log,i followed the instruction from this link
http://support.microsoft.com/kb/2000257
Added all the privileges to local administrator as mentioned in the links
Oprating System - Windows 7
DB - SQL Server 2008 R2 Express edition
April 2, 2013 at 3:11 pm
I have the same error and have been unable to resolve it for several days. I have tried all the fixes I could track down. How did you resolve it?
April 3, 2013 at 3:28 am
The SQL Experss media does not include any of the pre-requisite software components needed for SQL Server. You have to deral with this yourself.
Are you checking for and installing .Net 3.5 SP1, Windows Installer 4.5 and Powershell? Can your .Net install cope with running on Windows 8/Windows 2012 where different install media are needed compared to Windows 7/2008R2 and different again compared to Windows Vista/W2008?
This link is orientated to what is needed to install SQL 2008 Express with SQL FineBuild, but it does give you the software matrix for the pre-req components and where you can get the install media: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%202008%20Express%20Edition%20Media%20Preparation
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply