Error: "CREATE TABLE permission denied in database" writing to SQL Server with Create Table Output tool option

[JLinAltX]

Issue
 

Outputting to SQL Server by the Output Tool option Create New Table results in CREATE TABLE Permission Denied.
 

Error creating table <table name>;[Microsoft][SQL Server Native Client 11.0][SQL Server] CREATE TABLE permission denied in database '<database name>'. CREATE TABLE <script>

 

Environment Details

 

• Alteryx Designer, Server 
  • All versions
• SQL Server
  • All versions

Cause

User running the workflow do not have CREATE TABLE permission to the SQL Server database.

 

Resolution

You will need to consult with your DBA (Database Administrator) for permission to CREATE TABLE on the SQL Server database. 

You can do the following tests to validate if you lack permission to create a table.
 

1. From SSMS (SQL Server Management Studio), log in and try to run a CREATE TABLE into the same database you want your Alteryx workflow to run against.
2. You maybe able to check your permission by running this query in SSMS: SELECT * FROM fn_my_permissions (NULL, 'DATABASE');    

 

Additional Resources

 

• Microsoft sys.fn_my_permissions (Transact-SQL)