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?
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…