We help IT Professionals succeed at work.

SQL Server Reboot - Impact on Access db Links

Medium Priority
68 Views
Last Modified: 2015-08-28
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!!
Comment
Watch Question

President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
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.

Jim.
Eileen MurphyIndependent Application Developer

Author

Commented:
Thanks Jim.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.