Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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



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


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




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