Error: Error 27506. Error executing SQL script install_authentication.sql. Line 27.

During the installation of Diamonds/ PowerConnect (version 2017 until 2019r02), you 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 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 the error away.
2. Close the setup.
3. Go to C:\Program Files\Microsoft SQL Server\*NameOfTheDatabase*\MSSQL\DATA
   *NameOfTheDatabase* is usually ‘MSSQL12.SQLEXPRESS14’ or similar containing ‘BS’ (= short for BuildSoft) in the name.
4. Delete all files starting with ‘bs’, like:
   • bs_Authentication
   • bs_Exchange
   • bs_Gateway
   • bs_UBSM
5. 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.
   Install a new SQL instance and change the name to something different than before, for. example ‘SQLEXPRESS14BS2’ or ‘SQLEXPRESS14BS3’.