Well, I found a work-around. I'd still be interested in an answer, as
I'm trying to keep up with 100 of these puppies, and it would be nice
to do it from one spot.
I went to the subscriber's Agent Properties (the actual job), and
altered Step Two by adding "-LoginTimeout 30" to the end. Worked like
a champ!
Thanks,
joseph
On Jan 27, 11:37 am, Joseph wrote:
> Guys, I need to increase the login timeout on a few of my publishers,
> but adjusting the agent parameters on the distributor seems to have no
> effect.
>
> Publisher/Distributor: SQL2000, SP3, on Windows XP
> Subscriber: SQL2000, SP3, so Server 2000. Pulls every 15 minutes.
>
> On the distributor, I've created a new profile, and tried different
> settings for the LoginTimeout parameter.
>
> I've then stopped and restarted the agent. I've also tried stopping
> and restarting the SQL Server Agent on both sides.
>
> In one case, the Server2000 machine has a publication. I've tried
> similar experiments on that publication (where the subscriber was the
> XP desktop machine), with similar results.
>
> Is it possible the "desktop" version of SQL Server (Standard version
> of SQL installed on a workstation OS) doesn't make use of the
> profiles?
>
> Thanks in Advance!
>
> -Joseph
FAQ
Search
Profile
Private Messages
Log in
