The ADFS service account has insufficent privileges to create the Account Activity database.

Question

I keep getting the error "The ADFS service account has insufficent privileges to create the Account Activity database." when running the ADFS Diagnostic. It's the only error I get, everything else passes. I have run the script that is supposed to resolve the problem but it does not (Update-AdfsArtifactDatabasePermission -Credential $cred). It runs without error, but I keep getting the error in diagnostic. I then went into management studio and tried to give my service account permission to everything related to that Adfs Artifact Database but the error continues. Anybody have any ideas - I'm stuck.