cannot add, update or delete a job that originated from an MSX server..? 
Author Message
 cannot add, update or delete a job that originated from an MSX server..?

I have a development sql server 2k with replication applied to a database on
a windows 2k server box.

I changed the machine name,  and afterwards could not delete the replication
with out error 14274(cannot add, update or delete a job that originated from
an MSX server) so I used sp_removedbreplication which worked.

I then tried to add replication to the db again and recieved the same error.

I then deleted the database and recreated it and then added replication
again to the database, same problem; error 14274.

Hate to reinstall sql server 2k even if it is a development machine.  Any
one have any ideas?

Thanks.



Tue, 09 Dec 2003 06:57:27 GMT
 cannot add, update or delete a job that originated from an MSX server..?

John,

Try sp_dropserver 'YourServerName', 'droplogins'  sp_addserver
'YourServerName'. 'local'

John Gose
Microsoft SQL Server Support
--------------------

| Subject: cannot add, update or delete a job that originated from an MSX
server..?
| Date: Thu, 21 Jun 2001 18:57:27 -0400
|
|
| I have a development sql server 2k with replication applied to a database
on
| a windows 2k server box.
|
| I changed the machine name,  and afterwards could not delete the
replication
| with out error 14274(cannot add, update or delete a job that originated
from
| an MSX server) so I used sp_removedbreplication which worked.
|
| I then tried to add replication to the db again and recieved the same
error.
|
| I then deleted the database and recreated it and then added replication
| again to the database, same problem; error 14274.
|
| Hate to reinstall sql server 2k even if it is a development machine.  Any
| one have any ideas?
|
| Thanks.
|
|
|



Sat, 13 Dec 2003 08:22:30 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. unable to delete/change a job originated from an MSX server

2. HELP Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server...

3. HELP Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

4. Getting Error 14274 Cannot Add, update, or delete a job originating from a MSX server.

5. HELP Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

6. HELP Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

7. HELP Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server...

8. HELP Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

9. Orphan Jobs (originated from MSX server)

10. cannot delete job ... msx server

11. Error 14274: Cannot add, update, or delete a job (or its steps or schedules) tha

12. Error 14274: Cannot add, update, or delete a job (or its steps or schedules) tha


 
Powered by phpBB® Forum Software