...
Run the following script against the ASWBCentral database to add the proper role to the user
Code Block language sql DECLARE @Email VARCHAR(256) = '<Replace with email>' DECLARE @StaffUserID VARCHAR(256) = '<Replace with your username (radach,brutherford, etc>' DECLARE @UserID VARCHAR(50) = (SELECT TOP 1 UserID FROM dev_person_expanded dpe LEFT JOIN EmailAddresses ea ON ea.ContactID = dpe.ContactID WHERE dpe.[Role Email] = @Email or ea.[Address] = @Email) INSERT INTO ASPNetUserRoles (UserID, RoleID, StartDate,IsActive,LastUpdatedBy,LastUpdatedDate) VALUES (@userID,'54A2ED95-1740-4C27-B8B0-66D1193667BB',GETDATE(),1,StaffUserID@StaffUserID,GETDATE())
If the script completes successfully, go to the “Add Staff to School” section.
...