|
|
||||||
|
#1
09-20-07, 07:04 PM
|
|
|
|
|
> CRM and Reports are on the same box. SQL (named instance) is on a different
[..] > An error has occurred during report processing. (rsProcessingAborted) Get > Online Help > Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection) > Get Online Help. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. > > I have followed the RsSetupTFD document and everything seems to be ok. > > I am not able to get past this error. I also do not see any Network Service > account in SQL. One of the blogs mentioned having this login having access to > certain databases and roles. Also, I get the same error when I try to run report from ReportServer (http://localserver/reportserver) directly. [..] |
|
|
|
#2
09-21-07, 08:50 AM
|
|
|
|
|
Hi,
The trust for delegation message: I saw this many times, it did not affect my singlebox installations. It is not recommended setting having Anyonymous Logon having access to the databases. It seems like reporting services is running ok. Since you are able to see the list of reports directly. Did you check the datasource? Go to http://localserver/reportserver. Click yourinstallation_MSCRM. You see a list of all reports. Click Show Details. When you scroll down you see a datasource (name ending with _MSCRM. The datasource should connect using integrated security. Did you check your internet explorer User Authentication settings? Check your crm server is in the Local Intranet zone. It certainly has to do with ..NET security settings in combination of the Operating System kerberos. Could it be some kind of policy is affecting your installation? Please check your Microsoft.NET Framework Configuration. Best regards, Merijn van Mourik http://crmerijn.blogspot.com "Shikhar" wrote: [..] |
|
#3
09-21-07, 10:14 AM
|
|
|
|
|
Hi Merjin,
I am pretty sure that anonymous logon to database is not set. I can see the list of reports directly but when i run a report, I get this error. The datasource is connected using integrated security. The CRM server is in the network. What do you mean by checking if CRM server is in the intranet zone? How do I do it? Thanks for this reponse!! Shikhar "Merijn van Mourik" wrote: [..] |
|
#4
09-22-07, 08:36 AM
|
|
|
|
|
Hi,
The zone is in Internet Explorer. Tools - Options - Security. Click Local Intranet, and add the crm server to the list of trusted websites. Best regards, Merijn van Mourik http://crmerijn.blogspot.com "Shikhar" wrote: [..] |
|
#5
09-25-07, 12:12 PM
|
|
|
|
|
Hi,
Another suggestion. Please also take a look at the CRM Diag Tool Turbo from Benjamin: http://blogs.msdn.com/benlec/archive...ne-issues.aspx Just go to the download page to the left, create some info reports for crm and for reportings services. The reports show a high level of detail of all settings. Best regards, Merijn van Mourik http://crmerijn.blogspot.com "Shikhar" wrote: [..] |
|
|
| Similar Threads | |
| Issues printing reports in CRM 3.0 A user recently reported an issue with printing reports. When I tried from my machine, I am also having a problem. We had always been able to print in the past, so am not... |
|
| Strange issues with reports So here's the deal. I just started working at an office that is making all of their excel spread sheets into Access databases. No one here knows how to use Access, and so... |
|
| Issues with Queries & Reports Hi there. I had this problem a number of weeks ago, it was left but now I need to get it sorted. Im hoping someone can assist. I shall try to... |
|
| Printer issues with Reports I have Access running on a Windows 2003 network. Developers create databases and share them on the network. The problem I am currently having is that one of my developers... |
|
| crystal reports issues... Hi All, I have just gone through all the necessary steps to rebuild my aps database due to some other issues. This was easy enough and it originally looked as though... |
|
|
All times are GMT. The time now is 06:08 PM. | Privacy Policy
|
Reports Issues