Error: Permission denied to write to a temp DB error in Portrait Dialogue 6.1

Portrait Dialogue showing error "Permission denied to write to a temp DB error" while migrating the dialog files from Test environment to Production Environment.

The Visual Dialogue logs show the error "CREATE TABLE permission denied in database 'tempdb'

This can happen due to below-listed points:

1. Temp DB setup in the Dialog Admin.

Check the TempDB setup in Dialog Admin. Navigate to General Admin then System data access and check if TempDatabase and flags for TempDatabase are configured correctly or not.

2. The user of the services and com+ are running under have the correct permissions.

The User/Account running the Dialogue Services and the COM+ has accurate permission or not.

3. Also, checking the COM+ configuration can help in resolving this issue.

UPDATED:  April 10, 2017