{"id":4133,"date":"2012-10-23T13:23:00","date_gmt":"2012-10-23T13:23:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2012\/10\/23\/error-tf254027-tfs-install-and-language-restrictions-in-sql-server-express\/"},"modified":"2019-02-14T17:58:04","modified_gmt":"2019-02-15T01:58:04","slug":"error-tf254027-tfs-install-and-language-restrictions-in-sql-server-express","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/error-tf254027-tfs-install-and-language-restrictions-in-sql-server-express\/","title":{"rendered":"Error TF254027: TFS Install and Language Restrictions in SQL Server (Express)"},"content":{"rendered":"<p>The new Team Foundation Server Express product is designed to work with the Express version of SQL Server.&nbsp; It conveniently installs SQL Server Express automatically during configuration on machines where it is not detected.&nbsp; However, SQL Server and SQL Server Express impose additional restrictions on&nbsp;a system&#8217;s language settings that TFS by itself does not normally require in order to support Multilingual User Interface (MUI) systems.&nbsp; This means that TFS must impose additional blocks for language mismatches when it is installing SQL Server Express.<\/p>\n<p>The basic language restrictions for SQL Server are as follows:<\/p>\n<ul>\n<li>English SQL Server is supported on all localized versions of the OS.<\/li>\n<li>Localized versions of SQL Server are supported on the same localized&nbsp;OS or the English&nbsp;OS with MUI enabled for the same language.<\/li>\n<\/ul>\n<p>&nbsp;Note that Windows has three different language settings.&nbsp; If it is configured such that any of these settings do not match, or your setup does not comply with the basic restrictions above, you will get the following error during the readiness checks for TFS Express:&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"\"><\/p>\n<p>&nbsp;<\/p>\n<p>If you see this error, confirm that the following 3 OS settings match.&nbsp; This can be done in the Windows Control Panel or by using the Windows API calls listed in the table:<\/p>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300;text-decoration: underline\"><span style=\"text-decoration: underline\"><strong>Windows Setting<\/strong><\/span><\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300;text-decoration: underline\"><span style=\"text-decoration: underline\"><strong>Description<\/strong><\/span><\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300;text-decoration: underline\"><span style=\"text-decoration: underline\"><strong>Windows API Call<\/strong><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">UI Language<\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">Determines what strings are<\/span><br><span style=\"color: #003300\">&nbsp; shown to the user.<\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">GetUserDefaultUILanguage<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">System Format<\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">Determines how dates, times,<\/span><br><span style=\"color: #003300\">&nbsp; etc&hellip; are formatted, but also how strings are compared.<\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">GetUserDefaultLCID<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">System Locale<\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">Is specifically for<\/span><br><span style=\"color: #003300\">&nbsp; non-Unicode programs<\/span><\/p>\n<\/td>\n<td width=\"213\" valign=\"top\">\n<p><span style=\"color: #003300\">GetSystemDefaultLCID<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;&nbsp;<\/p>\n<p>For more information about language requirements for SQL Server and how to change language settings in Windows, visit this blog post:&nbsp; <a href=\"http:\/\/blogs.msdn.com\/b\/petersad\/archive\/2010\/02\/04\/install-sql-server-2008-r2-on-a-multilingual-user-interface-mui-system.aspx\">http:\/\/blogs.msdn.com\/b\/petersad\/archive\/2010\/02\/04\/install-sql-server-2008-r2-on-a-multilingual-user-interface-mui-system.aspx<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>We also have more supporting documentation&nbsp;for this topic on the MSDN Library:<\/p>\n<p>Local Language Versions in SQL Server:&nbsp; <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ee210665(SQL.105).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ee210665(SQL.105).aspx<\/a><\/p>\n<p>How to Change Operating System Settings to Support Localized Versions of SQL Server:&nbsp; <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms144258(v=sql.105).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms144258(v=sql.105).aspx<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The new Team Foundation Server Express product is designed to work with the Express version of SQL Server.&nbsp; It conveniently installs SQL Server Express automatically during configuration on machines where it is not detected.&nbsp; However, SQL Server and SQL Server Express impose additional restrictions on&nbsp;a system&#8217;s language settings that TFS by itself does not normally [&hellip;]<\/p>\n","protected":false},"author":66,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4133","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"acf":[],"blog_post_summary":"<p>The new Team Foundation Server Express product is designed to work with the Express version of SQL Server.&nbsp; It conveniently installs SQL Server Express automatically during configuration on machines where it is not detected.&nbsp; However, SQL Server and SQL Server Express impose additional restrictions on&nbsp;a system&#8217;s language settings that TFS by itself does not normally [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/4133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/66"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=4133"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/4133\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=4133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=4133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=4133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}