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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-11-19 : 14:36:52
|
| Dear gurus,I have a problem with linked server.I have a sql server 2000 with Sp1 in Windows 2003 Server and I have SQl server 2005 with SP2 in Windows 2003.While making linked server between those two server, i am getting error.After applying catelog procedres (instcat.sql), its working perfect.Without applying instcat.sql I can able to make a linked server With Windows Xp (SQl 2005 )and SQL 2000 (Windows 2003)Can anyone give me the idea about this one..?Note: All are Physical box not a virtual machine.Thankskrishna |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-19 : 22:45:50
|
| Maybe mdac version issue. |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-20 : 13:59:11
|
quote:
Originally posted by CSK
Dear gurus,I have a problem with linked server.I have a sql server 2000 with Sp1 in Windows 2003 Server and I have SQl server 2005 with SP2 in Windows 2003.While making linked server between those two server, i am getting error.After applying catelog procedres (instcat.sql), its working perfect.Without applying instcat.sql I can able to make a linked server With Windows Xp (SQl 2005 )and SQL 2000 (Windows 2003)Can anyone give me the idea about this one..?Note: All are Physical box not a virtual machine.Thankskrishna
See the blue text in your post? How about telling us what the error was? That might help.Think before you post. The information you give us in your message is all the information we have about the problem. Did you provide us any information at all that would help us help you? |
|
|
|
|
|
|
Linked server.