Firing up SSMS and BOL with XP, 256MB and P4 2Gz, every day as I do is a pig. But then, this is a work machine with tons of extraneous...

Hmm, open up Cluster Resource Manager and check the Analysis Services appears as a clustered resource.

Check you get DNS on both nodes and your PC for 006-pm2-dbasql.

They key stage at...

Quote looks like the problem is with MSDTC and the cluster, not the command you're sending.

Try removing MSDTC (msdtc -uninstall) from both nodes - you'll need to break the cluster...

Yes, and depends on how active the server is.

First of all quantify your requirements (with the business), then pick a solution.

How much downtime is acceptable?

How much data loss is acceptable?

Is...

1: In T-SL, sp_add_schedule and sp_attach_schedule

2: Read your question again - if you delete the data and have no other copies...

Your SQL server has a virtual name, use that, not the machine names.

Ah, although the 'sa' account continues to exist it's a really bad hangover from 6.5 days.

Assuming you are a Local Administrator on this server, a default installation will allow you...

You can shorten the advice to "contact PSS"...

Moving from 2000 Developer edition to 2005 Express is a downgrade, that's why it's not supported.

Ah, you probably posted this after discovering mirroring is not yet supported. The short answer is to use log shipping.

Database mirroring?

Log shipping?

Clustering?

Replication is not designed as a failover tool, it's more for availability.

Why are you trying to log in as 'sa'?

The system administrator should have access through his or her windows account.

I can't - but have a look at the installation components, it's likely to be linked to one of them and neccessary for certain functions.

You want to hook up VS...

That's because the question is incompl

In that directory run

regsvr32 gapi32.dll

To be honest it's probably indicative of a wider problem, which the MSI should take care of. Try adding/removing components, the MSI should self-heal.