Re: OPENROWSET

Yes...0x80004005 often indicates a permissions issue.
Check the permissions for the SQL Server service account and
make sure it has access to the network resources,
directories.

-Sue

On Wed, 31 May 2006 13:35:37 -0500, "Sol Rosenburg"
<jvandyne@xxxxxxxxx> wrote:

I'm having problems with OPENROWSET with excel file.

I have excel file in network accessible folder. File opens in excel by
entering each of the following in explorer address

\\server\wwwroot$\file.xls
\\server\file.xls
\\server\c$\inetpub\wwwroot\file.xls

However OPENROWSET only works for
\\server\wwwroot$\file.xls
Otherwilse error message returned =
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider
did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: The provider did not give
any information about the error.].

I think there might be a permissions problem somewhere : maybe domain, maybe
sql service account. Question is: what context / account is used to execute
openrowset for each of above?


.

Relevant Pages

  • Re: solving the problem of spsearch
    ... like a class id of 617 something), and if you give the configuration ... the service to run if I put my service account into the local machine ... After a lot of tinkering with COM launch permissions (which didn't ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: solving the problem of spsearch
    ... the service to run if I put my service account into the local machine ... After a lot of tinkering with COM launch permissions (which didn't ... to get the search service to run without error. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ADAM Service Account
    ... How do you set the permissions for the Network Service Account to ... be able to use SSL in ADAM. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Error 22039 trying to add SQL 2K to AD
    ... "permissions that matter but rather the permissions of the SQL Server ... What do I lose by not having SQL server registered with AD? ... > of the SQL Server service account. ...
    (microsoft.public.sqlserver.setup)
  • Re: OPENROWSET
    ... Hidden shared resource C$ serves for administrative purposes that is why it ... permissions for shares are both filesystem permissions ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... sql service account. ...
    (microsoft.public.sqlserver.security)