"Failed to enable SQL PI monitoring extension for agent xxx: User does not have permission to alter database xxx, the database does not exist, or the database is not in a state that allows access checks"
The new repository database can be created successfully, but schema creation will fail. No tables or index can be found in the database.
WORKAROUND
Manually grant the DB user "db_owner" role for the new created PI repository database.
Enable SQL PI by selecting the "Create a New PI Repository Database for SQL Server" option and using the same database name as the newly created database.
STATUS
This issue has been logged as known issue FOG-728.
