Target server blocks multiserver jobs -
07-04-2003
, 01:25 AM
Hi!
Created a master server and several target servers for
running common tasks. One of the target servers blocks
downloadings of multi-server jobs. Pressing the
button "Force Poll" returns "All is Ok" When trying to
synchronize jobs with this server, it goes to blocked
state and returns this error for Insert operation:
Blocking error preventing further downloads: Ad hoc
updates to system catalogs are not enabled. The system
administrator must reconfigure SQL Server to allow this.
[SQLSTATE 42000] (Error 259)
I suspect that the cause is the difference in setting on
target and master servers. What server settings may cause
this problem with multiserver jobs?
Thanx. |