Another approach, hand for debuggin conectivity issues is

telnet ip

It appears that your server is extremely busy and is hitting a bottle neck somewhere.  In the initial posting by Michael their was a deadlock that either was caused by...

You probably already did this as part of the db migration.  Microsoft says to run DBCC UPDATE USAGE after migrating from 2000 to 2005.  It's just a one time deal.

Almost always, any issues with SQL Server disk devices are always caused by problems at a lower level in the IO subssytem, controllers, DISK, firmware or OS.  I would look in...

I usually associate CXPacket waits with network delays.  The client can't accept the result set fast enough to keep up with the server, so the server waits with the CXPacket...

I assume you are way ahead of this by now.  The error is caused by data type mismatch between whats in the relational data warehouse, and the data type of...

Will the processors be Intel or AMD?  Do you get to choose?  The AMD runs both 32 bit and 64 bit seemlessly.  Itanium runs a 64 bit architecture, so 32...

I'm having difficulty determining your environment. I gather that the DTS packages are on 2005. The relational data, the data mart, is also in 2005. And lastly, the Cubes are...

Ultimately it boils down to 32 bit versus 64 bit addressability.  For 32 bit to address above the 2 GB line, AWE is the solution.  But it has limitations as...

Make sure Allow Remote Questions is checked in the Connection  Properties.  You'll have to log on locally.

If the DBCC repair doesn't fix the problem another idea is to copy over the database .mdf and .ldf files and run a sp_attach_db. 

Check the database id of the...

The OLAP Administrators group is for Creating dimensions and cubes.  Users are added to Roles to access a OLAP database.  

Your problem is a network one.  It will be caused by...

The answer to question one is the default database size will be whatever the size of the model database is; at least for the data portion.  The log file is...

The answer to question one is the default database size will be whatever the size of the model database is; at least for the data portion.  The log file is...

sp_helpsort provides a lot of info.

When I had to recreate a servers character set and sort order, I installed my best guess,...