URGENT - cube failing

[Marcus Pierce]

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

 

[Gary L. Chefetz [MVP]]

Marcus:

A good place to start is to tell us what errors you see in the Server
Application Event log and explain to us what happens when you fire off the
build manually.

 

[FaisalM]

Check that account & its SQL permissions.

Search on ms kb site with the state &/or error number and look for relevant
articles.

http://support.microsoft.com/search/?adv=1

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://msp.faisalmasood.com/
My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint