SSAS: errors in the metadata manager the database with the name <db> already exists

Peter Schmitz

Administrator
Staff member
Should you ever be prompted with the error:

"errors in the metadata manager the database with the name <yourDBName> already exists
, chances are that you renamed the name of the database recently.

This is what happened in my case, and I ran into the error when trying to build the cube (and having changed the project settings to point at the changed database). As it turns out behind the scenes SSAS will keep track of databases with a database ID. The one I was attempting to build had a different ID than the renamed one, and thus this error popped up.

I ended up solving it by deleting the existing database on the server, and then re-starting a build in SSAS.
 
Top