SQL server 2008 R2 Install from command line - by mahendradubey

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


3
0
Sign in
to vote
ID 557341 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 5/6/2010 4:04:05 AM
Access Restriction Public

Description

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.

Sign in to post a comment.
Posted by Microsoft 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

Thank you,
Mohamed El Hassouni [SQl Server]
Posted by Microsoft 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.

Thanks,
Max Verun
SQL Server

Posted by Frank A 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.
Posted by Microsoft 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.

Max Verun
SQL Server
Posted by mahendradubey 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".
Posted by Microsoft 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.

Thanks,
Max Verun
SQL Server