We help IT Professionals succeed at work.

Citrix and Cyrstal Reports 8.5 - Accessing ODBC Data Source

pcournyer asked
Last Modified: 2013-11-15

We are running crystal reports 8.5 out of Citrix Presentation Server 4.0 - We have four citrix servers in our farm they are running windows 2003 service pack 2. The issue that im expereing is the following : Any new user that i create in Active Directory and give them the group memberships for citrix crystal reports which is the group that has access to run crystal reports gets the following error message: File Warning the operating system denied access to the specified file. If i give the new user i created domain admin rights they do not have any problem. Ive attached a file with screen shots of the Error and when it occurs. They can launch crystal reports just fine but when they go to open the easylender datasource they get error message. Any help would be greatly appreciated.

Watch Question

add the user to be a member of local admin group on the citrix server and you should be able to run.


Sure that works but i have existing users that dont need to be added to make it work. Thanks for the reply
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Compare the permissions including directory permission where the reports are and the Crystal directories.



Check Permissions they are the same on each of the servers. As far as the reports this occurs when i try and access the odbc data source. Thanks for the reply
ok..Can you please compare the group membership of existing user in citrix and the newly created user...i think there i some conflict in groups...just make sure to add the new user in to the same groups of a existing user in citrix.....

Make sure both the users are in same groups


Yep they have the same memberships . I thought about that to. Its funny if i copy a user that works then the new user works. If i create a new user and give the same permissions it does not work. Strange. thanks for the reply.
ok.other than group membeship, did you have any delegated permission settings on the AD OU level....may the old user in different OU with a different OU permission...did you try to create the new user on the same ou and try....


The user that i copied and the user that i created our both in the same OU . This makes no since to me why this not working correctly. Thanks for the ideas
ok...its weird.

How many domain controllers you have in your domain ?
When you try to create a new user see in which domain controller is created ?
When you have multiple DC's and you connect AD using the AD users and computers, on the top of the console you can see on which DC you are connected.....try to change the DC and create a new user....


We have 13 domain controllers in our domain. Ok i tried that and i get the following error message: Cyrstal Reports : An unnamed file contains an invalid path.

Use Filemon/regmon from sysinternals (microsoft nowwadays) www.sysinternals.com to get a chanse to see what file(s)/Reg keys that cannot be accessed. Then, if the file/registry exist, asign the proper security settings for this/those files. It has to be a access rights issue.

Technical Assurance & Implementation
This one is on us!
(Get your first solution completely free - no credit card required)


Issue is resolved it had to do with a profile. thanks for all the help

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.