MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / Error: "CREATE TABLE permission denied in database" writing to SQL Server with Create Table Out...
Error: "CREATE TABLE permission denied in database" writing to SQL Server with Create Table Output tool option
user

Created/Edited - 5/6/2026 by Jon Lin | Alteryx

Summary
Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.
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>

 

 

Prerequisites
  • 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 Information
Was this article helpful?