{"id":7281,"date":"2014-03-06T06:00:42","date_gmt":"2014-03-06T06:00:42","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=7281"},"modified":"2014-03-06T06:00:42","modified_gmt":"2014-03-06T06:00:42","slug":"sagecrm-and-sql-collation-setup","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/","title":{"rendered":"SageCRM and SQL Collation setup"},"content":{"rendered":"

While installing older versions of CRM i.e. v7.1 Sp1 or below the installation process in background checks the SQL Server collation defined at database server and accordingly it maps the same collation to CRM database. If the collation at SQL level is not defined correctly same reflects to CRM database as well. Because of this CRM can experience problems after the installation or installation will fail eventually.
\nNew Stuff:<\/b><\/span>\u00a0Creating tasks through workflow with defined due period<\/a>
\nConsidering this I have set process in my Implementation team to check SQL server collation before actually starting the installation of SageCRM.
\nNowadays, things are becoming easier and SageCRM has adapted a new way of defining the SQL collation. From 7.1 SP2 onwards, installation process doesn\u2019t check the collation defined at SQL server level. Instead of this, it creates its own collation on CRM database.
\nBelow are some of the default collations:
\n\u2022 For EN Installations = Latin1_General_CI_AS
\n\u2022 For DE Installations = Latin1_General_CI_AS
\n\u2022 For ES Installations = Modern_Spanish_CI_AS
\n\u2022 For FR Installations = French_CI_AS
\n\u2022 For CS Installations = Chinese_PRC_CI_AS
\nThese are the default installation collations that are put in place for the languages outlined above.
\nProblem Scenario:<\/strong>
\nRecently, one of my users has reported a problem that I am not able to access CRM as login screen shows below error message.<\/p>\n

\"IMG\"<\/a><\/p>\n

This particular issue occurs when connection with SQL is not established properly, SQL service is not running, Password for SQL SA user has been changed, etc… These are some of the issues which we can troubleshoot to make CRM up and running. But, this time it was something else which was very much new for me to give resolution.
\nThe error which was appearing in SQL logs was as below \u201cCannot resolve the collation conflict between “Latin1_General_CI_AS” and “Latin1_General_CI_AI” in the equal to operation\u201d.\u00a0<\/strong><\/em>
\nOn checking the current collation defined on the CRM database I found it incorrect. So by changing the collation to Latin1_General_CI_AS<\/strong> solved the issue.
\nAlso Read:<\/b><\/span>
\n1. How log files are maintained in Sage CRM<\/a>
\n2. You may need to recreate views manually \u2013 II<\/a>
\n3. How to identify and backup correct Sage CRM Database<\/a>
\n4. Login Error in Sage CRM<\/a>
\n5. You may need to recreate views manually<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

While installing older versions of CRM i.e. v7.1 Sp1 or below the installation process in background checks the SQL Server collation defined at database server and accordingly it maps the same collation to CRM database. If the collation at SQL level is not defined correctly same reflects to CRM database as well. Because of this\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[279,332,336,380,381],"tags":[1886,2185,2327],"class_list":["post-7281","post","type-post","status-publish","format-standard","hentry","category-patches","category-sage-crm","category-sage-crm-7-1-sp2","category-sql","category-sql-collation","tag-recreate-views-manually","tag-sagecrm-7-1sp2","tag-sql-collation"],"yoast_head":"\nSageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"While installing older versions of CRM i.e. v7.1 Sp1 or below the installation process in background checks the SQL Server collation defined at database server and accordingly it maps the same collation to CRM database. If the collation at SQL level is not defined correctly same reflects to CRM database as well. Because of this\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-06T06:00:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/\",\"name\":\"SageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg\",\"datePublished\":\"2014-03-06T06:00:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SageCRM and SQL Collation setup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/","og_locale":"en_US","og_type":"article","og_title":"SageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components","og_description":"While installing older versions of CRM i.e. v7.1 Sp1 or below the installation process in background checks the SQL Server collation defined at database server and accordingly it maps the same collation to CRM database. If the collation at SQL level is not defined correctly same reflects to CRM database as well. Because of this\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-03-06T06:00:42+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/","name":"SageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg","datePublished":"2014-03-06T06:00:42+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"SageCRM and SQL Collation setup"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/7281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=7281"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/7281\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=7281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=7281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=7281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}