Re: 'SQLOLEDB' - 0x80004005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

It is a network issue. Have your network guys monitor the connectivity to
the server on a continuous basis. Ping or MRTG could be the tools for them.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/



"Shima" wrote:

> Mike,
> What can I check about connectivity ? Is there same trace I can run to
> identify the problem ? thanks a lot !
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > 0x80004005 = Access Denied
> >
> > You might be experiencing intermittent connectivity problems, so your
> > connection might have failed.
> > Or the destination server handle not handle more simultaneous connections.
> >
> > Regards
> > --------------------------------
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@xxxxxxxxxxxx
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Shima" <Shima@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:AB5151B0-0BDC-4BD8-A372-8B79D19D5E15@xxxxxxxxxxxxxxxx
> > > SQL 2000 - 8.00.878 - cluster environment.
> > > The application and database are in Internet. There is a linkedserver to
> > > access a db in Intranet. Sometimes shows up the message below:
> > > OLE/DB Provider 'SQLOLEDB' IRowset::GatherStats returned 0x80004005: OLE
> > > DB
> > > provider SQLOLEDB returned 0x80004005 for OpenRowset during statistics
> > > gathering.
> > >
> > > Please, tell if you want more details.
> > > thanks
> > > Simone
> >
> >
> >
.

Relevant Pages

  • Re: Root domain controller and network connectivity
    ... another vm also connected to the internal network. ... DNS server to forward to a public DNS. ... I just don't have network connectivity. ... During the 2003 first install you don't have to. ...
    (microsoft.public.windows.server.networking)
  • Network connectivity on Iomega NAS running W2K server
    ... company uses this primarily as a file server, ... network slowdowns, so I connected to the NAS to take a look at the NIC ... There are two NICs, with one having the static IP ... I lost connectivity to the NAS unit. ...
    (microsoft.public.win2000.advanced_server)
  • Network connectivity on Iomega NAS running W2K server
    ... company uses this primarily as a file server, ... network slowdowns, so I connected to the NAS to take a look at the NIC ... There are two NICs, with one having the static IP ... I lost connectivity to the NAS unit. ...
    (microsoft.public.win2000.networking)
  • Re: error 52
    ... The RPC server is unavailable. ... connected to the network. ... This event may be caused by a temporary loss of network connectivity. ...
    (microsoft.public.win2000.networking)
  • Re: Multiple server problems - HELP!
    ... DNS Suffix Search List...: name.local ... DHCP on server is 192.168.10.101 to .254. ... SBS's LAN NIC case that DHCP server REALLLLLY should be the SBS server. ... Internet Connectivity ...
    (microsoft.public.windows.server.sbs)