Re: Rights for Linked Server
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Fri, 18 Jan 2008 13:58:10 -0500
Jeff,
Are your System Administrators administrators of both the SQL Server 2005
server and the DB2 server? If they are, there is some suggestion (that I
cannot verify) that this will circumvent the normal security for DB2.
IF that is the case, it would suggest that the login and password in the "Be
made using this security context" boxes are in error. Could you doublecheck
those entries?
RLF
"jeff" <jeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7291C41-1D0B-4D7A-BA6D-CFC02CECD77C@xxxxxxxxxxxxxxxx
Doing properties of the Link Server object and selecting Security.....I
have
only the account necessary to access the DB on DB2.."Be made using this
security context".......I have nothing defined for "Local Server Login to
Remote Server Login mappings...
Thanks
"Russell Fields" wrote:
Jeff,
What are the security settings for your linked server? This is on the
Security table of the linked server form. You can creates a script to
display the linked server definition.
RLF
"jeff" <jeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6D668A6-558A-4B32-B112-AD1C0EE10AF4@xxxxxxxxxxxxxxxx
SQL Server 2005 linked to DB2......
The queries are successful when procs that access data via the linked
server
are run by System Administrator. Standard users get the
following...error
code SQL1092N Access Denied.
THKS
.
- Follow-Ups:
- Re: Rights for Linked Server
- From: jeff
- Re: Rights for Linked Server
- References:
- Re: Rights for Linked Server
- From: Russell Fields
- Re: Rights for Linked Server
- Prev by Date: Re: SQL 2005: non SA user create a job
- Next by Date: Re: Rights for Linked Server
- Previous by thread: Re: Rights for Linked Server
- Next by thread: Re: Rights for Linked Server
- Index(es):
Relevant Pages
|
|
