September 9, 2008 at 12:48 pm
Hi,
I am getting below mentioned error when I was trying to rebuild system databases in sql 2008(RC0):
The state of your SQL Server installation was not changed after the setup execution.
I followed instructions as per: http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx
Please help
MJ
January 6, 2012 at 2:38 am
I got the same error for SQL server 2008R2
January 6, 2012 at 2:46 am
When is that error thrown?
What was the aim of your rebuild?
Where you trying to change collation?
Sorry for the questions
January 6, 2012 at 2:52 am
Thanks for your replay, here is the answer:
I need to change the default collation on the server ( it need to be SQL_Latin1_General_CP1_CI_AS ), so I tried to rebuild it ( please fell free to give me other way of doing it if there is any other solution)
here is where I run the command:
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
here is the command:
setup.exe /ACTION=REBUILDDATABASE /INSTANCENAME=harphsql1 /SQLSYSADMINACCOUNTS=sa /SAPWD=P455w0rd /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
and the error is:
The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.
I found the same thing in the log file.
Many thanks in advanced
January 6, 2012 at 3:18 am
Hi there
I tried to change a collation of a sql a while ago.
I didn't have any luck doing it.
Eventually i just got my mdf ldf files and migrated them to a new install.
Sorry i can't be more help.
I would imagine someone who knew more about this would want you summary.txt and any sql logs from this time.
January 6, 2012 at 3:36 am
Please create a new post to get help with any issues.
In regard to this issue what does the following file show
farzad.jalali (1/6/2012)
Please review the summary.txt logs for further details.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2012 at 3:41 am
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-01-06 09:23:42
End time: 2012-01-06 09:24:50
Requested action: RebuildDatabase
Machine Properties:
Machine name: HARPHSQL1
Machine processor count: 16
OS version: Windows Server 2008
OS service pack: Service Pack 1
OS region: United Kingdom
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.51.2500.0 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: HARPHSQL1
QUIET: False
QUIETSIMPLE: False
SAPWD: *****
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSYSADMINACCOUNTS: sa
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120106_092313\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\20120106_092313\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.
January 6, 2012 at 4:08 am
farzad.jalali (1/6/2012)
here is where I run the command:C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
run setup from the original install CD\DVD and try launching the command from there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply