SSAS 2005 Migration to SSAS 2008 Browsing Error

Posted on 2012-08-15
Last Modified: 2016-02-18
Hi guys

We have just installed a 2008 server. All of our builds are on a 2005 server. We are migrating all of our SSIS packages, SSRDBs, SSASDBs andReporting Services Reports from the 2005 server to the 2008 server. This has been fine but when we try to browse the cube databases through the SSAS browser in BIDS or in Management Studio we get the following error:

The query could not be processed: o XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.

We have tried both restoring a backup of the cube db and importing the db into a new project (in BIDs 2008) and re deploying it. It deploys and processes fine but we still get the error. Any ideas? Are we missing a component somewhere?

Would be really grateful for help in this.


Question by:trawley
    1 Comment
    LVL 3

    Accepted Solution

    OK the answer is that the language settings in the browser need to be changed from default to your regional language settings.



    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now