Description

When trying to add a new user or perform any other tasks on the foundation you get the below error:

The Execute permission was denied on the object 'sp_xml_preparedocument'.database'mssqlsystemresource'. schema 'sys'.

Applies To

Foundation 11.x and 12.x

Cause

Error

Solution/Immediate Workaround

The error Execute permission was denied on the object 'sp_xml_preparedocument'.database'mssqlsystemresource'. schema 'sys'

is a SQL Database error and not related to Foundation.

The  sp_xml_preparedocument  is a Stored Procedure (SP) of SQL used for XML.

When reviewing the error message it seems that the permissions to execute this StoredPorcedure has been removed.

We suggest you get in touch with your Database Administrator and if further assistance is required to seek help from Microsoft support.

https://microsoft.public.sqlserver.server.narkive.com/4yOXUYjv/execute-permission-denied-on-sp-xml-preparedocument


https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-xml-preparedocument-transact-sql?view=sql-server-ver15

Additional Information