Database Replication - Snapshot agent Fails

Question

Post reply

Database Replication - Snapshot agent Fails

Viewing 8 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Erich Brinker SSCrazy Points: 2973 More actions · Answer 1

Erich Brinker

SSCrazy

Points: 2973

November 13, 2009 at 1:22 pm

#1079232

Who owns the snapshot job?

Deba Monkey Right there with Babe Points: 737 More actions · Answer 2

Deba Monkey

Right there with Babe

Points: 737

November 13, 2009 at 1:34 pm

#1079243

The sysadmin - xxxx\sql_admin

Erich Brinker SSCrazy Points: 2973 More actions · Answer 3

You might try changing them to a SQL Login with appropriate permissions and see if that changes anything

Deba Monkey Right there with Babe Points: 737 More actions · Answer 4

Erich,

Tried that yesterday, just for grins, tried again today - same error

deepzzzz SSCrazy Points: 2890 More actions · Answer 5

Hi,

I am also facing the same issue. Anyone got the solution??

Thanks

Deba Monkey Right there with Babe Points: 737 More actions · Answer 6

Solution found:

I had to call support found the key below had changed. Never found out why. Changed the location to path for snapshot agent - No errors. Hope it works for you!

HKLM\software\Microsoft\Microsoft SQL Server\90\VerSpecificRootDir

Erich Brinker SSCrazy Points: 2973 More actions · Answer 7

Thanks for posting that...I don't feel quite so bad for not knowing it was a registry key that had been updated

deepzzzz SSCrazy Points: 2890 More actions · Answer 8

Thanks Deba....

Your solution worked fine for me also...

Thanks