You may be able to run a job which queries the appropriate tables in msdb on a nightly basis and then compares the results with the previous night's run. If...

I've not heard of any cross domain issues like that with AS. If you log on as the Domain\SQLServerAccount are you able to establish a connection to AS manually?

You can manually install SQL Server 2000 Analysis Services as a clustered application, but there is no automated means of doing so. Here is the Microsoft KB article on how...

Nice tip, James!

No other access was changed? Are there any errors in the operating system's System event log about not being able to connect to a domain controller or anything of that...

So the error log says it's able to listen on the TCP port just fine?

Are you able to connect to the SQL Server locally? If so, are there any suspicious entries in either the SQL Server error log or the operating system's Application event...

Do you maintain any network connections to the SQL Server using that second set of credentials (mapped drives, etc.) I know you said you did once, but do you still...

Does the DOMAIN\SQLServerAccount have the same permissions as the previous account did within Analysis Services?

Not that I am aware of. However, this gets into a question of change control. If something is changing in production, especially when you're talking about ETL type of stuff,...

What happens if you try to run Query Analyzer from Start | Run by executing isqlw.exe ? How are you seeing that it's trying to connect as a different uesr?

...

What may be simpler is to script out the logins/passwords (encrypted) on a regular basis (make sure you get the SIDs correct, too, for those SQL Server logins). In that...

I would add: know thy operating system. Know file and share level security (share level for replication and log shipping, for instance), know how services work, understand user rights and...

True, but that can easily be faked. Create a file DSN and you can set the app name to anything you wish.

Don't run the entire script. Rather, find the stored procedures which are missing and execute just the code related to them. For instance, run only the CREATE PROCEDURE statement for...