Can not generate snapshot (SQl Server 2005 Transactional Repl )

Hi,

This is my first try at implementing transactional replication (Sql Server 2005). My Publisher and Distributor are on different instances of SQL. I am receiving the following error during execution of setp 2 in snapshot agent:

2005-09-15 19:09:48.39 Connecting to Distributor 'WLN-SQL2005DEV\WDC_DIST'
2005-09-15 19:09:48.61 The replication agent had encountered an exception.
2005-09-15 19:09:48.61 Source: Replication
2005-09-15 19:09:48.61 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
2005-09-15 19:09:48.61 Exception Message: The snapshot could not be generated because the publisher is inactive.
2005-09-15 19:09:48.61 Message Code: 54057

Can anyone help me out with this?

Thank you,

Nick

[759 byte] By [NickRusso] at [2008-2-2]

«« Access SQL Server from J#
»» Jump to source context menu ittem

# 1

Can you elaborate how you got into this situation?

To fix the problem, you can call the following stored procedure:

sp_changedistpublisher 'YOUR-PUBLISHER-NAME', 'active', 'true'

LiZhang at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Replication...

# 2

I just got into that situation. I am not sure exactly how I got there but it occured after one or more instances of removing the distibutor, publisher and subscriber and trying to recreate them.

gkochanowsky at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech