Errors in the metadata manager while running "SQL Server 2005 Data Mining Configuration Wiz

Hi,

When I'm running Getting Started "Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2005" for Excel and

1. choose "Use an existing instance of Microsoft SQL Server 2005 Analysis Services that I administer"

2. Click "Next"

3. To run the Server Configuration Utility, Click on link provided:

C:\Program Files\Microsoft SQL Server 2005 DM Add-Ins\Microsoft.SqlServer.DataMining.Office.ServerConfiguration.exe

4.This opens a new configuration wizard - SQL Server 2005 Data Mining Configuration Wizard

i. Click Next

ii. Select Server Name "localhost" and Clicked Next

iii. Checked "Allow creating temporary mining models" and Clicked Next

vi. In Step 3, By default radio button "Create New Database" is selected and Database Name is "DMAddinsDB"

Here, I've got following error in the message box :

Errors in the metadata manager. The dimension with ID of 'Dim Employee', Name of 'Dim Employee' referenced by the 'Adventure Works DW' cube, does not exist. Errors in the metadata manager. An error occurred when loading the Adventure Works DW cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\Adventure Works DW.5.cub.xml'.

I've droped existing "Adventureworks" and "AdventureworksDW" databases and recreated again but still i'm getting the same problem.

Please help to resolve this problem

Thanks!

Regards,

K. Sandeep

It seems that the "Analysis Services Project1" database on your server is corrupted. Could you try to remove that database, then re-run the ...ServerConfiguration.exe application?