Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-10 : 12:31:36
|
| Eddie writes "I have been all over the place and have not found anything beyond clicking the buttons examples.Here is the layoutbox1 - db4 windows2000as with sql2000box2 - db2 windows NT with sql7in Ent Mgr on box1 I add box2 as a linked server give it a good password and login and it looks fine. Using this link in any t-sql statement get the error "cannot find server or access denied".I can setup an odbc data source from db4 pointing to db2 and use that from within query analyzer fine with the logins used in setting up the linked server.Do these machines have to be within the same domain? Putting in the FQDN of the machine in the linked server name does not work and neither of them is within a domain, just 2 lonely dbs sitting on different sides of the country.I have been all over everywhere looking for clues, can you folks help out and be my hero! I am willing to make arrangements for compensation for someone who can get this working. I'm dying over here!Thanks,Eddie" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-10 : 12:43:44
|
| sp_addlinkedserver @server='ServerName', @srvproduct='', @provider='SQLOLEDB', @catalog='DatabaseName'This is supposing you have the user you are using locally set up on the remote server...Look at sp_addlinkedsrvlogin if this isn't the case... |
 |
|
|
|
|
|
Linking SQLserver2000 to a SQL server 7 machine