While the Forefront Identity Manager Service did connect and authenticate with the SQL Server, its credentials are not sufficient ...

While the Forefront Identity Manager Service did connect and authenticate with the SQL Server, its credentials are not sufficient to perform necessary operations in the database.

The most likely cause is the Forefront Identity Manager Service's account only has read permissions when both read and write permissions are required.

Verify that the Forefront Identity Manager Service account has both read and write permissions to the SQL Server database.