I've actually got two other working installs of UF on my local dev environment, one with SQL Server and one with MySQL, and just ran into this when setting up a third clean install with SQL Server again while running php bakery bake
I started with a clean git pull so there have been zero modifications to the source files.
[ERROR] SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]
'DF_1483A5E9_FE54D947' is not a constraint.
(SQL: ALTER TABLE users DROP CONSTRAINT DF_1483A5E9_FE54D947)
It's happening in the "UserFrosting's Migrator" section of the bake. The first time I ran it, it reported successfully migrating up through
Migrated: \UserFrosting\Sprinkle\Account\Database\Migrations\v430\UpdateGroupsTable
But now every time I attempt another bake, it just immediately gives the above error and exits when the Migrator section starts.
I can actually access the default installed website through the browser and it looks OK, (I ran build-assets separately after encountering the error), however if I look at the database it looks to me like it's missing a few tables. Specifically sessions and throttles I see in my other installation's DB. So I'm guessing there will be something that breaks at some point.
I'd really like the bake to complete without errors... does anyone have any idea what this error means or how to work around it? The only other thing that I know is different is my working installation that also uses SQL Server has a slightly different collation (for other reasons)... I can't imagine that would be the issue with a missing constraint key in the bakery scripts ...but maybe???