>>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.
I don't think Microsoft ever had anything more than license agreements with CR.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________