Do this to verify if the dependency is there:

• Log on locally to the server (terminal services will do).
• Bring up Cluster Administrator (Start | Programs | Administrative Tools | Cluster...

Typically the best way to do this is to use Enterprise Manager to make the service account change. While you can do everything manually, EM tends to get all the...

Which databases, system (master, msdb, tempdb) or user? Also, if the objects aren't user objects, which ones?

Create two database roles, one for read and one for write. Map the NT user groups to those two database roles.

For updating the tables, if at all possible, control using...

Is the default instance listening on port 1433? Is there an alias in place that shoots it to the named instance (check by running cliconfg locally)?

There was a post in one of the email lists I follow that a gentleman had a successful install with every server but 1, a DC. That, too, bluescreened.

You should go ahead and set up on the OS side a 3-node cluster. When you go to install SQL Server 2000 in the cluster environment, it'll prompt for what...

There are also trial versions available for download or with most certification books. They expire after a number of days, but they should get you started.

Depending on your reporting software, this may be easier to re-organize with it. What are you using to generate reports?

What error are you getting?

Use Enterprise Manager. Usually the safest bet. It should handle it on both nodes automatically. Failing that, if you're just changing the password (and not the account itself), you can...

Pass through authentication is used often when accessing shares. An easy test is to set up a share on one server and then try to access the share from the...

What operating system are you running on and what network libraries are currently configured (Named Pipes, TCP/IP, etc.)? When you're connecting from EM, is this just locally or can you...

You can't. One of the flaws with the hostname in SQL Server 7 and 2000 with the sysprocesses table and the stored procedures that derive from it (sp_who and sp_who2)...

How many physical servers are you talking about here, 3? Or are you talking about just 2 physical servers with both instances running on 1 server while the other sits...