Description

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.

error:

× could not insert: [Winshuttle.Central.Business.UserInfo][SQL: INSERT INTO UserInfo (UserTypeId, LoginName, SiteIdentifier) VALUES (?, ?, ?); select SCOPE_IDENTITY()]

Applies To

Foundation 11.x.x & 12.x.x

Cause

SQL connectivity issues.

Solution/Immediate Workaround

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.

Additional Information

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.