SSRS Error: Cannot create a connection to data source ‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’

image

Have you ever gotten the following error when attempting to run a SQL Reporting Services ConfigMgr report?

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot create a connection to data source ‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’. (rsErrorOpeningConnection)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

Resolution

Log in to the server running your Active Directory service and execute the following steps:

  • Run Adsiedit.msc
  • In the ADSI Edit snap-in, expand Domain [YourDomainName], expand DC= RootDomainName, expand CN=Users, right-click CN= [YourAccountName, and then click Properties.
  • In the CN= AccountName Properties dialog box, click the Security tab.
  • On the Security tab, click Advanced.
  • In the Advanced Security Settings dialog box, select one (any) of “SELF”‘s row
  • Click Edit, Open Permission Entry dialog box.
  • Make sure Pricipal is “SELF”, Type is “Allow” and “Applied to” is “This Object Only”, in Properties section, select the properties below:
    • Read servicePrincipalName
    • Write servicePrincipalName

Click OK to apply all changes and exit the ADSI Edit snap-in

Finally, you need to restart the SQL Service(s) that use the account in question.

Credit: https://cmatskas.com/fixing-error-cannot-generate-sspi-context-after-changing-sql-service-account/

I always repost a solution that helps me out. I call them Good Point…

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.