Realhawk
asked on
Problems to get communicate between 2 SQL 2000 Servers.
Hi..
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.tbl clientes
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..
thanks.
Roberto Tamez
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.tbl
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..
thanks.
Roberto Tamez
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I found the answer,
to fix the error:
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.].
in the query analyzer go to HKLM\Software\Microsoft\Ms sqlserver\ providers\ SQL OLEDB using Regedit command
Check all the parameters except AllowInProcess , they must have 0 in the value field and just the AllowInProcess must to have the value of 1.
And works..
Regards..
RTL
to fix the error:
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.].
in the query analyzer go to HKLM\Software\Microsoft\Ms
Check all the parameters except AllowInProcess , they must have 0 in the value field and just the AllowInProcess must to have the value of 1.
And works..
Regards..
RTL
ASKER
Question to Expert Exchange Administrator:
What happen if I found myself the answer.. what about the points?
Regards
RTL
What happen if I found myself the answer.. what about the points?
Regards
RTL
ASKER
Venabili:
You doesn´t answer my question..
I said, I found the answer.. and I added here..
anyway.. I will take the answer from gpompe because he was the only person to answer my question, but I got the answer from myself..
for anyone who has the same problem like me.. here is the Answer..
Regards..
RTL
You doesn´t answer my question..
I said, I found the answer.. and I added here..
anyway.. I will take the answer from gpompe because he was the only person to answer my question, but I got the answer from myself..
for anyone who has the same problem like me.. here is the Answer..
Regards..
RTL
ASKER
I used the sa account, just for permissions issue.. but still the same..
Regards..
RTL