SQL Server Reboot - Impact on Access db Links

Hi Experts!!

Running SQL Server 2008 R2 - on - Windows Server 2008 R2 - 64 bit

Access 2003 application running on a different server (Server1) - linked

There are several scheduled tasks on Server1 - one is a UPS delivery tracking executable, others open Access apps (linked to SQL) which kick off the Autoexec -- run some queries  -- and close.

For some reason after they reboot the SQL Server the Scheduled Events on Server1 set for 3:00 AM the following morning -- they appear to have run -- but the queries do not appear to have run -- as the data is not updated.

My Question is this: Is it possible that after a SQL Server reboot that somehow these Access applications lose their links to the SQL Server -- connected via ODBC --  because when they are invoked via the scheduled tasks -- they do not appear to do what they're supposed to.

I'm really lost as to why these tasks suddenly stop working on a server that is not being rebooted so the only thing I can think of is that somehow these links are lost??

Any help will be appreciated. Thanks so much!!
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Look at the servers and the SQL servers event logs (check application and system) to see if it is recording any errors related to login.

The links inside the access DB should not be lost unless they are deleted and then re-established via linking code in the app and a valid login cannot be gotten.  Then all the table links would disappear.

If you mean linking in the sense of talking to SQL, no, no links are maintain, expect for ODBC connection pooling on the server, and those should die anyway after a minute by default (someone may have modified that, but doubtful).

Only when the app actually goes to use the linked table will a connection to SQL Server be established.  

The event logs should show failed login attempts if there are any problems with that.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Thanks Jim.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.