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 values are returned by sp_helpserver)

Resolution:-

Check the server list on the server using

sp_helpserver

If the publisher is not listed there then manually add the publisher to the serverlist using :

sp_addserver ‘<publisher server>’

Re-Check the server list on the server using

sp_helpserver

Then enable the publisher database

exec sp_replicationdboption ‘<publisher db>’,’Publish’,’true’,0

This entry was posted in Replication, SQL Server, Troubleshooting and tagged . Bookmark the permalink.

2 Responses to Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214

  1. Taylor says:

    Nice to read your blog

Leave a Reply