Cannot design aggregations because databsae already exists

I am clicking on "Start" in the aggregation design wizard ("Estimated storage reaches X" is selected" and I get the following error:

TITLE: Aggregation Design Wizard

Errors in the metadata manager. The database with the name of 'CoreMarketReturn' already exists in the 'LNVDMFIISUAT01' server.

To restart the process, resolve the problem, and then click Start.

BUTTONS:

OK

What gives? Why would an existing database matter? All I'm doing is designing some Aggs.

Any ideas? Google wasn't much help unfortunately.

-Jamie

First about the error message you are getting:

Analysis services implement aggregation design algorithm as part of Analysis Server. Aggregation design wizard is conneciting to Analysis Server and asking to design aggregations, then displays result back to you.

To allow people to desing aggregations even though they are not server admins, aggregation desing will check first if you have permissions to the database you designing your aggregations for and will proceed then.

In your case, Analysis Server tried to compare the database you designing aggregations for with the database it has alreday. It decided for some reason give you back an error message.

Second. What you can do about it?

If you are a server admin, the simpliest thing is to change the name of the target database in Project properties dialg( deployment tab). Design aggregations and then change the target database back before deploying.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

That's a fantastic reply - tells me all I need to know.

Thank you very much.

-Jamie

sql