July 30, 2008 at 5:35 am
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?
July 30, 2008 at 7:52 am
After days of pondering I've just solved it myself, so I guess this becomes more of an FYI for anyone searching for an answer to this on Google like I was.
I had created the "hypdb" database having logged in using Windows Authentication so therefore with my Windows log in.
I deleted "hypdb" and disconnected from the SQL server, then reconnected again but logged in as "hypuser".
Then created the "hypdb" database again logged in as "hypuser", re-ran the Hyperion Configuration Utlity and was successful.
Appears as though you have to be the database owner to drop tables within it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply