You receive a "The Collation specified by SQL Server is not supported" error message when you try to install SQL Server 2008
When you try to install Microsoft SQL Server 2008, you receive the following error message:
The Collation specified by SQL Server is not supported.Retrying the installation fails, and canceling the action causes Setup to fail. You also see information that resembles the following in the Detail.txt file:
2008-07-16 14:41:40 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException2008-07-16 14:41:40 Slp: Message: 2008-07-16 14:41:40 Slp: The Collation specified by SQL Server is not supported.2008-07-16 14:41:40 Slp: Changed database context to 'master'.2008-07-16 14:41:40 Slp: Data: 2008-07-16 14:41:40 Slp: DisableRetry = true2008-07-16 14:41:40 Slp: Inner exception type: System.Data.SqlClient.SqlException2008-07-16 14:41:40 Slp: Message: 2008-07-16 14:41:40 Slp: The Collation specified by SQL Server is not supported.2008-07-16 14:41:40 Slp: Changed database context to 'master'.2008-07-16 14:41:40 Slp: Data: 2008-07-16 14:41:40 Slp: HelpLink.ProdName = Microsoft SQL Server2008-07-16 14:41:40 Slp: HelpLink.EvtSrc = MSSQLServer2008-07-16 14:41:40 Slp: HelpLink.EvtID = 02008-07-16 14:41:40 Slp: HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink2008-07-16 14:41:40 Slp: HelpLink.LinkId = 20476
This problem occurs because the specified collation is not supported in this version of Windows and because of a limitation in how validation of the collation is performed in different operating systems.
To work around this problem, do not use a collation that is not supported by the operating system on which you are installing SQL Server 2008.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The following new collations are supported in Windows Vista and in Windows Server 2008. These collations may cause the problem that is mentioned in the "Symptoms" section when the collations are used in Windows Server 2003 or in Windows XP:
- Upper Sorbian
"SQL Server 2008 Installation" "SQL Server 2008 Configuration"SQL2008RelNoteInstallation StandAlone
Article ID: 956141 - Last Review: 03/19/2009 22:35:51 - Revision: 2.0
Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Standard Edition for Small Business, Microsoft SQL Server 2008 Workgroup
- sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kbtshoot kbpubtypekc kberrmsg kbprb KB956141