linked server error: OLE DB provider 'SQLOLEDB' reported an error.

I set up a linked server between two SQL Server databases. I was able to
query the linked database just fine.
Then I deleted the linked server using Enterprise Manager. Then I re-created
the linked server using Enterprise Manager but the original query (select *
from [linked server name].[database name].dbo.[table name]) does not work
anymore even though it used to work before I deleted and recreated the linked
server.
It returns the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any
information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface
returned 0x80004005: The provider did not give any information about the
error.].
Hi,
to solve the problem go the registry
(HKLM\Software\Microsoft\Mssqlserver\providers\SQL OLEDB ) and make sure all
except "AllowInProcess" have a value of 0.
Bye
Gabriele
MCP
"RHI Claims Explorer" wrote:

> I set up a linked server between two SQL Server databases. I was able to
> query the linked database just fine.
> Then I deleted the linked server using Enterprise Manager. Then I re-created
> the linked server using Enterprise Manager but the original query (select *
> from [linked server name].[database name].dbo.[table name]) does not work
> anymore even though it used to work before I deleted and recreated the linked
> server.
> It returns the following error message:
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any
> information about the error.
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface
> returned 0x80004005: The provider did not give any information about the
> error.].
>

linked server error: OLE DB provider 'SQLOLEDB' reported an error.

I set up a linked server between two SQL Server databases. I was able to
query the linked database just fine.
Then I deleted the linked server using Enterprise Manager. Then I re-created
the linked server using Enterprise Manager but the original query (select *
from [linked server name].[database name].dbo.[table name]) does
not work
anymore even though it used to work before I deleted and recreated the linke
d
server.
It returns the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any
information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface
returned 0x80004005: The provider did not give any information about the
error.].Hi,
to solve the problem go the registry
(HKLM\Software\Microsoft\Mssqlserver\pro
viders\SQLOLEDB ) and make sure all
except "AllowInProcess" have a value of 0.
Bye
Gabriele
MCP
"RHI Claims Explorer" wrote:

> I set up a linked server between two SQL Server databases. I was able to
> query the linked database just fine.
> Then I deleted the linked server using Enterprise Manager. Then I re-creat
ed
> the linked server using Enterprise Manager but the original query (select
*
> from [linked server name].[database name].dbo.[table name]) do
es not work
> anymore even though it used to work before I deleted and recreated the lin
ked
> server.
> It returns the following error message:
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error. The provider did not give an
y
> information about the error.
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterfac
e
> returned 0x80004005: The provider did not give any information about the
> error.].
>