Issue

During the installation of K2 Connect 5.0 the following errors occurs:

[Microsoft][ODBC SQL Server Driver][SQL Server]The database 'DB-Name' does not exist. Supply a valid database name. To see available databases, use sys.databases

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'X'

Error #1:

Image

Error #2:

Image

Symptoms

The error occurs if any of the following is true:

  • Your Database name starts with a Number
  • You have a "-" in your database name.

Resolution

Microsoft recommends not having numbers starting your database name:

https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-2017

Using a hyphen in your database name causes the second error, this is a known bug.

If you are still experiencing the same error after removing the number from the beginning of the DB Name and removed the Hyphen, this could be due to the existing SQL script not being updated. To resolve this:

  1. Navigate to the following location: C:\Users\[myUser]\AppData\Local\Temp
  2. Cut + Paste the contents of the folder to a different folder
  3. Run the K2 Connect Installer again.