Re: Rights for Linked Server

Jeff,

Sorry not to be more help. I suggest that, if you have not already done so,
you also post this problem to an IBM DB2 news group such as the one
reflected here.
http://www.thescripts.com/forum/thread181293.html

RLF

"jeff" <jeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2539975C-86B1-4A38-ADA8-E68FB4ABAC1B@xxxxxxxxxxxxxxxx
Here is more info........I check the user security settings...all ok.


Here's the setup:
SQL Server 2005 x64 (on Windows Server 2003 x64)
IBM DB2 Client x64 installed on DB Server
Linked Server from SQL Server to DB2 DataBase via IBMDADB2 OLE DB provider
(no ODBC driver on X64 !?)
Attempting to use SQL Server "OpenQuery" functionality to performs selects
on DB2 DataBase
Any attempt to access with Administrator (so far narrowed to the box -
might
be more specific) is successful
Any attempt by a non administrator (end users) is blocked - error codes
SQL1092N (Generally -- not authorized)


JT

"Russell Fields" wrote:

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








.

Relevant Pages

  • RE: Cant set Local Security policies. They fail to save
    ... I followed your instructions on applying the predefined security templates. ... I still can’t set any of the local security policies on the server box. ... > using local Administrator account to test, ... >>> member of either the Remote Operators group or the Domain Power Users ...
    (microsoft.public.windows.server.sbs)
  • Re: FOR A SKILLED IT EXPERT - WIN2K SERVER - DOMAIN CONTROLLER
    ... After installing a parallel copy of WIN2K SERVER, ... Administrator access in Directory Services Restore Safe Mode. ... This reset the local policy back to ... manual security reset. ...
    (microsoft.public.win2000.security)
  • Re: Queries regarding DCOM Security Enhancements in Windows XP Service Pack 2
    ... administrator, while server security lies with the developer. ... not be adequate for the client-server application, ...
    (microsoft.public.win32.programmer.ole)
  • Re: Unable to login to SBS Server
    ... Les Connor [SBS MVP] ... We were asked to look at a SBS 2003 server & found that the group policy has somehow been altered & we decided to do a complete re-install of the system. ... I guess this is because the administrator cannot log on so I then checked the local policy by running secpol.msc and then checked Security ...
    (microsoft.public.windows.server.sbs)
  • RE: IIS Virtual Directory Create Failure :(
    ... override code access security for these specific operations. ... making a call that if overdone could flood your box and disable your server. ... >didnt work even with an administrator logged in...impersonation didn't ...
    (microsoft.public.dotnet.framework.aspnet.webservices)