Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

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

Discussion in 'Business Intelligence' started by Peter Schmitz, Dec 11, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Should you ever be prompted with the error:

    , 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.

Share This Page