Now that it's live, don't forget to accept your certification badge on Credly today! Learn more 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

JLinAltX
Alteryx
Alteryx
Created

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>
 

image.png


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

 
No ratings