Connection issue from analysis to reporting

240 pts.
Tags:
JBSReport database
Reporting Services
SSRS
SSRS reports
I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'ClientClientName'. (rsErrorExecutingCommand) Either the user, NT AUTHORITYANONYMOUS LOGON, does not have access to the JBSReport database, or the database does not exist. Any suggestions will be helpful.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check to see if the account you are logged into on the remote machine has the required permissions to access the server in question. I’ve had cases where the user account for the <b><i>Application</i></b> had the needed permission, but that was trumpted by the access level allowed by the <b><i>OS login account</i></b>. The application said “yes” but the OS said “no”…the OS wins.
Good Luck
-Flame

———

By granting access to the NT AUTHORITY account into your analysis server you can effectively granted everyone access to the SSAS database. This includes anyone who breaks into your network any tries to access the SSAS database.

The problem you are having is the NTLM double hop issue. This <a href=”http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3600159&SiteID=17″>thread </a>shows how to setup the systems to work around the double hop issue. If you can setup SSAS with a SQL Login instead of a Windows login (it’s been a while since I’ve worked with SSAS security) then you can setup the SSRS report to log into the SSAS server using that login instead to get around the issue. I would definitely recommend removing the NT AUTHORITY login from the SSAS server ASAP.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GIG
    --Thanks for the answer, I have to provide the access to NT AUTHORITY for the analysis server. After providing the access, i could access the report.
    240 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following