Error: Error 27502. Could not connect to Microsoft SQL Server

During the installation of Diamonds/ PowerConnect (version 2017 until 2019r02), you get the error:

Error 27502. Could not connect to Microsoft SQL Server ‘{yourdomain\yourserver}’. Login failed. The login is from an untrusted domain anc cannot be used with Windows authentication. (18452)

This error is related to the database system (= SQL instance) used by these versions.

Solution 1

• 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.

Solution 2

1. Click ‘Ok’
2. Cancel the setup
3. Run the Gateway setup again
4. Select a local database instance, for example ‘(local)\SQLExpress14’. 
5.  If there is no local database instance available, you should install a new one.