Mismatches in SQL Server database names cause inscrutable migration errors

XMLWordPrintable

    • Severity 3 - Minor

      If the database's name is "stash" (lowercase "s") and "Stash" (uppercase "S") is entered in the database name during migration (or setup), the following error will be produced:

      The database name component of the object qualifier must be the name of the current database.
      com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
      com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
      

      Due to an error handling regression in 2.7.0 from changes made to support backup and restore, the exception details are hidden and the UI simply shows "A database error has occurred."

      NOTE: Don't trust third party connection parameters as they mask the problem. Connect directly using SQL Server Management Studio and confirm the name or connect from the command line and run

      EXEC sp_databases

      . Confirm connectivity by using brackets in SQL calls, e.g.:

      select * from [Stashdb].[dbo].[DATABASECHANGELOG]

            Assignee:
            Unassigned
            Reporter:
            Bryan Turner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: