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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2009-08-20 : 17:11:37
|
| Hi ExpertsI am creating linked server from sql server 2005 32 bit to sql server 2000 32 bit, but I am receiving the following error:"Linked server has been created but failed connection test". Any help in this regard will be appreciated.Thanks |
|
|
amrosalah
Starting Member
6 Posts |
Posted - 2009-08-20 : 18:34:21
|
| Are you able to connect using query analyzer from the machine having SQL 2005 to the machine having 2000 ?Free Sql Service Managerhttp://www.freesqltools.info |
 |
|
|
|
|
|
Linked Server