Sign in

Microsoft.com

Microsoft

Remove From My Forums

Reports Issue - Login failed

Question
0

Sign in to vote

Hi All,
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.

Wednesday, October 31, 2007 11:28 PM

Answers

0

Sign in to vote

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

Thursday, November 1, 2007 7:12 AM

Moderator

All replies

0

Sign in to vote

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

Thursday, November 1, 2007 7:12 AM

Moderator
0

Sign in to vote

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

Thursday, November 1, 2007 8:07 AM
0

Sign in to vote

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.

Tuesday, December 4, 2007 8:31 AM

Moderator