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

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