Posted by ServiciosDeCiclismoDelPeru on 01/27/07 14:24

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

• Next in forum: Re: sql 2005 - optimization - cannot use index
• Prev in forum: Re: sql 2005 - optimization - cannot use index
• Thread view: Specified SQL server not found. [SQLSTATE 42000]

[Reply to this message]