Snapshot Creation

Distributor/Publisher and Subscriber:
Windows Server 2003 SP1
SQL Server 2000 SP4

Distributor/Publisher and Subscriber created through SQL Server wizardry.
Asked for initial Snapshot to be created immediately. It wasn't.

Snapshot Agent shows as "Never started". Right-clicking on the Snapshot
Agent and selecting "Start agent" results in nothing--no snapshot, no error
message, no Event Log entries. Nothing.

I could really use some help here. I found one thread from March 2005 where
a guy resorted to scripting what this replication is supposed to do. I'd
prefer to set it up to run as it is supposed to run. Is this possible?

Thread from 2005:
http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4

Thanks!

Jim

P.S. The replication manager is set to refresh every 10 minutes, and each
time the below error output appears in the Application Log. Otherwise, I
seem to have nothing at all going.
SQL Server Scheduled Job 'Replication agents checkup'
(0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on:
2006-07-21 16:20:00 - Message: The job failed. Unable to determine if the
owner (UAB\Genome-SQLServer) of job Replication agents checkup has server
access (reason: Could not obtain information about Windows NT group/user
'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)).






.

Relevant Pages

  • Re: pull subscription - anynonomous - error HELP
    ... Did you configure your pull subscription to download the snapshot using ftp? ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication "after the fact" ...
    ... You can use the snapshot from C to A and B if you want instead of DTS. ... There are still rows being augmented and SQL Server ... replaces what exists on the subscriber. ... Create a publication and the subscriptions to/from A and B ...
    (microsoft.public.sqlserver.replication)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... I was wondering what the significance is to sharing the snapshot folder. ... Does the Pocket PC directly access the shared folder? ... >> check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • Re: How do I prevent initial Snapshot to drop my tables?!
    ... Looking for a SQL Server replication book? ... > There you can specify in the "Snapshot" tab, ... > going to drop and re-create the target tables, ... all the commands to manipulate the schema at the subscriber ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Errors running SQL Server 2005 beta
    ... >> I should have an initial publication. ... >> sure the snapshot was created. ... The Snapshot Agent will run under the Administrator account. ... >> running SQL Server, ...
    (microsoft.public.sqlserver.ce)
Loading