Monday, March 26, 2012

Multiserver administratie on SQL2005

Hello,
does anyone has managed to get MultiServer jobs working on SQL2005.
I have installed 3 fresh win2003 servers with SP1. One is a DC, DHCP
server and DNS server. The two others are SQL2005, using the same
service account that has full administrative rights. I log on also as
administrator when I try to make one of the SQL2005 the master server.
During enlisting of the target server on the master server I get the
error that the target server could not logon on the master server
(altough its service account has full admin rights on the master server)
Any suggestions
Thanks a lot in advance
Marc MertensMarc
Do you mean to run a job on the source server that does the work on the
destination? Linked servers?
"Marc Mertens" <mertens.techdata@.gmail.com> wrote in message
news:upCqi06ZGHA.4580@.TK2MSFTNGP03.phx.gbl...
> Hello,
> does anyone has managed to get MultiServer jobs working on SQL2005. I
> have installed 3 fresh win2003 servers with SP1. One is a DC, DHCP server
> and DNS server. The two others are SQL2005, using the same service account
> that has full administrative rights. I log on also as administrator when I
> try to make one of the SQL2005 the master server. During enlisting of the
> target server on the master server I get the error that the target server
> could not logon on the master server (altough its service account has full
> admin rights on the master server)
> Any suggestions
> Thanks a lot in advance
> Marc Mertens|||No, MultiServer administration means that you create a multserver job on
a master server that is downloaded on target servers and executed there.
You enable multiserver administration by right clicking on the SQL
Server agent and choosing the correct menu entry in All Tasks. This is a
feature already available on a SQL2000 (where it worked without a
problem), but it does not seems to work anymore in SQL2005 (at least I
can not get it working).
Marc
Uri Dimant wrote:
> Marc
> Do you mean to run a job on the source server that does the work on the
> destination? Linked servers?
>
> "Marc Mertens" <mertens.techdata@.gmail.com> wrote in message
> news:upCqi06ZGHA.4580@.TK2MSFTNGP03.phx.gbl...
>

No comments:

Post a Comment