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 |
|
SQLNOVICE999
Yak Posting Veteran
62 Posts |
 Posted - 2012-07-10 : 20:37:27
|
| We installed SQL 2012 recently... linked server between SQL 2012 and SQL 2008 using SQLNCLI11 is working fine; however, we have issues creating linked server between SQL 2000 and SQL 2012. We did these below:1. We installed the DLL for SQLNCLI102. Our SQL 2000 has SP4 so we Executed the script instcat.sql again in query analyzer we got few warnings but the scripts executed with no error3. We created the Linked Server between SQL 2000 and SQL 2012 in SQL 2012 and we can view the catalogs; however, when we query the catalog we get the ERROR below:Msg 8522, Level 16, State 3, Line 1Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction.I am not sure why I am getting this error when the linked server with SQL 2008 is doing fine and there is not MS DTC error also linked server using the same SQL 2000 server with SQL 2008 server is working fine as well so I don't think there is issue with configuring MSDTC. Anyone with experience, please suggest what we should look for? Sould we reinstall the SQL 2012 again? Should we install SQL 2008 and then upgrade to SQL 2012? Thanks a lot for your help. |
|
|
prett
Posting Yak Master
212 Posts |
|
|
|
|
|
Linked Server SQL 2000 - SQL 2012