A few days ago, I came across an issue where we had to change the SQL server instance collation and we were just asking the clients to rebuild the system databases to do so in the previous cases. But this time the client could not afford to do that and asked for a plan B.
The databases that gets installed with a fresh new SQL don’t need rebuild?
If change collation as recommended by David, we will not lose any configurations, logins and any other server objects like linked servers?