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.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..

thanks.

Roberto Tamez
RealhawkAsked:
Who is Participating?
 
gpompeConnect With a Mentor Commented:
On the server1 you have a Linked Server called aero_sif pointing to server2. In the security tab you have de server1 is using to access Server2.

Have you try login into Server2 with that user and try select * from dbsifaero.dbo.tblclientes ?

Let me know
0
 
RealhawkAuthor Commented:
I already tried the command select * from frisa_sim.dbo.tblclientes on server2 to server1 and works..

I used the sa account, just for permissions issue.. but still the same..

Regards..

RTL

0
 
RealhawkAuthor Commented:
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\Mssqlserver\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
0
 
RealhawkAuthor Commented:
Question to Expert Exchange Administrator:

What happen if I found myself the answer.. what about the points?

Regards

RTL
0
 
RealhawkAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.