If you have trouble generating models using Windows Authentication with SQL Server, you may see the following errors: “Login failed for user. The user is not associated with a trusted SQL Server connection.” or “The generation request failed. Unable to generate data source view.” These errors can occur when using Microsoft SQL Server Windows Authentication security if the ActiveReports Server Web Application Pool user or the ActiveReports Agent Windows Service user (for each agent) do not have permissions to the SQL Server database. Both users need access to the database for the following reasons.
In preparing to generate a model, the web application selects tables on which to base the model. So the web application’s App Pool user must have access to read the schema of the database.
The process of actually generating the model is delegated to an agent. So the agent (a Windows service) must have access to read the schema and data too. Even after the model is created, the Agent needs access to read data from the database in order to run reports. To change the ActiveReports Server web application pool user
To change the user for each ActiveReports agent service Note that you must set this on each agent on every machine.