I've installed SQL Server 2005 and intend on using it as the back-end database for Hyperion Financial Management.
The Hyperion application requires a database to be created called "hypdb" which has a user called "hypuser" that has full administrator access, which I've created.
However when I run the Hyperion Configuration Utility which sets up the database for Financial Management application I keep getting a bunch of failures which state:
Cannot drop the table 'HDB_SCHEDULED_TASKS', because it does not exist or you do not have permission.
Cannot drop the table 'hub_metainfo', because it does not exist or you do not have permission.
And so on. I've checked that these tables exist in the database and they do, although I don't know what they are used for.
Has anyone got any ideas why I can't drop them? Is there some kind of permissions setting that is specifically required to drop tables?