Archiving sales order data error - 'CREATE TABLE permission denied in database ...'
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