My cube is failing to build. Working with my DBA (I am not a DB expert), he
tells me that the SQL server "cannot even talk to itself". When he tries to
make an ODBC connection while logged onto the SQL server using the service
account (which has OLAP Admin rights), he gets the following error:

Connection failed:
SQL State: '28000'
SQL Server error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'amrestage\ser-pct-proj2003'.

Anyone have any ideas? I've heard about recreating the COM+, and/or
truncating the cube tables. Any help would be greatly appreciated.

--Marcus