{"id":460,"date":"2017-03-29T13:48:30","date_gmt":"2017-03-29T13:48:30","guid":{"rendered":"http:\/\/buildsoftsupport.com\/?post_type=ht_kb&#038;p=460"},"modified":"2021-03-03T10:44:02","modified_gmt":"2021-03-03T10:44:02","slug":"error-27502-could-not-connect-to-microsoft-sql-server-2","status":"publish","type":"ht_kb","link":"https:\/\/support.buildsoft.eu\/nl\/knowledge-base\/error-27502-could-not-connect-to-microsoft-sql-server-2\/","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 &#8216;(local)\\SQLExpress14&#8217;. [DBNETLIB][ConnectionOpen (Connect()).] SQL server does not exist or access denied (17)<\/em><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-461 aligncenter\" src=\"http:\/\/buildsoftsupport.com\/wp-content\/uploads\/2017\/03\/gateway_error27502-17.png\" alt=\"\" width=\"469\" height=\"173\" srcset=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27502-17.png 469w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27502-17-300x111.png 300w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27502-17-50x18.png 50w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27502-17-60x22.png 60w, https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2017\/03\/gateway_error27502-17-35x13.png 35w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/p>\n[NL]: <em>De SQL-server bestaat niet of de toegang tot de server is geweigerd<\/em><\/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>Download MS SQL Express from <a href=\"https:\/\/www.microsoft.com\/en-US\/download\/details.aspx?id=42299\">https:\/\/www.microsoft.com\/en-US\/download\/details.aspx?id=42299 <\/a><\/li>\n<li>Install new SQL instance SQLEXPRESS14, for example SQLEXPRESS14BS<\/li>\n<li>Uninstall Gateway<\/li>\n<li>Install Gateway again<\/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 &#8216;(local)\\SQLExpress14&#8217;. [DBNETLIB][ConnectionOpen (Connect()).] SQL server does not exist or access denied (17) [NL]: De SQL-server bestaat niet of de toegang tot de server is geweigerd This error is&#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\/460"}],"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=460"}],"version-history":[{"count":4,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/460\/revisions"}],"predecessor-version":[{"id":6377,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb\/460\/revisions\/6377"}],"wp:attachment":[{"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/media?parent=460"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-category?post=460"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/nl\/wp-json\/wp\/v2\/ht-kb-tag?post=460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}