Thursday, March 29, 2012

Error renaming analysis services project

After renaming an analysis services project in bi development studio I receive the following error when deploying the project to SQL2005 AS (SP1):

Error 1 The 'Database' with 'ID' = 'AS UPC Chain Sales ' doesn't exist in the collection. 0 0

However the database is available on the server and can be processed and used. Any ideas how to fix this error?

Try to rename your live database on the Analysis Server using SQL Management Studio.

Then create a new project in BI Dev Studio. Select a project type as "Import Analysis Services 9.0 Database...". Follow the steps and get your project re-created based on the live version of the database.

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

|||Thanks, Edward. Worked like a charm!

No comments:

Post a Comment