WE have been running successfully for a few years on Windows 2000 server and
have just moved to Server 2003 and Active directory.

I have
Windows Server 2003
SQL 2000 SP3
MSOLAP - Analysis Server SP3
Office XP latest SP
And the latest BI accelerator.

I have a AD server login and have added it to the local server\OLAP
Administrators group and I have set all the permissions that the Deployment
guide suggests for server 2000. However when I try to run the workbook this
is what happens.

Microsoft Analytics Builder Workbook Logfile
21/10/2003 16:44 Build 1.2.1125 (6/17/2003)
21/10/2003 16:44 Processing Database ID: Billed_Consumption
21/10/2003 16:44 Testing connection to database servers...
21/10/2003 16:44 Connection test succeeded.
21/10/2003 16:44 Relational database Billed_Consumption exists.
21/10/2003 16:44 Validating Workbook...
21/10/2003 16:44 Workbook validated.
21/10/2003 16:44 Creating directory structure...
21/10/2003 16:44 Created directory structure.
21/10/2003 16:44 Saving a copy of the workbook...
21/10/2003 16:44 Saved a copy of the workbook.
21/10/2003 16:44 Created config file C:\Program Files\Microsoft SQL
Server Accelerator for BI\data\Billed_Consumption\config.ini.
21/10/2003 16:44 Writing the contents of the workbook into an XML
document...
21/10/2003 16:44 Wrote the XML document.
21/10/2003 16:44 Writing the client generator mapping file...
21/10/2003 16:44 Wrote the client generator mapping file.
21/10/2003 16:44 Connecting to the Analytics Builder catalog...
21/10/2003 16:44 Connected to the Analytics Builder catalog.
21/10/2003 16:44 ------------------------
21/10/2003 16:44 ------------------------
21/10/2003 16:44 Entering metadata into the catalog...
21/10/2003 16:44 Removing existing metadata for database
Billed_Consumption...
21/10/2003 16:44 Removed existing metadata for database
Billed_Consumption
21/10/2003 16:44 Adding metadata for database Billed_Consumption...
21/10/2003 16:44 Added database metadata. Billed_Consumption
21/10/2003 16:44 Adding metadata for autogenerated time dims...
21/10/2003 16:44 Added autogenerated time dimension virtual dimension
info.
21/10/2003 16:44 Added metadata for autogenerated Standard time
hierarchy.
21/10/2003 16:44 Added metadata for autogenerated time dims.
21/10/2003 16:44 Adding date range info for auto time dims.
21/10/2003 16:44 Added date range info.
21/10/2003 16:44 Adding metadata for dimensions...
21/10/2003 16:44 Added metadata for Account dimension.
21/10/2003 16:44 Added metadata for Service dimension.
21/10/2003 16:45 Added metadata for Location dimension.
21/10/2003 16:45 Added metadata for Equipment dimension.
21/10/2003 16:45 Added metadata for Transaction Type dimension.
21/10/2003 16:45 Added metadata for Bill Type dimension.
21/10/2003 16:45 Added metadata for dimensions.
21/10/2003 16:45 Adding metadata for member properties...
21/10/2003 16:45 Added metadata for member properties.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Adding metadata for cubes...
21/10/2003 16:45 Added metadata for Billed Consumption cube.
21/10/2003 16:45 Added metadata for all cubes.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Adding metadata for Virtual cubes...
21/10/2003 16:45 Added metadata for all virtual cubes.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Adding metadata for Calculated Members...
21/10/2003 16:45 Added metadata for all calculated members.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Adding metadata for Named Sets...
21/10/2003 16:45 Added metadata for all named sets.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Adding metadata for CalcCells...
21/10/2003 16:45 Added metadata for all CalcCells.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Adding metadata for Actions...
21/10/2003 16:45 Added metadata for all Actions.
21/10/2003 16:45 ------------------------
21/10/2003 16:45 ------------------------
21/10/2003 16:45 Creating database objects...
21/10/2003 16:45 Error: Deleting database file
'S:\MSSQL\Data\Billed_Consumption.mdf'.
21/10/2003 16:45 Location: CreateSQLDatabases/ExecSP_Sym_Create
21/10/2003 16:45 Analytics Builder processing halted unexpectedly.


This is if the DB exisits but if niot get this

21/10/2003 16:54 Creating database objects...
21/10/2003 16:54 Error: The CREATE DATABASE process is allocating 0.63
MB on disk 'Billed_Consumption'.
21/10/2003 16:54 Location: CreateSQLDatabases/ExecSP_Sym_Create
21/10/2003 16:54 Analytics Builder processing halted unexpectedly.



the Database is there etc but the Analysis Server DB has not been created.
I have searched high and low to no avail. Any help would be greatly
appreciated.

I know it must be permissions but I have set every conceivable rights that I
can think of.

LB
email: zooedathotmail.com

remove 'at' and put in the real thing

TIA