The job failed. Unable to determine if the owner (KTT\svc_ssrs19) of job

The job failed:  Unable to determine if the owner of job 6E9E6DB4-E0BE-4F9A-8A99-9F21C6621385 has server access (reason: Could not obtain information about Windows NT group/user ‘(KTT\svc_ssrs19)’, error code 0x5. [SQLSTATE 42000] (Error 15404)).

Error Message

Message: The job failed.  Unable to determine if the owner (KTT\svc_ssrs19) of job 6E9E6DB4-E0BE-4F9A-8A99-9F21C6621385 has server access (reason: Could not obtain information about Windows NT group/user ‘KTT\svc_ssrs19’, error code 0x5. [SQLSTATE 42000] (Error 15404)).

Impact

  1. All the standard subscriptions OR data driven subscription worked as expected in the SSRS/PBIRS web portal URL’s earlier but suddenly it failed giving “The job failed
  2. Suddenly out of nowhere, the old subscriptions and the new created ones are not got triggered till date
  3. Verified with SA account for SQL agent which is worked as expected
  4. The problem only happens with Domain Account, now if you see the error message in the above, you can find or see this domain account “KTT\svc_ssrs19.” This is my SSRS service account and all the subscriptions or triggered from SSRS portal/application
  5. Unable to determine if the owner (KTT\svc_ssrs19) of job” This could also happen with NT service account; do you have to make sure you follow the same steps or troubleshooting which we are going to see in this article.
The job failed

Troubleshooting

Now, if you see the complete error you will find “Windows NT group/user ‘KTT\svc_ssrs19” it means that windows NT group is not authorizing to connect to sql due to some AD stuff. Now if we update the SSRS/PBIRS sa account under windows authorization group it will resolve the issue.

Please follow the steps below to add user or authorize him the correct permissions:

Step 1: Go to your active directory domain controller (DC) and under built in account look for “Windows Authorization Access Group” and go to properties.

Unable to determine if the owner (KTT\svc_ssrs19) of job

Step 2: Go to members and add the users/account/computer name/hostname of the SSRS machine if it is default NT service account and hit apply and ok! to avoid ‘The job failed error’

sql agent job

Step 3: Now you can go to the machine of SSRS/PBIRS and SQL Server and do GP update or also you can do restart of the machine to affect the changed immediately. Note: Sometimes it will take up to 1 hours in some cases to effect the changes, but you should have patience’s and keep trying every 10-15 minutes.

gpupdate /force
gpupdate

Hope this will resolve the issue, if not please check this doc to trouble subscription issue in SSRS/PBIRS: Subscription Failure: SSRS/PBIRS Scheduled Subscription Fails and to check error logs follow this doc!

TSG’s

  1. RDCMan Scaling Is Blurry: Fix In 3 Steps (kingfishertechtips.in)
  2. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  3. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  4. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  5. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  6. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  7. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  8. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  9. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  10. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  11. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  12. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  13. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  14. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  15. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  16. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 112

Leave a Reply

Your email address will not be published. Required fields are marked *