SQL Server Home
SQL server 2008 R2 Install from command line
5/6/2010 4:04:05 AM
User(s) can reproduce this bug
Hi, My system has Windows XP sp3 and windows installer 4.5.
I want to install sql server 2008 R2 RTM- Express from command line. For that I am using the following command...
Setup.exe /qs /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=ABC /SECURITYMODE=SQL /SAPWD=$SQLPass /SQLSYSADMINACCOUNTS="Builtin\Administrators" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE" /TCPENABLED=1 /NPENABLED=1 /ENABLERANU=1 /IAcceptSQLServerLicenseTerms=TRUE
But I am getting the following error...
Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01
Copyright (c) Microsoft Corporation. All rights reserved.
The following error occurred:
The action type 'ExecuteWorkflowAction' is not valid for the WorkflowIdentity el
ement. The only valid action type is ExecuteWorkflowAction.
Error result: -2068709375
Result facility code: 1202
Result error code: 1
if I run setup.exe manually then it is successfull.
SQL Server 2008 R2 - Express Edition
Operating System Language
Steps to Reproduce
Just run the given command from command line
to post a comment.
Please enter a comment.
on 12/1/2010 at 9:18 AM
Thank you for reporting this issue Mahendra. This issue has been fixed, please install Cummulative Update 1 for SQl Server 2008 R2: http://support.microsoft.com/kb/981355
Mohamed El Hassouni [SQl Server]
on 6/10/2010 at 2:23 PM
We do not have the entire logs attached to conclude if this is really the 8.3 filename issue. Please either attach the setup logs from %programfiles%\microsoft sql server\100\setup bootstrap\log.
If you are using the 8.3 filename format that truncates the names to 8 characters (please check http://support.microsoft.com/kb/973357 for description of the issue and the fix for SQL Server 2008), try using path names that fit to 8.3 format without any truncation.
If this is in fact the same issue, it was fixed in SQL Server 2008 RTM CU8, and SQL Server 2008 RTM CU6. Those CUs were not incorporated to the SQL Server 2008 R2 RTM release due to release timing.
We will port the fix to a future SQL Server 2008 R2 update.
on 6/7/2010 at 4:26 PM
I can reproduce this problem on SQL 2008 R2. It is caused by long folder names when running the install silently. I first experienced this issue in SQL2008 and Cumulative update 4 was "supposed to resolve the problem". It is simple to reproduce by placing the SQL install package in subfolders that contain long path names. When running the install silently from Installshield or Wise and it uses the shortname to launch then this error is reproduced.
e.g. Place SQL install in C:\SQL Install\setup.exe
go to command prompt and run c:\SQLINS~1\setup.exe
Please have a fix for this as it causes me many problems. This was not an issue on SQL 2005 or SQL2000.
on 6/3/2010 at 9:12 AM
We will investigate this issue for a future update of SQL Server 2008 R2. Thanks for reporting this.
on 5/6/2010 at 11:28 PM
I am attaching the log files. I ran this command 2-3 times but was unable to find "summary.txt".
on 5/6/2010 at 11:31 AM
Thanks for contacting us. We will need logs to investigate this issue. Please attach them from %programfiles%\microsoft sql server\100\setup bootstrap\log folder.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft