dbTalk Databases Forums  

Target server blocks multiserver jobs

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Target server blocks multiserver jobs in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roust_m
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.