Skip to main content
Planview Customer Success Center

Error in scheduled jobs: permission on DBCC TRACEON is missing V2014

Symptoms

The job history display in SQL Management Studio shows errors in some jobs.

Executed as user: CPSQLUser. User 'CPSQLUser' does not have permission to run DBCC TRACEON


Reason

The scheduled jobs normally run with system privileges and not as CPSQLUser (or CPAdmin / CPUser). That user is used to run the web site and does not have (and does not need) any system privileges.

Resolution

The scheduled jobs normally run with system privileges and not as CPSQLUser (or CPAdmin / CPUser). That user is used to run the web site and does not have (and does not need) any system privileges.