2/11/13

How to change SQL collation

Problem installing SCCM due to wrong SQL collation?

If your SQL installation media path is E:
The command line syntax would be:
(Always test in non-production environment before using them in production Environment)

E:\setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=DOMAIN\administrator /SAPWD=YourPassword /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

No comments:

Post a Comment