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.
