Prev: Error 207 - Invlaid Column Name
Next: Manual Upload of Data from Subscriber to Publisher Database
From: Joseph on 27 Jan 2010 12:37
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
From: Joseph on 27 Jan 2010 16:09
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 <josephshepp...(a)gmail.com> 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

 | 
Pages: 1
Prev: Error 207 - Invlaid Column Name
Next: Manual Upload of Data from Subscriber to Publisher Database