{"id":1150,"date":"2017-06-16T08:01:23","date_gmt":"2017-06-16T08:01:23","guid":{"rendered":"http:\/\/buildsoftsupport.com\/?post_type=ht_kb&#038;p=1150"},"modified":"2021-03-03T10:39:12","modified_gmt":"2021-03-03T10:39:12","slug":"error-27502-could-not-connect-to-microsoft-sql-server","status":"publish","type":"ht_kb","link":"https:\/\/support.buildsoft.eu\/nl\/knowledge-base\/error-27502-could-not-connect-to-microsoft-sql-server\/","title":{"rendered":"Error: Error 27502. Could not connect to Microsoft SQL Server"},"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 27502. Could not connect to Microsoft SQL Server \u2018{yourdomain\\yourserver}\u2019. Login failed. The login is from an untrusted domain anc cannot be used with Windows authentication. (18452)<\/em><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1151 aligncenter\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/06\/gateway_error27502-18452.png\" alt=\"\" width=\"346\" height=\"136\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_error27502-18452.png 346w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_error27502-18452-300x118.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_error27502-18452-50x20.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_error27502-18452-60x24.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_error27502-18452-35x14.png 35w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/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 &#8216;Ok&#8217;<\/li>\n<li>Cancel the setup<\/li>\n<li>Run the Gateway setup again<\/li>\n<li>Select a local database instance, for example &#8216;(local)\\SQLExpress14&#8217;.\u00a0 <img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-1157\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase.png\" alt=\"\" width=\"378\" height=\"288\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase.png 538w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase-300x229.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase-50x38.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase-60x46.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase-35x27.png 35w\" sizes=\"(max-width: 378px) 100vw, 378px\" \/><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-1158\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase_localserver.png\" alt=\"\" width=\"378\" height=\"288\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase_localserver.png 538w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase_localserver-300x229.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase_localserver-50x38.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase_localserver-60x46.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_selectexistingdatabase_localserver-35x27.png 35w\" sizes=\"(max-width: 378px) 100vw, 378px\" \/><\/li>\n<li>\u00a0If there is no local database instance available, you should install a new one.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-1156\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/06\/gateway_installnewdatabase.png\" alt=\"\" width=\"380\" height=\"289\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_installnewdatabase.png 545w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_installnewdatabase-300x228.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_installnewdatabase-50x38.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_installnewdatabase-60x46.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/06\/gateway_installnewdatabase-35x27.png 35w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>During the installation of Diamonds\/ PowerConnect (version 2017 until 2019r02),\u00a0you get the error: Error 27502. Could not connect to Microsoft SQL Server \u2018{yourdomain\\yourserver}\u2019. Login failed. The login is from an untrusted domain anc cannot be used with Windows authentication. (18452) This error is related to the\u00a0database system (= SQL\u00a0instance) used&#8230;<\/p>\n","protected":false},"author":3,"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\/1150"}],"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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/comments?post=1150"}],"version-history":[{"count":3,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/1150\/revisions"}],"predecessor-version":[{"id":6371,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/1150\/revisions\/6371"}],"wp:attachment":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/media?parent=1150"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-category?post=1150"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-tag?post=1150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}