Go Premium for a chance to win a PS4. Enter to Win

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,205 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
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The main intent of this article is to make you aware of ‘Exchange fail to mount’ error, its effects, causes, and solution.
Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
Viewers will learn how to use the Hootsuite Dashboard.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

963 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