Well, for what it's worth, I came across a good post on the DPM forums
that went over all of the steps. (see below)
I set up some more test servers, one as a standalone sharepoint server
(using a local sql express db) and the other scenario with the wfe
pointing to a remote, standalone sql 2005 server. In both cases, I
was able to get the protection group going without any trouble.
I still haven't figured out why it's not working on the sharepoint
server using a clustered sql 2005 database.
Here's the previously mentioned steps:
--------
1.Install 940349 hotfix
2. Update the instance of SQL Server 2005 on the SharePoint servers to
SQL Server 2005 SP2. If you are using SQL Express Edition, download
the SQL Express Edition SP2 from Microsoft using Microsoft Update or
other.
3.Install the hotfix KB 941422 on the SharePoint server
4.Run ConfigureSharepoint.exe from the DPM agent installation
directory on the sharepoint server (typically C:\Program
Files\Microsoft Data Protection
Manager\DPM\bin), and provide credentials with access to the farm.
This will start the Windows SharePoint Services VSS writer service.
Check that this VSS writer is started.
Note: If you have problems protection SharePoint servers, try the
following:
- Run the SharePoint Products and Technologies Configuration Wizard on
the
SharePoint server
- Run the command stsadm –o registerwsswriter
--------
I also came across a MS article somewhere (can't find the link now)
that stated hotfix 941422 was not necessary if SP1 is installed on the
Sharepoint server. Hopefully that's true because it wouldn't install
on my test server running SP1.