xDM

How Can I Resolve "CREATE TABLE permission denied" error in SQL Server?

When attempting to Create New Data Location(using SQL Server), the operation may instead fail with a CREATE TABLE permission denied in database 'X' error.

Using a client such as SQL Server Management Studio, connect to the database and open the properties for the connecting user account. Add the db_owner role membership, then click OK and re-attempt the operation.