We are attempting to grant access to a database to one of our employees. We open up his user properties in Security -> Logins, navigate to the
User Mappings page, select the database, select
db_owner in the options below, set the default schema to
dbo, then when we click
OK to save the changes, we get the following error:
Create failed for User 'domain\username'. (Microsoft.SqlServer.Smo)
Xml data type is not supported as a parameter to remote calls. (Microsoft SQL Server, Error: 9512)
Any thoughts on why we may be getting this error and what we can do to resolve it?