Job Service jobs fail with error message "[810143] Database error 916" (4326248)

Job service jobs fail with an error message resembling:

"[810143] Database error 916: The server principal "NT Authority\System" is not able to access the database "OneIM" under the current security context."

In general, the SQL Server error message above indicates a permission issue on the database side.  The given database user for the connection is not allowed to access the given database.

However, this article addresses the following specific error situation:

- Front end tools are working

- Job service loads jobs normally and tries to process them

- Many of these jobs fail with the given error message which can be seen in the ErrorMessages field in the table jobqueue

In this particular instance, the cause for the error is an incorrect ConnectionString in DialogDatabase. Any jobs where the task has a ConnectionString parameter will copy the incorrect information from DialogDatabase into the job parameter during job generation.

Please note that the following resolution only works for the given specific error situation, but the error message could occur in various other situations.

- In Designer go to Base Data, expand General and select Databases

- Select Main Database and then select the Settings tab and update the Connection parameter.

Please note that existing jobs will need to be regenerated that have the incorrect connection parameter.