Re: Linked Server Security question

Try running a trace when a regular user generates the report
to get more information - you can capture OLEDB errors as
well as SQL Server exceptions, logins, statements executed.
What is the error that the users are getting?

-Sue

On 26 Jul 2006 12:08:11 -0700, "cityboy"
<cityboy3@xxxxxxxxx> wrote:

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: Server Performance Report - Memory in use - showing No data
    ... Please find below the report I received this morning. ... There still isn't any 'Server Specifications' or 'Memory use' data ... click the Backup snap-in in Server Management, ... Critical Errors in Application Log ...
    (microsoft.public.windows.server.sbs)
  • Re: Erroneous E-mails sent entries in Server Usage Report
    ... One of the sbs2k3Sp1 boxes did previously report outgoing messages correctly in the Usage Report. ... I gave up modifying the default recipient policy years ago and now create my own policy on each server before creating users. ... the information "E-mail sent to external recipients" lists *zero* messages being sent by all users other than Administrator. ... Please check the Message Tracking Center. ...
    (microsoft.public.windows.server.sbs)
  • Re: Server Performance Reports broken
    ... I'll try to reinstall R2 and report back on how that goes. ... we cannot remove WSUS from R2 features directly. ... tries to collect WSUS information and WSUS node still appears in Server ... Step 1: Reinstall monitoring component: ...
    (microsoft.public.windows.server.sbs)
  • Re: Server Usage Report
    ... Server firewall to access the Internet. ... Configure ISA Server for monitoring and reporting. ... The SBS Usage report does not pull data from ISA. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Erroneous E-mails sent entries in Server Usage Report
    ... As far as I can recall, this problem was not present on my own server before ... did previously report outgoing messages correctly in the Usage Report. ... I gave up modifying the default recipient policy years ago and now create my ... Please check the Message Tracking Center. ...
    (microsoft.public.windows.server.sbs)