CM-CFG-029 error when trying to save a configuration that specifies a Microsoft SQL Server content store

In IBM® Cognos® Configuration, you try to save a configuration and the following error message is in the cogaudit.log file:

CM-CFG-029 Content Manager is unable to determine whether the content store is initialized.

EXECUTE permission is denied on object "sp_tables", database "master", owner "dbo'.

This indicates that you do not have the correct permissions to initialize a content store or create a table in the database.

Ensure that the content store user has permissions to use the sp_tables stored procedure in the master database.