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,
NickCan 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'
|||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.
