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: Distributed Query - Linked Servers?
    ... The account I'm using is Windows Domain Account that is a member of the sysadmin server role on both servers. ... Yes, but when you create a linked server in MSSMS, my understanding is that the "Test Connection" facility is not db specific. ... Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "Server2". ...
    (microsoft.public.sqlserver.server)
  • 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)
  • 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)