Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. App-V database jobs fail with error - “Executed as user dbo. The server principal “sa” is not able to access the database under the current security context. [SQL State 08004] error 916”.

App-V database jobs fail with error - “Executed as user dbo. The server principal “sa” is not able to access the database under the current security context. [SQL State 08004] error 916”.

Symptoms

The App-V Management Server installation creates database jobs in the SQL jobs section. When one of the database jobsis executed, the job fails with the error message:

“Executed as user dbo. The server principal “sa” is not able to access the database under the current security context. [SQL State 08004] error 916”.

↑ Back to the top

Cause

The correct database is not selected in the SQL Server jobs configuration.

↑ Back to the top

Resolution

1. Open SQL Management Studio. 

2. Navigate to the SQL Server Agent\Jobs node in Object Explorer.

3. Open “Properties” for the Job.

4. Select the Page for “Steps” in the left pane.

5. Select “Edit” and change the database name to the App-V Database being used. (e.g. APPVIRT).

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2597203
Revision : 2
Created on : 3/27/2020
Published on : 3/27/2020
Exists online : False
Views : 121