{"id":623,"date":"2018-01-12T21:57:29","date_gmt":"2018-01-13T02:57:29","guid":{"rendered":"http:\/\/www.terrcon.com\/dynamics-gp-support\/?p=623"},"modified":"2019-11-21T12:46:00","modified_gmt":"2019-11-21T17:46:00","slug":"management-reporter-2012-not-work-sql-2017","status":"publish","type":"post","link":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/","title":{"rendered":"Management Reporter 2012 needs patch for SQL 2017"},"content":{"rendered":"

Update\u00a0— Management Reporter CU16 v2 has added support for SQL 2017. <\/span><\/h3>\n
You can find out more about the updated CU16 release here:<\/span><\/h6>\n

https:\/\/blogs.msdn.microsoft.com\/dynamics_financial_reporting\/2018\/03\/20\/updated-management-reporter-cu16-now-available\/<\/a><\/p>\n

You can download the updated build of CU16\u00a0here.<\/a><\/strong><\/p>\n

\n

—- original article below:<\/p>\n

Management Reporter 2012 does NOT work with SQL 2017<\/p>\n

Management Reporter 2012 is currently not compatible with Microsoft SQL Server 2017. Hopefully Microsoft will get around to releasing a patch to fix this.<\/p>\n

While trying to configure the Application Service, this error message popped up:<\/p>\n

\"\"<\/p>\n

Here’s what the deployment log showed:<\/p>\n

The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. —> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Unable to connect to target server.<\/strong><\/p>\n

These errors occurred while trying to deploy the latest release which is Management Reporter 2012 CU16 (release date:\u00a04\/28\/2017 – version:\u00a0\u200b2.12.16000.17)<\/p>\n

SQL Server 2017 was released 10\/30\/2017. Since Management Reporter 2012 CU16 was released months earlier,\u00a0 it doesn’t know about SQL 2017.<\/p>\n

The latest Management Reporter patch (Management Reporter 2012 CU16 Hotfix 3858003 – version: \u200b2.12.16000.37) was released a month after SQL 2017 was released, but somehow they overlooked adding SQL 2017 compatibility to the patch. Configuration console produces the exact same error with this patch.<\/p>\n

So for now, everyone stick with SQL Server 2016 while we wait for Microsoft to release the patch for Management Reporter.<\/p>\n","protected":false},"excerpt":{"rendered":"

Update\u00a0— Management Reporter CU16 v2 has added support for SQL 2017. You can find out more about the updated CU16 release here: https:\/\/blogs.msdn.microsoft.com\/dynamics_financial_reporting\/2018\/03\/20\/updated-management-reporter-cu16-now-available\/ You can download the updated build of CU16\u00a0here. —- original article below: Management Reporter 2012 does NOT work with SQL 2017 Management Reporter 2012 is currently not compatible with Microsoft SQL Server … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[1,17],"tags":[5,28,19],"class_list":["post-623","post","type-post","status-publish","format-standard","hentry","category-dynamicsgphelp","category-dynamics-gp-tech-tips","tag-management-reporter","tag-sql-2017","tag-sql-tech-tip"],"yoast_head":"\nManagement Reporter 2012 needs patch for SQL 2017<\/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.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Management Reporter 2012 needs patch for SQL 2017\" \/>\n<meta property=\"og:description\" content=\"Update\u00a0— Management Reporter CU16 v2 has added support for SQL 2017. You can find out more about the updated CU16 release here: https:\/\/blogs.msdn.microsoft.com\/dynamics_financial_reporting\/2018\/03\/20\/updated-management-reporter-cu16-now-available\/ You can download the updated build of CU16\u00a0here. —- original article below: Management Reporter 2012 does NOT work with SQL 2017 Management Reporter 2012 is currently not compatible with Microsoft SQL Server ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamics GP Support Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-13T02:57:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-21T17:46:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.terrcon.com\/dynamics-gp-support\/wp-content\/uploads\/2018\/01\/Capture.png\" \/>\n<meta name=\"author\" content=\"Terrapin Consulting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Terrapin Consulting\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/\",\"url\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/\",\"name\":\"Management Reporter 2012 needs patch for SQL 2017\",\"isPartOf\":{\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website\"},\"datePublished\":\"2018-01-13T02:57:29+00:00\",\"dateModified\":\"2019-11-21T17:46:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website\",\"url\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/\",\"name\":\"Dynamics GP Support Blog\",\"description\":\"Call 888-368-6670 for Great Plains Help\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f\",\"name\":\"Terrapin Consulting\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g\",\"caption\":\"Terrapin Consulting\"},\"sameAs\":[\"http:\/\/www.terrcon.com\"],\"url\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/author\/Randy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Management Reporter 2012 needs patch for SQL 2017","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.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/","og_locale":"en_US","og_type":"article","og_title":"Management Reporter 2012 needs patch for SQL 2017","og_description":"Update\u00a0— Management Reporter CU16 v2 has added support for SQL 2017. You can find out more about the updated CU16 release here: https:\/\/blogs.msdn.microsoft.com\/dynamics_financial_reporting\/2018\/03\/20\/updated-management-reporter-cu16-now-available\/ You can download the updated build of CU16\u00a0here. —- original article below: Management Reporter 2012 does NOT work with SQL 2017 Management Reporter 2012 is currently not compatible with Microsoft SQL Server ... Read more","og_url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/","og_site_name":"Dynamics GP Support Blog","article_published_time":"2018-01-13T02:57:29+00:00","article_modified_time":"2019-11-21T17:46:00+00:00","og_image":[{"url":"http:\/\/www.terrcon.com\/dynamics-gp-support\/wp-content\/uploads\/2018\/01\/Capture.png"}],"author":"Terrapin Consulting","twitter_misc":{"Written by":"Terrapin Consulting","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/","url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/","name":"Management Reporter 2012 needs patch for SQL 2017","isPartOf":{"@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website"},"datePublished":"2018-01-13T02:57:29+00:00","dateModified":"2019-11-21T17:46:00+00:00","author":{"@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.terrcon.com\/dynamics-gp-support\/2018\/01\/management-reporter-2012-not-work-sql-2017\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website","url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/","name":"Dynamics GP Support Blog","description":"Call 888-368-6670 for Great Plains Help","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.terrcon.com\/dynamics-gp-support\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f","name":"Terrapin Consulting","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g","caption":"Terrapin Consulting"},"sameAs":["http:\/\/www.terrcon.com"],"url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/author\/Randy\/"}]}},"_links":{"self":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts\/623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/comments?post=623"}],"version-history":[{"count":13,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts\/623\/revisions"}],"predecessor-version":[{"id":664,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts\/623\/revisions\/664"}],"wp:attachment":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/media?parent=623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/categories?post=623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/tags?post=623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}