Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installing SQL server 2008 Express from windows application


Installing SQL server 2008 Express from windows application

Author
Message
SQL006
SQL006
SSC Veteran
SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)

Group: General Forum Members
Points: 222 Visits: 1295
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
Robert Davis
Robert Davis
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1702 Visits: 1623
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.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Database Engineer at BlueMountain Capital Management
SQL006
SQL006
SSC Veteran
SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)

Group: General Forum Members
Points: 222 Visits: 1295
Thanks robert for the reply.
Can u suggest or may be some links to install sql server through windows applications
Robert Davis
Robert Davis
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1702 Visits: 1623
From Books Online: Embedding SQL Server 2008 Express in an Application



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Database Engineer at BlueMountain Capital Management
SQL006
SQL006
SSC Veteran
SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)

Group: General Forum Members
Points: 222 Visits: 1295
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
rd 38417
rd 38417
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 9
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?
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3154 Visits: 3821
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search