Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installing SQL server 2008 Express from windows application Expand / Collapse
Author
Message
Posted Tuesday, July 17, 2012 4:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 26, 2014 1:59 AM
Points: 181, Visits: 987
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
Post #1330642
Posted Tuesday, July 17, 2012 12:04 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:01 PM
Points: 1,613, Visits: 1,539
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 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1330953
Posted Wednesday, July 18, 2012 10:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 26, 2014 1:59 AM
Points: 181, Visits: 987
Thanks robert for the reply.
Can u suggest or may be some links to install sql server through windows applications
Post #1331904
Posted Thursday, July 19, 2012 12:07 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:01 PM
Points: 1,613, Visits: 1,539
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 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1331938
Posted Thursday, December 20, 2012 6:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 26, 2014 1:59 AM
Points: 181, Visits: 987
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
Post #1398939
Posted Tuesday, April 2, 2013 3:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 2:59 PM
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?
Post #1438106
Posted Wednesday, April 3, 2013 3:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 2,869, Visits: 3,210
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 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1438228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse