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