Linked Server Security question
- From: "cityboy" <cityboy3@xxxxxxxxx>
- Date: 26 Jul 2006 10:55:06 -0700
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
.
- Follow-Ups:
- Re: Linked Server Security question
- From: Arnie Rowland
- Re: Linked Server Security question
- Prev by Date: Re: Mgmt Studio and Sql 2000
- Next by Date: Re: Linked Server Security question
- Previous by thread: Re: Mgmt Studio and Sql 2000
- Next by thread: Re: Linked Server Security question
- Index(es):
Relevant Pages
|
