Hello,
Linked Server to Excel spreadsheet
I have no problem executing a Linked Server query through Query Analyzer
(Administror) or through an ASP page connecting through a Login setup throug
h
Enterprise Manager with: Server Role - Systems Administrator. However any
ohter lesser Login / Role yields:
ERROR -
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
NOTES:
* Link Server Properties / Security is - DEFAULT
* Permissions on Excel spreadsheet & directory are - Everyone
Thus, I believe what I'm looking for are the What and How on setting
permissons for executing this query on the linked server?
I have been struggling with this for several days and do not find much on
the web per this issue... any help would be appreciated.
Thanks, j"JLatiolait" <JLatiolait@.discussions.microsoft.com> wrote in message
news:1F47F9C9-18EF-4B60-9D36-42BBD1C56052@.microsoft.com...
> Linked Server to Excel spreadsheet
> I have no problem executing a Linked Server query through Query Analyzer
> (Administror) or through an ASP page connecting through a Login setup
through
> Enterprise Manager with: Server Role - Systems Administrator. However any
> ohter lesser Login / Role yields:
> ERROR -
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
> NOTES:
> * Link Server Properties / Security is - DEFAULT
> * Permissions on Excel spreadsheet & directory are - Everyone
Everyone = what permissions at the NTFS layer?
Steve
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment