https://www.microsoft.com/en-gb/download/details.aspx?id=39046

Try this is see what your problem is. It would seem to be a typical Kerberos issue.
SPNs Delegation etc etc.

SELECT TE.name AS [EventName] ,
   T.DatabaseName ,
   t.DatabaseID ,
   t.NTDomainName ,
   t.ApplicationName ,
   t.LoginName ,
   t.SPID ,
   ...

Thanks Sue. I'll take a look at that.

You will probably have the same problem. Restore the DB to a DBA safe area and test. But I would imagine you need to turn it on for it to...

Thanks Sue.

I'm thinking of using it in SQL 2008.

Thanks for your replies,

I thought it was the case, but always good to ask to see if anyone found a work around.
I can’t use...

I would like for the Snapshot to  remain in place while the Standby Db is receiving logs.
It only works if the snapshot is dropped prior to the TLOG Load...

There is no meaningful error in the agent job.
Maybe I asked the wrong question?
Can you successfully snapshot a DB that is in warm standby mode in a log...

I was really simple. Embarrassed I posted now. Dumped the name in a temp table and just created a cursor to loop through and pump the db names in the...

Thanks, I have resolved. Had a coffee and something to eat and my brain clicked into gear.

Each listener should not use the same default port 1433, when you are instance stacking as you appear to be doing.
This is MS advice.

Sorted. It's left in recovery mode as I thought.

Would windows Event Viewer shed any light as it is a windows task and would require a restart of the service.