POSTED AGAIN- DISTRIBUTED TRANSACTION

Hi,
I have two sql servers with SQL2000 service pack 3 which are linked by the
"Link Server". When i use the "begin tran" (distributed transaction) in
stored procedure, i am getting the following error.
"Server: Msg 8525, Level 16, State 1, Line 1
Distributed transaction completed. Either enlist this session in a new
transaction or the NULL transaction. "
The following article talks about this problem.
http://support.microsoft.com/?kbid=834849
But, both servers are SQL 2000 in my case. Any help?
Thanks,
VijayVijay,
Try rerun the same Instcat.sql described in the kb again on each node. This
will ensure that they have the correct catalog sprocs.
-oj
"Vijay" <vijay@.infosysusa.com> wrote in message
news:%23yRbv$LBFHA.1200@.tk2msftngp13.phx.gbl...
> Hi,
>
> I have two sql servers with SQL2000 service pack 3 which are linked by the
> "Link Server". When i use the "begin tran" (distributed transaction) in
> stored procedure, i am getting the following error.
>
> "Server: Msg 8525, Level 16, State 1, Line 1
> Distributed transaction completed. Either enlist this session in a new
> transaction or the NULL transaction. "
>
> The following article talks about this problem.
> http://support.microsoft.com/?kbid=834849
> But, both servers are SQL 2000 in my case. Any help?
>
> Thanks,
> Vijay
>
>|||I don't think so. It is working for other distributed queries. Any other
solutions please?
Thanks,
Vijay
"oj" <nospam_ojngo@.home.com> wrote in message
news:%23bSADGMBFHA.1076@.TK2MSFTNGP10.phx.gbl...
> Vijay,
> Try rerun the same Instcat.sql described in the kb again on each node.
This
> will ensure that they have the correct catalog sprocs.
> --
> -oj
>
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:%23yRbv$LBFHA.1200@.tk2msftngp13.phx.gbl...
the
>|||Vijay,
What do you mean "It is working for other distributed queries". If you only
encounter the error on enlisting a distributed transaction, I suggest you
take a look at your linkedserver logins. Also, check to make sure DTC
services are using proper accounts. If they're started under LocalSystem, it
will not have access to network resources. If you are going to make any
changes to your DTC services, you will have to restart SQL server for it to
takes effect.
-oj
"Vijay" <vijay@.infosysusa.com> wrote in message
news:eKKqhVMBFHA.1992@.TK2MSFTNGP10.phx.gbl...
>I don't think so. It is working for other distributed queries. Any other
> solutions please?
> Thanks,
> Vijay
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:%23bSADGMBFHA.1076@.TK2MSFTNGP10.phx.gbl...
> This
> the
>