>I created a report in CR using VS2010. I had to download CR from SAP and get past a myriad of errors. I finally got the report to run.
>
>Then I copied the app to my client's PC and ran it, and the report prompts me for DB login info. I check the Use Integrated Security checkbox, click Finish, and get
>
>
>---------------------------
>Crystal Report Windows Forms Viewer
>---------------------------
>Failed to retrieve data from the database.
>Details: [Database Vendor Code: 18456 ]
>Failed to retrieve data from the database.
>Error in File temp_b8bc73a2-fa84-4548-9c7a-681b52ce4d63 {CAD5A22F-51E7-49C7-8C39-0E260E6DED7F}.rpt:
>Failed to retrieve data from the database.
>Details: [Database Vendor Code: 18456 ]
>---------------------------
>OK
>---------------------------
>
>
>The app uses trusted connection and I'm having no problems getting into SQL for the apps data. It's jjust Crystal that won't cooperate. I checked the SQL logs and found:
>
>
>2011-03-16 20:16:19.76 Logon Error: 18456, Severity: 14, State: 5.
>2011-03-16 20:16:19.76 Logon Login failed for user 'Kevin'. [CLIENT: 192.168.1.191]
>
>
>The 'Kevin' user name is my dev machine login name. My remote user name at the client site is 'kmarois', so the report isn't getting its login info.
>
>Anyone know how to fix this?
>
>
>
>Finally, I have really had it with Crystal Reports. I had always thought that CR was decent product. The MS got ahold of it, and now gave it over to SAP. For YEARS I have been struggling with the same issues, and other programmers at work all say the same thing - when you get it working, it's great. Until then, your screwed. I am going with SSRS from now on.
>
>Good ridence CR.
Did MS ever have ahold of it? Not to my knowledge, but I'm no expert. I thought it went from Seagate to Crystal Decisions to Business Objects to SAP.