Sage 100

Crystal 2011 + SQL Integrated Security: I'm not sure if others have set this up recently in Sage 2013/2014 and Crystal Reports 2011, but I just upgraded a client from Sage 4.50/Crystal XI that has custom reports that link to a set of SQL tables on the server. These reports worked great in Crystal XI when setting the ""Integrated Security"" setting to ""True"" - they could run the reports without being prompted for logon. Now, after the upgrade, even though I have enabled and disabled this feature and tried resetting the datasource location multiple times, we still get the logon. The workaround for now is either to clear the login/password fields or type in the sa password. Has anyone experienced this as a Crystal 2011-specific issue?

Amber, We have just ran into a very similar issue although it is a client that is still on version 4.5 we are working on figuring it out now. if we do I'll let you know what we find. if you figured out the issue can you post what you found please?

Yes, I can. I have posted on Sage City as well and reported it to Sage yesterday morning, but so far, no response.

Is this the Premium version of Sage 100? I don't have the specific answer for this but I think it has to do with the user ID's automatically created by the installation. I believe the properties of the MAS_Reports"" user needs tweaking. Or the user needs to be using the credentials of the MAS_Reports user. Maybe someone else can chime in?

This particular client is on 2014 Standard.

@DavidOverholt - my resolution was to rename the SQL databases that I was feeding Sage data into via the linked servers. I inherited this client, and they had 6 SQL databases named ""MAS_XXX"", one for each company. Once I renamed the databases to ""MASXXX"", updated the linked server insert statements and updated the Crystal reports with a new OLE DB (ADO) connection with Integrated Security checked, I no longer got the prompt running the reports from the Sage menu. I hope that helps you in your case.