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

chrisrdba 301 Reputation points

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,824 questions
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,362 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 5,631 Reputation points Microsoft Vendor

    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:

    Best regards,