Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using following command to change the collation of my SQL Server R2 (10.50.1600):

setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SQLSYSADMINACCOUNTS=sa /SAPWD=**** /SQLCOLLATION=Latin1_General_CI_AI

Got the below error:

Microsoft (R) SQL Server 2008 Setup 10.00.2731.00
Copyright (c) Microsoft Corporation.  All rights reserved.

The following error occurred:
The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.

Error result: -2068643838
Result facility code: 1203
Result error code: 2

Please review the summary.txt log for further details

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068643838 Exit facility code: 1203 Exit error code: 2 Exit message: The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details. Start time: 2012-06-15 14:23:31 End time: 2012-06-15 14:23:40 Requested action: RebuildDatabase

Machine Properties: Machine name: DUPINDER-PC Machine processor count: 4 OS version: Windows Vista OS service pack: Service Pack 1 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 Management Tools - Basic 1033 Express Edition 10.50.1600.1 No

Package properties: Description: SQL Server Database Services 2008 SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9} ProductName: SQL2008 Type: RTM Version: 10 SPLevel: 0 Installation edition: EVAL

User Input Settings: ACTION: RebuildDatabase CONFIGURATIONFILE:
HELP: False INDICATEPROGRESS: False INSTANCENAME: MSSQLSERVER QUIET: True QUIETSIMPLE: False SAPWD: * SQLCOLLATION: Latin1_General_CI_AI SQLSYSADMINACCOUNTS: sa X86: False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120615_142321\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\20120615_142321\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.Setup.Chainer.Workflow.NoopWorkflowException Message: The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.

Can someone please suggest If I am missing out something.
share

migration rejected from stackoverflow.com Nov 12 '13 at 22:03

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, Mark Storey-Smith, Michael - sqlbot, Paul White, dezso Nov 12 '13 at 22:03

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Mark Storey-Smith, Michael - sqlbot, Paul White, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.

    
And what is said in the summary.txt log file? –  David Brabant Jun 15 '12 at 9:14
    
@David, I have edited the question and specified log's content. Sorry, could not format it as SO did not allow for some reasons –  user899055 Jun 15 '12 at 9:24
    
Can someone please have a look at this? –  user899055 Jun 15 '12 at 9:46