Re: Access Linked Server Breaks

I can't put my finger on it, but this feels like a SQL Server "mem-to-leave"
issue (the portion of SQL Server process memory that is not the buffer
pool.). Linked server info is stored there. Don't know how to help other
than suggesting running DBCC FREEPROCCACHE instead of restarting sql server
(or do you have to reboot the whole box?)



--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
news:%23SR7gC0PHHA.4280@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

1. I have a SQL2000, SP3 Linked Server to an Access mdb that breaks every
couple of weeks. If I do a SELECT statement to the Linked server in Query
Analyzer,, even on a small table of 3 records, QA seems to be working, and
no error messages come up. However, the SELECT command never completes.

2. This problem can always be cured by a reboot of server, but then it
happens again a few days or a few weeks later.

3. This exact same setup worked on another server for 1 3/4 years, but the
problem is on a newly set up SQLServer box.

4. Has anyone experienced such symptoms and found a resolution for
sporadic Linked Server to mdb failures?

5. When a Linked Server connects to an Access mdb, is this being done via
an IP connnection?

I believe a couple of years ago I had viewed the linked server process in
motion, showing among other things some IP connections, but I don't
remember how I did that.

Thanks for any help.

Alan




.

Relevant Pages

  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • Re: Microsoft Excell Connection
    ... Use your linked server to Access then as the source by adding a SQL Server ... You should be able to add an Access Connection to a secured Access MDB ... properties enter the location of your system database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 linked server problem
    ... The delegated Kerberos authentication does not work stably. ... of SQL Server 2000 to fix some known bugs on the SQL Server side. ... the both two SQL Server instances (local and linked server), ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 linked server problem
    ... if we are able to connect the linked server ... successfully on the SQL Server itself but fails to connect from the remote ... client, the most common cause of this behavior is the delegation problem. ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)
Loading