SCCM 2007: SQL Collation Configuration
Hello..Any problem for use Modem_Spanish_CI_AS collation for SCCM 2007 SQL Instance??I think that SQL requisites is: ConfigurationManager requires that the SQL Server database collation settings of the tempdb database and site database are the same for daily site database operations.I think that SQL recomendation is: Accept default SQL configuration...Thanks
November 15th, 2009 9:06pm

The only other thing I would add is to make sure that if you have multiple sites, that all sites have the same collation. Certain mixtures of collation types can cause issues, so its better to standardise collation type across all you're sites. If you are joining a site to an already existing hierarchy, set your collation to the same as the others.Regards, Tom Watson, E-Mail: Tom_...@... Blog: http://myitforum.com/cs2/blogs/tom_watson
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2009 10:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics