Keep getting this error regardless to the accoun tused

Belgian Malinois 421 Reputation points
2024-05-13T01:25:46.7933333+00:00

SQL server 2022 / SSRS 2022, getting this error even when using an admin account

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot impersonate user for data source 'AutoGen__5C6349F2_4BB6_4a1b_A16E_8D69795D8602_'. (rsErrorImpersonatingUser)
      • Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
        • Logon failure: the user has not been granted the requested logon type at this computer
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,951 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 38,621 Reputation points
    2024-05-13T06:11:50.6733333+00:00

    Hi @Belgian Malinois,

    Please help check if you have chosen this opinion in your datasource.

    User's image

    Please also try to grant "Allow log on locally" permissions to domain user accounts.

    1.On the report server computer, in Administrative Tools, open Local Security Policy.

    2.Under Security Settings, expand Local Policies, and then click User Rights Assignment.

    3.In the details pane, right-click Allow log on locally and then right-click Properties.

    4.Click Add User or Group.

    5.Click Locations, specify a domain or other location that you want to search, and then click OK. 6.Enter the Windows account for which you want to allow interactive login, and then click OK.

    7.In the Allow log on locally Properties dialog box, click OK.

    8.Verify that the account you selected does not also have deny permissions: a. Right-click Deny log on locally and then right-click Properties. b. If the account is listed, select it and then click Remove.

    More details please refer specify-credential-and-connection-information-for-report-data-sources

    Remember to restart SSRS server and test. Hope it will be helpful.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.