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,202 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 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

Technology Partners: 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

Suggested Solutions

Title # Comments Views Activity
moto 4g plus phone lockout time 4 65
Install OSX 10.7 or above on iMac with new Hard drive 10 55
IE book marks 1 16
Antivirus software for Exchange Mail servers 13 80
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
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.
This video shows how use content aware, what it’s used for, and when to use it over other tools.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.

739 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