• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 540
  • Last Modified:

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
0
Realhawk
Asked:
Realhawk
  • 4
1 Solution
 
gpompeCommented:
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now