problems with running stored procedure via MSDTC on server 2003

Hi,
I would like a little help from someone who is experienced with msdtc on
server 2003.
We have a trouble with running a stored procedure using dtc on win2003server
ent. With sql server 2000 SP3.
For some reason it returns this error:
Server: Msg 7391, Level 16, State 1, Procedure
> sp_BannerOnKeyword_Update, Line 29 The operation could not be
> performed because the OLE DB provider 'SQLOLEDB' was unable
> to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot
> enlist in the specified transaction coordinator. ] OLE DB
> error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
Error comes out in place where that sp points on linked server, defined in
linked server in ent. Manager.
On w2k sp4 it works without problems, with the same linked server.
All servers runs msdtc and when I perform with dtcping.exe they see each
other without problems.
Also servers are on the same switch without firewall.
Also I tried to enable network dtc access in 2003 settings, which didn't
help.
When browsing google it seemed to me that its quite common problem since
nt4, but I didn't find solution for fixing it.
Thanks a lot for help, it would be very helpful for me.
regards
Martin Cvancara
Chief System Administrator
Atlas.cz a.s.Although I don't know which ports/services need to be opened up, your
problem is related to the fact the Win2003 has everything close down ( like
DCOM, etc) when it is installed...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Martin Cvancara" <martin@.cvancara.com> wrote in message
news:#ChuXLnjDHA.2536@.tk2msftngp13.phx.gbl...
> Hi,
>
> I would like a little help from someone who is experienced with msdtc on
> server 2003.
>
> We have a trouble with running a stored procedure using dtc on
win2003server
> ent. With sql server 2000 SP3.
>
> For some reason it returns this error:
>
> Server: Msg 7391, Level 16, State 1, Procedure
> > sp_BannerOnKeyword_Update, Line 29 The operation could not be
> > performed because the OLE DB provider 'SQLOLEDB' was unable
> > to begin a distributed transaction.
> > [OLE/DB provider returned message: New transaction cannot
> > enlist in the specified transaction coordinator. ] OLE DB
> > error trace [OLE/DB Provider 'SQLOLEDB'
> > ITransactionJoin::JoinTransaction returned 0x8004d00a].
>
> Error comes out in place where that sp points on linked server, defined in
> linked server in ent. Manager.
>
> On w2k sp4 it works without problems, with the same linked server.
>
> All servers runs msdtc and when I perform with dtcping.exe they see each
> other without problems.
> Also servers are on the same switch without firewall.
>
> Also I tried to enable network dtc access in 2003 settings, which didn't
> help.
>
> When browsing google it seemed to me that its quite common problem since
> nt4, but I didn't find solution for fixing it.
>
> Thanks a lot for help, it would be very helpful for me.
>
> regards
>
> Martin Cvancara
> Chief System Administrator
> Atlas.cz a.s.
>