Problems using Linked Server.

Hi, I have a process that execute a query that is created on a linked
server. This process is scheduled in a job. Every Time the job runs
report this error:
Executed as user: domain\servicesaccount. OLE DB provider 'SQLOLEDB'
reported an error. [SQLSTATE 42000] (Error 7399) OLE DB error trace
[OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned
0x80004005: ]. [SQLSTATE 01000] (Error 7300) [SQLSTATE 01000] (Error
7312). The step failed.
Do some body know how can I solve the problem?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Error 0x80004005 is access denied so you'd want to start by
checking the permissions for the login accounts used in the
security mapping for the linked server.
-Sue
On Mon, 23 Jan 2006 07:25:51 -0800, MariaGuzman
<marisa@.devdex.com> wrote:

>Hi, I have a process that execute a query that is created on a linked
>server. This process is scheduled in a job. Every Time the job runs
>report this error:
>Executed as user: domain\servicesaccount. OLE DB provider 'SQLOLEDB'
>reported an error. [SQLSTATE 42000] (Error 7399) OLE DB error trace
>[OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned
>0x80004005: ]. [SQLSTATE 01000] (Error 7300) [SQLSTATE 01000] (Error
>7312). The step failed.
>Do some body know how can I solve the problem?
>Thanks a lot for your help.
>*** Sent via Developersdex http://www.codecomments.com ***