1. Home
  2. Gateway
  3. SQL
  4. Error: Error 27506. Error executing SQL script install_authentication.sql. Line 27.

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

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT