"Login failed. Details: [Database Vendor Code: 18456]" when printing report

ISSUE:  Receiving "Login failed. Details: [Database Vendor Code: 18456]" when printing a Crystal report using GP Reports Viewer logged in as a regular GP user.  User 'sa' can run report with no error.

MORE INFORMATION:  Error 18456 is a SQL Server error for an authentication/login issue. 

SOLUTION:  On the GP Reports Viewer - Report Maintenance window (GP | Tools | GP Reports Viewer | Reports), make sure that "Use Default SQL Login and Password from Setup Options Window" is selected for all Crystal reports.

SOURCE:  Support ticket 1187

KB ARTICLE:  20914661

LAST UPDATED:  July 7, 2011

Have more questions? Submit a request


Article is closed for comments.
Powered by Zendesk