locked
Error when I try to rebuild the sql server 2008 R2 for changing the "Server Collation" RRS feed

  • Question

  • Hi
    I need to change the "server collation"  ( 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=myinstanceName /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 error in the log file.

    Many thanks in advanced
     
    Friday, January 6, 2012 10:00 AM

Answers

  • Instead of using the path C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release, try use the location with setup.exe from your installation media.

    Also instead of /SQLSYSADMINACCOUNTS=sa, specify a Windows user.

    • Marked as answer by Challen Fu Saturday, January 14, 2012 2:07 PM
    Saturday, January 7, 2012 2:01 AM