Took me a day to find out...

Important missing requirement for Snapshot Agent to work is that you need to download and install Microsoft OLE DB Driver for SQL Server if...