Resolution
When using Windows Authentication to access the SQL database, the “Application Pool Identity Account” must be specified with a Windows user that has DBO rights to the Asset Manager SQL database. The account also needs access to start Windows services.