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,196 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
Comment Utility
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
Comment Utility
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
Comment Utility
No, not if it was created with admin rights.
0
 

Expert Comment

by:aimsupport
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

772 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

14 Experts available now in Live!

Get 1:1 Help Now