Post reply

Clustered SQL Collation Change

  • October 22, 2019 at 2:31 pm

    #3690996

    I have searched this forum for an article on this and it links back to a page I have already viewed.

    I am after a way to change the collation on a SQL 2017 Clustered instance.

    I have tried running from the location of the SQL installation exe

    setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER,1433 /SAPWD=Password /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /SQLSYSADMINACCOUNTS="Domain\Account

     

    I get the message

    Instance Name MSSQLSERVER,1433 for product Microsoft SQL Server doesn't exist. Specify a valid instance name.

    Error result: -2068578302

    Result facility code: 1204

    Result error code: 2

    I am not sure what I am doing wrong.  any ideas.

     

  • October 22, 2019 at 2:48 pm

    #3691007

    Is it a named instance?

  • October 22, 2019 at 3:10 pm

    #3691027

    Yes it is.

  • October 23, 2019 at 8:14 am

    #3691223

    In that case you need to put the instance name in here (instead of MSSQLSERVER). Also the port will probably be different:

    /INSTANCENAME=MSSQLSERVER

  • October 23, 2019 at 8:37 am

    #3691225

    Sorry i just used a standard instance name so as not to give away the real information  I am using the named instance with the port number.  for example /INSTANCENAME=MSSQLSERVER, 1433

  • October 23, 2019 at 8:46 am

    #3691232

    Ah, ok :-).

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply