You may get an error message when using the API server with the latest patch.
Use this SQL query to add needed permissions to allow the initial startup of the API server to create needed DB tables:
EXEC sp_addrolemember 'db_ddladmin', '{databaseUsername}'
In the above, put in the actual username that is being used to connect to the DB in the "{databaseUsername} section.
To remove the role assignment after the initial startup, use:
EXEC sp_droprolemember 'db_ddladmin', '{databaseUsername}'
Optionally, you can use sqlcmd from an elevated command prompt if you are signed into Windows with an account that has administrator access to your SQL (sysadmin):
Make a note as to the DB and SP Usernames and substitute the correct values in for these commands:
Enable the role to allow the initial FIDO2 process/registration:
sqlcmd -S localhost\SQLEXPRESS -d SurePassDB_2024_2 -Q "EXEC sp_addrolemember 'db_ddladmin', 'spuser_2024_2'"
You can then remove the role assignment since it is only needed on the initial registration of a key:
sqlcmd -S localhost\SQLEXPRESS -d SurePassDB_2024_2 -Q "EXEC sp_droprolemember 'db_ddladmin', 'spuser_2024_2'"