{"id":449,"date":"2017-03-29T13:21:40","date_gmt":"2017-03-29T13:21:40","guid":{"rendered":"http:\/\/buildsoftsupport.com\/?post_type=ht_kb&#038;p=449"},"modified":"2021-03-03T10:45:30","modified_gmt":"2021-03-03T10:45:30","slug":"error-27506-error-executing-sql-script-install_authentication-sql-line-27","status":"publish","type":"ht_kb","link":"https:\/\/support.buildsoft.eu\/nl\/knowledge-base\/error-27506-error-executing-sql-script-install_authentication-sql-line-27\/","title":{"rendered":"Error: Error 27506. Error executing SQL script install_authentication.sql. Line 27."},"content":{"rendered":"<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 27. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (1802)<\/em><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-450 aligncenter\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/03\/gateway_error27506-1802.png\" alt=\"\" width=\"482\" height=\"182\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-1802.png 482w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-1802-300x113.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-1802-50x19.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-1802-60x23.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27506-1802-35x13.png 35w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/><\/p>\n<p>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<em>*NameOfTheDatabase*<\/em>\u00a0is usually &#8216;MSSQL12.SQLEXPRESS14&#8217; or similar containing &#8216;BS&#8217; (= short for BuildSoft) in the name.<\/li>\n<li>Delete all files starting with &#8216;bs&#8217;, like:\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>During the installation of Diamonds\/ PowerConnect (version 2017 until 2019r02),\u00a0you get the error: Error 27506. Error executing SQL script install_authentication.sql. Line 27. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (1802) This error is related to the\u00a0database system (= SQL\u00a0instance) used by these versions&#8230;.<\/p>\n","protected":false},"author":2,"comment_status":"closed","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\/449"}],"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=449"}],"version-history":[{"count":3,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/449\/revisions"}],"predecessor-version":[{"id":6378,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/449\/revisions\/6378"}],"wp:attachment":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/media?parent=449"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-category?post=449"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-tag?post=449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}