Wednesday, March 21, 2012

Error 14294 in replication

Hi
I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
This server has several published databases that they replicate data to
another server.
All the replications is of transactional type.
When creating to publish another database it leaves me the following error:
Error 14294
Supply either @.job_id or @.job_name to indentify the job.
That I can make to correct the problem?
Thank you
are you or have you deployed the other publications using a script?
If you, you must use unique publication names and ensure that you don't
specify a snapshot agent name, log reader agent name, or distribution agent
name.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mario" <Mario@.discussions.microsoft.com> wrote in message
news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> Hi
> I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
> This server has several published databases that they replicate data to
> another server.
> All the replications is of transactional type.
> When creating to publish another database it leaves me the following
error:
> Error 14294
> Supply either @.job_id or @.job_name to indentify the job.
> That I can make to correct the problem?
> Thank you
|||Hi Hilary
I don′t use a script, my publications was created by wizard.
"Hilary Cotter" wrote:

> are you or have you deployed the other publications using a script?
> If you, you must use unique publication names and ensure that you don't
> specify a snapshot agent name, log reader agent name, or distribution agent
> name.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Mario" <Mario@.discussions.microsoft.com> wrote in message
> news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> error:
>
>
|||Can you do a Select @.@.SERVERNAME on your publisher and see what server name
it returns? Did you rename this server recently.
There are some reports that this error can be cleared by disabling
replication on your publisher and then recreating it.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mario" <Mario@.discussions.microsoft.com> wrote in message
news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> Hi
> I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
> This server has several published databases that they replicate data to
> another server.
> All the replications is of transactional type.
> When creating to publish another database it leaves me the following
error:
> Error 14294
> Supply either @.job_id or @.job_name to indentify the job.
> That I can make to correct the problem?
> Thank you

No comments:

Post a Comment