Hi,

I have a Scheduled Job on my PC that runs against a Linked Server. I
have scheduled the Job to run when SQL Server Agent starts and I have
configured my SQL Server and SQL Server Agent to start when the OS
starts. The connection to the Linked Server is via my Broadband
internet connection.

I have some suspicions as to the cause and hence a possible solution
but I want to run my ideas past anyone else who may have experienced
the same.

1. Should I have my DSL modem turned on before I start the PC so that
the Network connection is available when the OS starts?

2. Are the Network connections only made available after you have
logged in and hence not established quickly enough before SQL Server
and SQL Server Agent are started?

Yesterday, when I rebooted the PC with the modem still on the
Scheduled Job ran without failure but this morning again it failed. My
usual routine is to turn on the modem just before I login.

If No. 2 is the case then maybe I just need to set the "Retry
attempts" parameter.

Thanks,
Michael Holberton
Hospedaje Los Jardines & Sacred Valley Mountain Bike Tours
Cusco Database Development and Cycling Services
http://www.machawasi.com/
http://machawasi.blogspot.com/
http://databaseservices.blogspot.com
http://serviciosdeciclismodelperu.googlepages.com

(ServiciosDeCiclismoDelPeru@gmail.com) writes:
> 1. Should I have my DSL modem turned on before I start the PC so that
> the Network connection is available when the OS starts?

Currently, I'm getting my broadband access through the TV cable, but
I have used ADSL and VDSL in the past. And I recall that the recommendation
was to always have them on. If you turn the modem off and on, it may
take about a minut until the connection is up. Check with the
documentation for your modem, and your DSL provider.

> 2. Are the Network connections only made available after you have
> logged in and hence not established quickly enough before SQL Server
> and SQL Server Agent are started?

I don't think so. However, some providers require a login sequence
before you are on the air. I used to have such a provider (cable-TV
again), and I found a program that would to do this login automatically.
But since that was run from the Startup folder, login did not happen
until I had logged in myself.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hej Erland,

Tack så mycket for your reply. (I still remember a little svenska)

> > 2. Are the Network connections only made available after you have
> > logged in and hence not established quickly enough before SQL Server
> > and SQL Server Agent are started?I don't think so. However, some providers require a login sequence
> before you are on the air. I used to have such a provider (cable-TV
> again), and I found a program that would to do this login automatically.
> But since that was run from the Startup folder, login did not happen
> until I had logged in myself.

With regards to the above, I was referring to Network connections the
OS makes with the PC's Network hardware. Does this occur before you
login? If not, do you think the OS should have established those
before SQL Server has started after logging in?

Tack, Michael

>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

P.S. I am using Windows 2000 Server on a Home PC with SQL Server 2000

(ServiciosDeCiclismoDelPeru@gmail.com) writes:
> With regards to the above, I was referring to Network connections the
> OS makes with the PC's Network hardware. Does this occur before you
> login? If not, do you think the OS should have established those
> before SQL Server has started after logging in?

I seem to recall that in the box you see before you get a login window,
one of the things it says is "Preparing network connections".

But if you really want to know, you should ask in a newsgroup where
Windows is the topic. People there are likely to give far more accurate
answers.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi All,

The solution was to have my DSL modem turned on before I start the PC
so that
the Network connection is available when the OS starts.

Thanks for your input Erland.

Michael Holberton
Hospedaje Los Jardines & Sacred Valley Mountain Bike Tours
Cusco Database Development and Cycling Services
http://www.machawasi.com/
http://machawasi.blogspot.com/
http://databaseservices.blogspot.com
http://serviciosdeciclismodelperu.googlepages.com