{"id":442,"date":"2017-03-29T13:09:14","date_gmt":"2017-03-29T13:09:14","guid":{"rendered":"http:\/\/buildsoftsupport.com\/?post_type=ht_kb&#038;p=442"},"modified":"2021-03-03T10:46:31","modified_gmt":"2021-03-03T10:46:31","slug":"sql-installation-error-27506-21","status":"publish","type":"ht_kb","link":"https:\/\/support.buildsoft.eu\/nl\/knowledge-base\/sql-installation-error-27506-21\/","title":{"rendered":"SQL Installation error 27506 \u2013 21"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>During the installation of Diamonds\/ PowerConnect (version 2017 until 2019r02),\u00a0you get the error:<\/p>\n<p style=\"text-align: center;\"><em>Error 27506. Error executing SQL script install_authentication.sql. Line 17. Warning: Fatal error 6015 occured at {date}. Note the error and time, and contact your system administrator (21)<\/em><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-443 aligncenter\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/03\/gateway_error27506-21.png\" alt=\"\" width=\"489\" height=\"184\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-21.png 489w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-21-300x113.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-21-50x19.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-21-60x23.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-21-35x13.png 35w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/p>\n<p style=\"text-align: left;\">This error is related to the\u00a0database system (= SQL\u00a0instance) used by these versions.<\/p>\n<h2>Solution 1<\/h2>\n<ul>\n<li>Install Diamonds\/PowerConnect\/BIM Expert 2020 or more recent. These versions so a different type of database, which no longer requires the installation of an SQL instance.<\/li>\n<\/ul>\n<h2>Solution 2<\/h2>\n<ol>\n<li>Click the error away.<\/li>\n<li>Close the setup.<\/li>\n<li>Go to C:\\Program Files\\Microsoft SQL Server\\<em>*NameOfTheDatabase*<\/em>\\MSSQL\\DATA<br \/>\n*NameOfTheDatabase* can be MSSQL12.SQLEXPRESS14, MSSQL12.SQLEXPRESS14BS or MSSQL12.SQLEXPRESSBS14<\/li>\n<li>Delete everything of\n<ul>\n<li>bs_Authentication<\/li>\n<li>bs_Exchange<\/li>\n<li>bs_Gateway<\/li>\n<li>bs_UBSM<\/li>\n<\/ul>\n<\/li>\n<li>Run the Diamonds (or PowerConnect) setup again.During the install Gateway will install again. During the install of Gateway you will be asked to select an SQL instance.<br \/>\nInstall a new SQL instance and change the name to something different than before, for. example &#8216;SQLEXPRESS14BS2&#8217; or &#8216;SQLEXPRESS14BS3&#8217;.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3550\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/03\/gateway_installnewdatabase2.png\" alt=\"\" width=\"538\" height=\"410\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_installnewdatabase2.png 538w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_installnewdatabase2-300x229.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_installnewdatabase2-50x38.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_installnewdatabase2-60x46.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_installnewdatabase2-35x27.png 35w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; During the installation of Diamonds\/ PowerConnect (version 2017 until 2019r02),\u00a0you get the error: Error 27506. Error executing SQL script install_authentication.sql. Line 17. Warning: Fatal error 6015 occured at {date}. Note the error and time, and contact your system administrator (21) This error is related to the\u00a0database system (= SQL\u00a0instance)&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[44],"ht-kb-tag":[],"_links":{"self":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/442"}],"collection":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/comments?post=442"}],"version-history":[{"count":4,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/442\/revisions"}],"predecessor-version":[{"id":6379,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/442\/revisions\/6379"}],"wp:attachment":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/media?parent=442"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-category?post=442"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-tag?post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}