Error connecting to Data Source

[Markzolotoy]

I am getting this while running my paginated report:

Could not connect to the data source.

Data for this report could not be fetched. The data source was found, but the credentials or identity used to connect to the data source were incorrect. Please update the credentials for this report before trying again.

In my report I wasn't specifying any Credentials for the data source. Then I tried all available options there, but all the same.

The data source is configured to use Windows Credentials. What am I missing here?

Thanks

[Shahfaisal · Accepted solution]

The windows account you are using in the connection doesn't seem to have access to the data source (where you are pulling data from). Try connecting to the data source directly using the windows account as a test.

[Shahfaisal · Accepted solution]

The windows account you are using in the connection doesn't seem to have access to the data source (where you are pulling data from). Try connecting to the data source directly using the windows account as a test.

[Markzolotoy · Accepted solution]

Yes, that was the problem. I had to bind that user to the appropriate DB.

[GilbertQ]

Hi @Markzolotoy 

Can you give more details on what your data source is?