Skip to Content

printing crystal report causes invalid database login error

pleases don't delete this question.


I entered this ticket previously only to find it was deleted. Someone had sent a message asking me to post how I searched for a resolution before posting in accordance with the rules. I see a rule that says search before you post nothing saying how we should post proof that we did so. I can add a bunch of links to posts about how the error returned is from the database but if you look you will see in the details of the question they don't apply to my situation.


using BI platform 4.1 sp2

i upload a crystal report

set the database config to

uncheck allow users to edit

set to use same database logon as when report is run

use custom database logon

ODBC

input info

i can run the report in bi launchpad

i can schedule it to send as pdf in an email

when i set it to print to a specified printer and e-mail pdf i get
Database Vendor Code:18456

I can schedule the job to print and it will fail... I can right click the reoccurring--> reschedule --> run now --> remove printing and it will run as expected

something in the combination of this report and trying to print causes the report to use an invalid login

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 18, 2016 at 03:00 PM

    Is the printer and the SIA running on the same domain? If not, can you change the SIA to run on the same domain as your printer is running?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 03:04 PM

    Hi B,

    Sorry about that, deleting your original post. You are correct, the Rules of Engagement only indicates to search, it does not say to post what you found. Seems our Moderator Training material is not the same as what is published externally.

    We are working on this....

    Is the printer installed locally, on the BOE Server? It is a requirement, and do not use the Windows XPS driver, it has issues and can cause problems.

    Some PDF printer drivers also have problems, be sure to make it available for all processes, see this MS KBA on how to expose printers to all Accounts:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;184291

    BOE/CR is simply passing the error message from the DB to you, what does that error code mean for your DB?

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 06:38 PM

    Hi,

    If two other reports are working, then I'm wondering if this one report has a subreport in it. Could the subreport be using different logon credentials than the main report?

    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2016 at 08:59 PM

    There should be other numbers related to that error code.

    From my Google searching it appears it could be permissions for the BOE user.

    Make sure the same DB client is installed also.

    Don

    Add comment
    10|10000 characters needed characters exceeded