Solved

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

Posted on 2006-10-31
4
3,198 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 500 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adobe Acrobat DC "Out of Memory" 7 207
What's a good Free Firewall Program for Mac OS? 7 41
Dropbox 3 72
How to open a .vcf file 11 49
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
Viewers will learn how to use the Hootsuite Dashboard.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now