Running a report against Crystal Reports Server, permission issues?
Posted on 2011-05-04
Not sure if anyone has any good "tips" on my issue here, recently we are upgrading our custom ERP system's report server to a new OS, going from Windows 2003R2 SP2 to Windows 2008R2 x64 SP1.
One issue that I ran into is related to Crystal Reports XI R2 .NET 2005 Server (SP4) and trying to produce reports.
Basically, we have a Report Service (custom software) that is on the report server box, that accepts new jobs and processes them against the Crystal Reports, everything in the big picture works.
However the issue I am running into is, the crystal report produced (pdf) has different outcome depending on what user the report service is set to run under, if I give it a domain user (and setup group policy to enable logon as batch and logon as service) the end report is produced fine.
However, if I set the report service to run under "Local System" (which worked in our previous box) the report produced (pdf) has "bolded" headers where it should not, causing some lines in the report to overlap.
The strange thing is, the cause is controlled by the user the service process is running under, any clue as to why Crystal Reports would play nice with one and not the other?
Could it be that a service running under Local System that is talking to Crystal Reports does not work nicely, maybe limited access in some places where a network account would have better access.
All the files for the reports are local to that machine.
I don't think it has to do with the custom report processing software we have but something related to permissions/access in Windows 2008R2 where a network account works better than a local system account.
Just trying to identify the root cause as to what is failing when the service is ran under the local system account.
Any help or pointers is appreciated, thanks.