"Nick" <Nick@discussions.microsoft.com> wrote in message
news:156903CE-0148-4C06-94E4-DE4000E96A8C@microsoft.com...
> The message in the error log when snapshot started was:
> [000] Request to run job SQL1-FPC_SalesLogix-FPC_SalesLogix_Publisher-2
> (from User sa) refused because the job is already running from a request
> by
> User sa
>
> "Nick" wrote:
>
>> I'm trying to set up transactional replication using SSMS. I had no
>> errors
>> creating the publisher and distributor but had warnings when the
>> subscription
>> create was running saying that another sa process was running.
>> I'm new to this and do not know how to get the snapshot to run or see why
>> it
>> did not run. It appears that it ran far enough to create the snapshot
>> files
>> because I see them in the snapshot folder. This snapshot ran when the
>> database was in use by other users. Is this a problem?
>> Another issue I cannot resolve is that when I go to "View Synchronization
>> Status", the message says it succeeded but when I click on View Job
>> History
>> which brings up the log file viewer, it says Login failed for sa.
>> I did all of this previously with a test database base and everything
>> worked
>> but now I seem to be having problems getting it to work with a live
>> database.
>> Do I have to prevent any other users in the database while I do a backup,
>> restore and start replication?
>> TIA - nick