Connection issue from analysis to reporting
Home > IT Answers > SQL Server > Connection issue from analysis to reporting
GIG
240 pts.
0
Q:
Connection issue from analysis to reporting
Reporting Services, SSRS, JBSReport database, 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 AUTHORITY\ANONYMOUS LOGON, does not have access to the JBSReport database, or the database does not exist.
Any suggestions will be helpful.
ASKED: Sep 23 2008  8:29 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Application had the needed permission, but that was trumpted by the access level allowed by the OS login account. 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 thread 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.
Last Answered: Sep 28 2008  7:31 PM GMT by Mrdenny   46810 pts.
Latest Contributors: Flame   14495 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

GIG   240 pts.  |   Sep 27 2008  8:55AM GMT

–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.

 
0