Create a SQL Server login for the Anaplan XL Web IIS application pool

If you are using the default AnaplanXL application pool user in IIS, you must create a IIS APPPOOL\AnaplanXL login for it in SQL Server Management Studio.

For the IISAPPPOOL\AnaplanXL login, in Login Properties, ensure:

• Server Roles set to public.
• User Mapping. Select the Map checkbox for the Anaplan XL database created for use with SQL Repository. Typically, this is AnaplanXLWeb. Ensure User is set to IIS APPPOOL\AnaplanXL and Default Schema is set to dbo.
  • Enable database role membership for public and XLCUBED_USER. 
• Securables: Ensure the Connect SQL permission is set to Grant by sa.
• Status set to Grant for permission to connect, and Enabled for login.