SSRS -- The report server couldn't connect to the data source....

Question

SQL Server and SSRS 2019

Greetings. I'm trying to create an SSRS data source using one of our service accounts in the "Use the following credentials" box with a Type of "Windows user name and password".

Here's some interesting fun facts:

1. I can replace this account with my personal account in the credentials box and it works.
2. Looking in both the SQL error log and running a Failed Login trace I can verify that when attempting to connect w this account, it's not that it's getting to the server and being denied, it's simply not making it to the server.
3. I can open SSMS, pointed to the same SQL Server that my DS is pointed to, with the service account, without issue.
4. This guy had the same issue but in PBI.

Of course I realize how bizarre this is, which is why I'm posting.

Any ideas? Thanks!

Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details

Log on failed. Ensure the user name and password are correct.

Answer 1

Hi @chrisrdba

Yes, as Erland said, is the service account you choose a local account or a domain account? Did you grant it local logon rights?

For more details, you can refer to this link: https://learn.microsoft.com/en-us/answers/questions/224341/ssrs-report-error-cannot-impersonate-user-for-data.

Best regards,

Aniya