October 22, 2019 at 2:31 pm
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
Is it a named instance?
October 22, 2019 at 3:10 pm
Yes it is.
October 23, 2019 at 8:14 am
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
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
Ah, ok :-).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply