I have taken a backup from SQL server 2008 R2 and restored it in SQL server 2014. Now the database collation is SQL_Latin1_General_CP1_CS_AS. I have to change the collation to Latin1_General_100_CS_AS_SC. When I run the collation conversion utility, it prompted to enter the details like destination host name, instance name, db admin user name, db user name, default db and application name. When I enter all the details and hit the enter button, the window closed. Nothing happening. Please give me a solution as soon as possible.
First step in the script is creating log directories and scripts, are could you run the command prompt as an administrator? You can run through the commands in AlterDatabaseCollation section by section or add echo statements to see where it breaks
While installing the windchill 11, It has prompted to create a database user; I have created user A. Then, while restoring my old backup to sql 2014, users over-wrote. So the user A deleted from sql server database, (which is associated with windchill). I have only old users (as I had in sql 2008). But in db.properties file, the dbuser is marked as the user 'A'.
While running the collation conversion utility, which user I have to enter and what I have to change here ?
You will specify the user in the upgrade process.
May be you need to restore SQL User.