sql server replication: Snapshot won't start -- sql server replication

Snapshot won't start

Mark Hockaday via SQLMonster.com
4/7/2005 1:58:15 PM

sql server replication:

Hi,

I'm desperate for some help on replication. I'm trying to replicate from
one server to another and am having major difficulties.

I've set up a snapshot agent, a push subscription and a distribution agent.
However, I cannot get anything to start. I've tried to manually start the
snapshot agent but it still says Status = Never Started and nothing appears
in the agent history. When I navigate to the properties of the publication
and go to the Status tab, the time last run field always says "Agent has
never been run". This is really becoming a frustrating problem for me now
so any help would be greatly received.

Thanks
Mark

--

Re: Snapshot won't start

Hilary Cotter
4/7/2005 4:17:31 PM

right click on your agent and select agent properties, make the agent
owner sa. restart your agent.

[quoted text, click to view]

Re: Snapshot won't start

Hilary Cotter
4/8/2005 11:20:35 AM

Are you using SQL Authentication? Perhaps the publisher or subscriber is
using Windows Authentication only, and is not setup for Mixed
Authentication and this is what is generating this error.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS

Re: Snapshot won't start

Mark Hockaday via SQLMonster.com
4/8/2005 12:24:36 PM

Thanks for your reply. I was able to rectify the problem by simply
stop/starting SQL Server. However, although the snapshot agent is now
running successfully, my distribution agent which is pushing the data out
to another server is producing the following error:-

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."

Has anyone else had this problem? It is unable to connect to the
subscribing server.

Thanks

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.