Normal
0
false
false
false
MicrosoftInternetExplorer4
st1\:*{behavior:url(#ieooui) }
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
Hello all,
I am trying to subscribe to a SQL 2000 publisher from a 2005 subscriber. I initially got an error (Microsoft SQL Server, Error: 20620) that I discovered had some thing to do with MSDTC and also that the linked server was not in sys.servers. I made modifications to both boxes' DTC config and also ran sp_addlinkedserver. Now when I add the subscription in 2005, I get the below error:
"TITLE: New Subscription Wizard
------------------------------
SQL Server could not create a subscription for Subscriber 'SQLSERVER2'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPLLINK_TESTDB-476673284_DBxx_DB717017582_DBxx_DBREPL-280078859_Dbxx_DB717017582" was unable to begin a distributed transaction.
Changed database context to 'DBxx_db'.
OLE DB provider "SQLNCLI" for linked server "REPLLINK_TESTDB-476673284_DBxx_DB717017582_DBxx_DBREPL-280078859_DBxx_DB717017582" returned message "No transaction is active.". (Microsoft SQL Server, Error: 7391)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3077&EvtSrc=MSSQLServer&EvtID=7391&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
"
Can anyone post a brief step by step of how they successfully subscribed to a 2000 server from 2005?
Thanks!
Jamy