Re: OPENROWSET

We've set the SQL Service to run on a domain admin account.
Bad practice yes, but trying to resolve issue.
Still errors with the same message.

We're trying to execute the openrowset command in a production environment,
but can't get anything to run unless the account
executing the SQL is admin on local box. Any directions to look?


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:pk6s72lflnf7r0n8p2ok5uvtr816aiv429@xxxxxxxxxx
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: Discussing 3 different strategies for deleting from multiple tables
    ... I found that it may be the limitation that is specific to the SQL OLE DB Provider when trying to use .Refresh method on the recordset to retrieve parameter information. ... I will only use 3 tables for brevity - Account, Contact, ...
    (microsoft.public.data.ado)
  • RE: sql server startup account
    ... local administrator rights on the SQL box but now when I try to connect with ... If I switch to a domain admin account or a local system account NT ...
    (microsoft.public.sqlserver.server)
  • Re: Website Administration Tool not working from published applica
    ... provider, whom most of them can't afford the fancy of dedicated servers - ... SQL Server 2000 instead of SQL Express ... The first mistake was using ... that the Web App Admin Tool shows when it cannot connect to the database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)