CODEWITHSUNDEEP
sqlsql-serverreporting-services
Nawaf
Nawaf

Reputation: 540

Data Source Connection in SSRS

I have created a report using SSRS when the report is publish to the SSAS server (Different than DB Server), and I am trying to access the report I got strange error.

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DD_BE'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS

then i go back to check the data source connection. i set the credential is to use windows authentication (integrated). enter image description here

here the connection in Data tool is fine enter image description here

every thing seems fine here then I go to check SSRS Manager to check Data Source. enter image description here

And I changed the credential and I got different error. enter image description here

Upvotes: 1

Views: 7285

Answers (1)

Pintu Kawar
Pintu Kawar

Reputation: 2156

Check the option Use as Windows credentials when connecting to the data source.

Upvotes: 1

Related Questions