I have a working ASP.NET app that gets data from a cube in AS2000 via ADOMD.
It displays this data in a chart using ChartFX from SoftwareFX.

I need to use this app on another network (different domain / SQL Server,
etc.). I backed up the database and restored it on the other domain, then I
archived the cube and restored it. In Analysis Manager, I can successfully
rebuild (process) the cube.

However, when I try to run the ASP.NET application, it cannot connect - it
returns a "Database xxxx does not exist" error, where xxxx is the name of
the cube.

After much trial and error, I found that I must change the <processModel> in
machine.config to use userName="system" in order for ChartFX to work - it
turns out that this was also set on the working domain.

But on the second domain that gets the "Database does not exist error", I
can get it to connect only if I add a <identity impersonate="true"
userName="DOMAIN\user" password="xxx"> entry to the asp.net application's
web.config file.