Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

"Database Vendor Code: 18456" appears when an employee tries to open a crystal report I have created.

Posted on 2006-10-31
4
Medium Priority
?
3,204 Views
Last Modified: 2008-02-12
I have created a Crystal Report for a sql database and only a domain administrator can open it without having to put in a password.  When I created the report I set it up as a trusted connection.  Is there any way a non-domain administrator can open up this report without having to type in the system admin password?  I also tried to open this with a simple report viewer and I get the same error code.  Any ideas?
0
Comment
Question by:bgarrabrant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 44

Accepted Solution

by:
scrathcyboy earned 1500 total points
ID: 17847202
NO,  once protected, it cannot be undone.  But why not just do the report again, and export it without any special permissions?  That will let everyone get access to it.  To redo the report is easier than trying to hack the permissions on the existing report, no?
0
 

Author Comment

by:bgarrabrant
ID: 17850361
I have tried to create the report with a domain user login and I get the same error code.  It still will not let me enter the SA password and set it up as a trusted connection.  There has to be a way a user can view a report without giving them the system admin. password.  
0
 
LVL 44

Expert Comment

by:scrathcyboy
ID: 17855158
No, not if it was created with admin rights.
0
 

Expert Comment

by:aimsupport
ID: 29977063
When ever I try to open OEINV04.RPT in sage accpac
It gives me the following error.

Description: ERROR: LoadLibrary
Source: 20:15:14

I have SAGE ACCPAC 500 series enterprise version
Accpac is on the local machine . Shared data on the server
Installed service pack 1 & 3 with MS SQL Version.
 
Report Name: OEINV04.RPT
Module Order Entry> O/E Forms > Invoice

Please help us find the solution and email me at
shawn @ aiminsight . com (remove spaces please)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
Viewers will learn how to use the Hootsuite Dashboard.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question