{"id":907,"date":"2017-04-24T09:05:44","date_gmt":"2017-04-24T09:05:44","guid":{"rendered":"http:\/\/buildsoftsupport.com\/?post_type=ht_kb&#038;p=907"},"modified":"2017-05-30T06:31:36","modified_gmt":"2017-05-30T06:31:36","slug":"sql-installation-error-27506-226","status":"publish","type":"ht_kb","link":"https:\/\/support.buildsoft.eu\/nl\/knowledge-base\/sql-installation-error-27506-226\/","title":{"rendered":"SQL Installation error 27506 \u2013 226"},"content":{"rendered":"<p>Error 27506. Error executing SQL script add_groups.sql. Line 26. ALTER DATABASE statement not allowed within multi-statement transaction. (226)<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-908 aligncenter\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/04\/gateway_error27506-226.png\" alt=\"\" width=\"550\" height=\"228\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/04\/gateway_error27506-226.png 550w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/04\/gateway_error27506-226-300x124.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/04\/gateway_error27506-226-50x21.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/04\/gateway_error27506-226-60x25.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/04\/gateway_error27506-226-35x15.png 35w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/p>\n<h2>Solution<\/h2>\n<p>No rights on current SQLExpress, so install a new instance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error 27506. Error executing SQL script add_groups.sql. Line 26. ALTER DATABASE statement not allowed within multi-statement transaction. (226) Solution No rights on current SQLExpress, so install a new instance.<\/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\/907"}],"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=907"}],"version-history":[{"count":1,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/907\/revisions"}],"predecessor-version":[{"id":909,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/907\/revisions\/909"}],"wp:attachment":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/media?parent=907"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-category?post=907"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-tag?post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}