We had a requirement to change the SQL Server Fail over cluster group Virtual server name. We did that change through the cluster administrator. That SQL Server was 2008 Enterprise running on Windows 2008 Enterprise cluster. The change was successfully made from one node and the SQL server came online after that. But when we did fail over testing, we noticed that the SQL Server service is not coming online on the other node. The SQL Server error-log gave below errors while trying to start-up.
Click here to continue reading this post and resolution
- Log-in to the active node.
- Trigger a full backup for all System and User Databases.
- Script out all log-ins.
- If there are any user databases, you will have to export the tables using BCP utility.
- Copy SQL Server 2008 install media folder to some local directory. For Eg: D:\SQL2008SP2
- Open command prompt and execute below command. Caution: This step will replace your current system databases with new ones with required collation. So please make sure you will be able to restore all logins and the user databases back after this activity.
Note: Please replace the values for /INSTANCENAME, /SQLSYSADMINACCOUNTS, /SAPWD and /SQLCOLLATION
Here you go !. Your SQL server has got new collation settings now. Please let me know if incase you experienced any issues.
- Now restore all logins and userdatabases using the scripts generated in step 3 and the tables exported in Step 4.
The below script helps in detecting, recording and alerting when ever a change is made to sp_config or SQL server configuration settings. This will help in pin-pointing any unnecessary changes happening to Our Beloved SQL Server…