Linked Server Access Problems

From: scott (scott911rscarrera@hotmail.com)
Date: 11/01/02 

From: scott911rscarrera@hotmail.com (scott)
Date: 1 Nov 2002 13:45:24 -0800

I have recently struggled with granting access to a linked server
database on a SQL 2K box. Only administrators could log in to the
client application and access the data in the linked server tables,
simple domain users could not. All a simple domain user would receive
is an Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' reported
an error. The SQL Server service (i.e. all SQL Services) was running
the under the DOMAIN\Administrator account. The non-secure access
database was linked using a (UNC first then) named path, i.e.
E:\SQLData\Linked.mdb. I experimented with various linkedsvrlogins
all to no avail. I was only able to finally grant access to the
simple domain users by allowing this group "Local Group" permissions
as Administrators on the SQL box. Incidentally, the folder where my
linked database was stored had wide open "everyone" permissions.

There is no way this behavior is by design. Can someone tell me what
is missing from this puzzle?

SQL 2K Service pack 3
Jet Service Pack 5
Access 97 database

Thanks,
Scott

Relevant Pages

  • Re: Linked Server Access Problems
    ... > Under SQL Server's Linked Servers, ... >>database on a SQL 2K box. ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Linked server to MsAccess
    ... I'm running SQL Server\Express in "Windows Authenication Mode" (Do I have to ... they are accessing my MS Access linked server? ... Containing folders with MSAccess Database X.mdb ... SQl Express has linked server X mapped via UNC to Database X.mdb ...
    (microsoft.public.sqlserver.security)
  • Linked Server Access Problems
    ... Under SQL Server's Linked Servers, ... >database on a SQL 2K box. ... >SQL 2K Service pack 3 ...
    (microsoft.public.sqlserver.security)
  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... The username & password for connecting to the linked server ... Have you tried making the database trustworthy? ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to FoxPro data
    ... Since you want to "mix" the Fox tables with the SQL tables it sounds like ... Note that when you select data from a VFP linked server you need the three ... the data source string in the example is for a FoxPro DBC or "database ...
    (microsoft.public.sqlserver.connect)