Errors with linked server

We have a scheduled job that is running on a server, which gets the data fro
m
other linked server using SP.
OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:
Please help
Thanks,
RKHi
0x80004005 means "access denied" in the COM environment.
Check that you have permissions, especially under which account you connect
to the linked server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ram Kumar Koditala" <RamKumarKoditala@.discussions.microsoft.com> wrote in
message news:D460E1EF-7DAA-48E1-A897-6B3A24C024B1@.microsoft.com...
> We have a scheduled job that is running on a server, which gets the data
from
> other linked server using SP.
> OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error
7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
> 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:
> Please help
>
> Thanks,
> RKsql