{"id":24,"date":"2020-05-07T15:41:00","date_gmt":"2020-05-07T13:41:00","guid":{"rendered":"http:\/\/disorder.dk\/wonderware\/?p=24"},"modified":"2020-05-14T10:39:28","modified_gmt":"2020-05-14T08:39:28","slug":"wonderware-system-platform-can-not-find-sql-server","status":"publish","type":"post","link":"https:\/\/disorder.dk\/wonderware\/2020\/05\/07\/wonderware-system-platform-can-not-find-sql-server\/","title":{"rendered":"WonderWare System Platform Can Not Find SQL Server"},"content":{"rendered":"\n<p>When installation a stand-alone SQL Express 2014 or 2017 server before installation of WonderWare System Platform, it is almost only default values for the installation process of the SQL server all the way.<\/p>\n\n\n\n<p>It is however important to change the default setting in &#8220;Instance Configuration&#8221; from &#8220;Named instance: MSSQLSERVER&#8221; to tick the button &#8220;Default instance&#8221; as seen below in the screenshot.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"676\" src=\"http:\/\/disorder.dk\/wonderware\/wp-content\/uploads\/2020\/05\/sqlserver2017_default_instance.png\" alt=\"\" class=\"wp-image-25\" srcset=\"https:\/\/disorder.dk\/wonderware\/wp-content\/uploads\/2020\/05\/sqlserver2017_default_instance.png 900w, https:\/\/disorder.dk\/wonderware\/wp-content\/uploads\/2020\/05\/sqlserver2017_default_instance-300x225.png 300w, https:\/\/disorder.dk\/wonderware\/wp-content\/uploads\/2020\/05\/sqlserver2017_default_instance-768x577.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption>Default instance is needed for WonderWare System Platform to connect to the SQL server<\/figcaption><\/figure><\/div>\n\n\n\n<p> If the SQL Express server 2014 or 2017 is installed with a named instance, WonderWare System Platform is not able to connect to it and it will most likely not result in a popup or fault message telling that it can not find it. It will just stall or time out.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When installation a stand-alone SQL Express 2014 or 2017 server before installation of WonderWare System Platform, it is almost only default values for the installation process of the SQL server all the way. It is however important to change the default setting in &#8220;Instance Configuration&#8221; from &#8220;Named instance: MSSQLSERVER&#8221; to tick the button &#8220;Default instance&#8221;<\/p>\n<p class=\"excert-link-wrapper\"><a href=\"https:\/\/disorder.dk\/wonderware\/2020\/05\/07\/wonderware-system-platform-can-not-find-sql-server\/\" class=\"excerpt-more-link\" >Continue Reading<span class=\"screen-reader-text\"> &#8220;WonderWare System Platform Can Not Find SQL Server&#8221;<\/span><span class=\"meta-nav\"> &rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":41,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6,7,5],"tags":[18,20,17,16,19],"class_list":["post-24","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wonderware","category-sql-express-2017","category-system-platform-2017","tag-18","tag-installation","tag-server","tag-sql","tag-wonderware"],"jetpack_featured_media_url":"https:\/\/disorder.dk\/wonderware\/wp-content\/uploads\/2020\/05\/sqlserver2017_default_instance_featured.jpg","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":1,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/posts\/24\/revisions"}],"predecessor-version":[{"id":26,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/posts\/24\/revisions\/26"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/media\/41"}],"wp:attachment":[{"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/media?parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/categories?post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/disorder.dk\/wonderware\/wp-json\/wp\/v2\/tags?post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}