Home Dashboard Directory Help
Search

SQL server 2008 R2 Install from command line by mahendradubey


Status: 

Closed
 as Fixed Help for as Fixed


3
0
Sign in
to vote
Type: Bug
ID: 557341
Opened: 5/6/2010 4:04:05 AM
Access Restriction: Public
0
Workaround(s)
view
3
User(s) can reproduce this bug

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.

Details
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
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
LogFiles.cab (restricted) 5/6/2010 -