Did You Know 4: SQL Server Collation

Chances are your SQL server installation should be on SQL_Latin1_General_CP1_CI_AS and not something else, because a SCCM server deployment will not pull through if you choose other than the above collation. What collation really does it that it actually is how your character data is stored and compared. 

So during the deployment of SCCM server, as I forgot to tell my customer that the SQL server collation should be the default one instead: 

In order not to re-install SQL again you could rebuild SQL server. 

WARNING: The below option will wipe all DB information, you use this rebuild option for new setup like my case, for any existing setup with data in is beyond this article. 

Here's the command line below: 

Make sure that: 

1) You have a domain admin rights ID to perform the above rebuild or else your rebuild is not going to work. 

2) Since it is a re-build, it would be better to have your SA password reset just in case that you have forget the previous SA password on the existing account or for some queer reason your existing AD account is unable to gain access to the SQL server. 

3) I cannot stress again, this should be done on a new setup DB server, to do this on a production server is risky. You better know what you are doing. 

Happy trying! :) 

Shawn Yuen