Can't assign a license to a new user in Foundation. I can add the user to a new group, but can't assign a licence. Also when performing other actions SQL errors are thrown.
× could not insert: [Winshuttle.Central.Business.UserInfo][SQL: INSERT INTO UserInfo (UserTypeId, LoginName, SiteIdentifier) VALUES (?, ?, ?); select SCOPE_IDENTITY()]
Foundation 11.x.x & 12.x.x
SQL connectivity issues.
The root cause was an incorrect SQL connection to a SharePoint server.
After re-connecting to the right server, we could assign new licenses to users.
Please be aware that if you are having random failures on the Foundation with SQL insert errors then you might want to check if you are running out of Disk Space on your SQL Server.
You might also want to get in touch with your DB Admin to verify the Database (DB) health and if their is connectivity between your SharePoint and SQL Database.