Logshipping Monitor does not work correctly

Hi all,
1st, I must say that I use the German Version of SQL Server. So I am
not sure if I translate the SQL features correctly to English.
I spent some time today setting up Log Shipping between 2 SQL Servers.
I used a Whitepaper I found at the microsoft.com Website.
Log Shipping seems to work fine. When I change Data on Server 1 I can
see the changes on Server 2 after the Logs are applied.
But I have one thing that doesnt work. And its the Logshipping
Monitor in the Enterprise Manager. When i open the Log shipping Pair
Properties and look at "last file copied" and "last file loaded" it
just shows first_file_000*.trn.
After 30 Minutes the Logshipping Monitor turns red and says that there
is an Error. But there isnt (not in the Shipping itself, I am sure
because it works!).
I dont know whats wrong here. The SQL Server runs as Local System on
both Sites. The SQL Agent uses a Domain Account which has SA rights on
the SQL Servers, Admin Rights on the Machines and Read / Write
privileges on the Fileshares where the Transaction Logs are copied.
I hope somebody can help here.
Thank you very much in advance,
Rene
On Tue, 22 Nov 2005 20:08:56 +0100, Rene Buedinger
<rbuedinger@.wz.xagxx> wrote:
Hi all,
OK I got it! My SQL Server Services where running as LocalSystem.
Because the Monitoring was running on the Primary Server, the
Secondary Server could not alter the Table log_shipping_secondaries.
After I started the SQL Server with a Domain Account which has the
necessary Rights on the Primary Server the log_shipping_secondaries
Table was altered and the Error went away.
Maybe this helps some others when they get the same Error.
Greetings,
Ren