/
Archiving sales order data error - 'CREATE TABLE permission denied in database ...'

Archiving sales order data error - 'CREATE TABLE permission denied in database ...'

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
2 min read

Problem

Running the archiving Maintenance routine for Sales Orders errors with 'Error: CREATE TABLE permission denied in database 'xxxxxx'.

Solution

The SQL user JiwaUser needs to be member of the Role 'sysadmin'

SQL skills are required

A good working knowledge of SQL Server Management Studio is required to perform this task

Load up SQL Server Management Studio and connect to the relevant SQL Server

  • Expand Server Roles under Security

  • Right mouse click sysadmin and select Properties

  • Click Add and then Browse and JiwaUser from the list of users

  • Click OK, OK and JiwaUser is now a member of sysadmin

  • Archiving of sales orders can now be done

Related articles

Related content