I have multiple servers. From one production server (A), I can establish Li
nked Servers to other servers. However, I am not able to establish a Linked
Server to one specific server (B). The servers are on different domains. H
owever, I am able to link f
rom A to other servers on the same Domain as B.
-- From the production server A I can open Query Analyzer directly to server
B -- so I do believe that the Client Network Utility is correct
-- I have recreated the Linked Server/security panel for the login I"m using
, and believe the login/password is set up correctly.
-- Both server A and server B are clustered, running Win2003 and SQL2000 wit
h patches.
Here is the error message I receive when I try to do a select * from B.maste
r.dbo.sysobjects (or any other db/talble) when logged in to A in Query Analy
zer:
Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider 'MediaCatalogDB.1
'.
OLE DB error trace [OLE/DB Provider 'MediaCatalogDB.1' IDBInitialize::In
itialize returned 0x80030003].
BOL indicates this is due to two things: the server is set up with wrong dat
a in linked server or the login is incorrect.
Any other suggestions? Thanks much.
LindaAfter posting the message, I recreated the linked server in question again.
This time all is well.
So sorry for the post!|||Hi Linda:
How did you fix this? I am having the same problem. I am trying to link to
sql server in a different domain. I am getting the error message that sql
server does not exist. Thanks
No comments:
Post a Comment