Problems to get communicate between 2 SQL 2000 Servers.
Posted on 2006-10-24
This is the scenario.
in 1 server I have windows 2003 Server Standard with SQL 2000 SP4 (let´s called Server1) in another server I have Windows 2000 Server Standard with SQL 2000 SP4 (Server2)
both server try to run a query in the query analyzer.
this is the command: select * from aero_sif.dbsifaero.dbo.tblclientes
and when I ran it on Server2 works, but in Server1 I got this 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.].
I recreate the link server, and add in the hosts file the IP address and the name, but still the same..
can someone help me on this..