I'm trying to backup my Sharepoint Server Farm but I can't select any of the databases for backup except "Index DB 1", which is physically located on the Sharepoint webserver.
All the other databases Content DB, Services DB, User Profile DB, Configuration DB are located on a separate SQL2000 server.
When I try to select any of these I get a logon error similar to the following:-
"Failed to access Configuration DB (SQLSERVER\SPS01_Config_db)
Logon account: System Logon Account
The directory or file was not found, or could not be accessed.
Please select a login account from the list"
I've tried several accounts all of which have DB owner rights to the databases and I can access the databases using other methods OK using the same accounts.