AppPool Permissions (SQL Server)

In order to generate data models using Windows authentication with Microsoft SQL Server data, the AppPool used for ActiveReports 9 Server needs proper credentials to access the database.

This is set during installation with the user that you assign for the Web Application Pool.

If the user you assign for the application pool does not have permission to access the database, when you try to create a new model using Windows Authentication, you get an error like:

"The connection test failed. Login failed for user 'YourUserName'."

You can avoid this error by setting the AppPool account with a user who has permissions to the data you want to use, or by opting to use Server Authentication when you create a data model. See Creating a New Model for more information.