June 11, 2009 at 5:21 pm
Hi.
I need to run a job on a remote server (actually on two remote servers, but for now I a trying to solve it on just one).
If I open Job Properties/Targets the radio-button on Target multiple servers is desabled, so I really have only one choice - Target local server.
What setup do I need to change ?
Thanks.
June 11, 2009 at 6:25 pm
Hi
What is the version you are using?
Have you installed sp2?
Please check
SHREE
June 12, 2009 at 7:35 am
Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
June 12, 2009 at 7:46 am
Did you setup the master/Target servers.. under SQl server Agent.
Goto-> SQL server Agent-> right click and select Multiserver Administration->seect make this the master or target.
I havent played around with this etting much maybe just once, so now cannot remember.. but this is teh way to go, then the radio button will be enabled.....
Maninder
www.dbanation.com
June 12, 2009 at 8:38 am
Thanks, Mani. This is exactly what I needed. I found this place, but having now problems with connection to target server, I guess I need to create unified login accross the servers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply