OPENROWSET security

From: Mike Wade (michael.wade1@btinternet.com)
Date: 08/27/02 

From: "Mike Wade" <michael.wade1@btinternet.com>
Date: Tue, 27 Aug 2002 07:43:37 -0700

Hi,

I am trying to query an access database using OPENROWSET.
and am getting error 7415 (7415 16 Ad hoc access to OLE DB
provider '%ls' has been denied. You must access this
provider through a linked server. )

SELECT * FROM OPENROWSET('\\server1
\c$\a.mdb';'admin';'',Table1)

I really dont want to set up a linked server. under sa
account it works but it doesnt under another account which
is a dbo but not a system administrator. I dont really
understand why not. Can anyone shed light on this
problem and how to overcome it?

Thanks

Mike

Relevant Pages

  • Re: Renaming AD User Accounts using the WinNT Provider
    ... Rename the AD Username and Pre-Windows 2000 username with new ... Disable the account once it has been renamed. ... The distinguishedName of the object uniquely identifies the object, ... The first problem with your question is that the WinNT provider is blind to ...
    (microsoft.public.scripting.vbscript)
  • Re: Cannot start services
    ... | Computer: COUNTYG ... see Help and Support Center at ... | A provider, PerfProv, has been registered in the WMI namespace, ... | will be run using the LocalSystem account. ...
    (microsoft.public.windows.server.general)
  • Re: problems sending mail
    ... But for some reason if I configure another account using the same settings - it doesn't work. ... an e-mail provider saying a message was undeliverable, and doesn't seem to be generated by your PPC. ... I called Demon (service provider) on the phone and had them look at my data coming out. ...
    (microsoft.public.pocketpc)
  • Re: Linked server to as400 - for the love of god please help.
    ... > There is an ODBC DSN on the server machine. ... Creating a linked server using ... > OLE DB provider 'MSDASQL' reported an error. ... > So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • Unknown Error Logs--Help Decifering
    ... >account from logging in, etc. and am running the XP ... >Computer: MyComputer ... >Windows cannot unload your classes registry file - it is ... >A provider, OffProv10, has been registered in the WMI ...
    (microsoft.public.windowsxp.security_admin)