Monthly Archives: October 2011

Exception Message: The snapshot could not be generated because the publisher is inactive.

Issue:- Snapshot Agent throw errors while setting up transactional replication. Replication scripted out from another server and applied with the new publisher, distributor and subscriber details. Message Microsoft (R) SQL Server Snapshot Agent [Assembly Version = 10.0.0.0, File Version = … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged | Leave a comment

Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214

Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214 Issue:- Unable to enable a database to publish running the t-sql exec sp_replicationdboption ‘<dbname>’,’Publish’,’true’ Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214 The specified ‘@server’ is invalid (valid … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged | 2 Comments