19/شوال/1428 11:28 م
I can access the reports at CRM server but if i try to access same CRM reports from any other computer on the LAN then i receive Following error. I am using Administrative Account.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Interestingly, if i open any report once at CRM server, then i am able to open reports from any other computer also for few minutes. And when some kind of session expires then i get same error.
20/شوال/1428 07:12 صالمشرفIt's most likely that the problem is to do with Active Diretory delegation. See http://www.microsoft.com/downloads/details.aspx?FamilyID=51bf9f20-bd00-4759-8378-b38eefda7b99&displaylang=en
20/شوال/1428 08:07 ص
1. Set the Internet Explorer User Authentication to "Automatic logon only in Intranet zone".
2. Add CRM and report server to Trusted Zones in the IE
3. Make sure that the "Enable Integrated Windows Authentication" option in the IE is checked
24/ذو القعدة/1428 08:31 صالمشرف
And if your browser is set correctly and you and see the SPNs with the setspn tool at the command prompt, consider the connection string in SSRS.