Re: Linked Server Security question

Yes, it does.


Arnie Rowland wrote:
Does the account SQL Server runs under also have file privileges?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"cityboy" <cityboy3@xxxxxxxxx> wrote in message
news:1153938101.709097.52900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
thanks for the reply. I had temporarily given all users all rights to
that folder and all files in it. Nothing changed.


Arnie Rowland wrote:
The mdb file is just a file system file. Check to see if OS file
permissions
may need to be adjusted to allow READ/WRITE privileges. to the file and
perhaps even to the folder.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"cityboy" <cityboy3@xxxxxxxxx> wrote in message
news:1153936506.808883.254840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am new to the linked server concept and I'm having trouble with the
following scenario:

Users are trying to run a report from Reporting Services whose data is
supplied from a stored procedure. The stored procedure gets its records
from 2 sources. One is a regular SQL Server table. The other is an MS
Access mdb that resides on the c: drive of the same server. In order
for the stored procedure to work, I had to set up the Access mdb as a
Linked Server.

When I run the report with my administrative rights, everything works
fine. However, regular users get an error and my testing reveals that
it's related somehow to the security on that linked server.

I've made sure that all users have rights to the mdb file. I've also
tried various property settings in the Linked Server Security
properties. The documentation isn't very helpful. Any help will be
greatly appreciated.

thx



.

Relevant Pages

  • Re: Linked Server Security question
    ... that folder and all files in it. ... Arnie Rowland, Ph.D. ... When I run the report with my administrative rights, ... it's related somehow to the security on that linked server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... comments which contradict others' suggestions or material in a ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)