"Darren" <Darren@discussions.microsoft.com> wrote in message
news:9D447CD1-B0CA-43C5-A5C6-9724D5D783F2@microsoft.com...
> We currently setup an environment using the Server Alias from the SQL
> Server
> Client Network Utility. We are using these connections (which are
> different
> servers than the one we configured the alias on) as link servers. When I
> attempt to run a Store Procedure with BEGIN TRANS trying to get data from
> one
> of these Aliases I get this error message:
>
> Server: Msg 7391, Level 16, State 1, Procedure usp_Blah, Line 60
> 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].
>
> Can anyone tell me why this is happening? I have read through some
> newsgroups and most people say you can't run a transaction on a server
> alias
> if it points to the same the server, but we are pointing to different
> physical SQL Servers. Is this an Alias issue? Or do I have something
> configured incorrectly?
>
> Darren

"Uri Dimant" wrote:

> Darren
> Try BEGIN DISTRIBUTED TRAN command inside the stored procedure
>
>
>
>
>
> "Darren" <Darren@discussions.microsoft.com> wrote in message
> news:9D447CD1-B0CA-43C5-A5C6-9724D5D783F2@microsoft.com...
> > We currently setup an environment using the Server Alias from the SQL
> > Server
> > Client Network Utility. We are using these connections (which are
> > different
> > servers than the one we configured the alias on) as link servers. When I
> > attempt to run a Store Procedure with BEGIN TRANS trying to get data from
> > one
> > of these Aliases I get this error message:
> >
> > Server: Msg 7391, Level 16, State 1, Procedure usp_Blah, Line 60
> > 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].
> >
> > Can anyone tell me why this is happening? I have read through some
> > newsgroups and most people say you can't run a transaction on a server
> > alias
> > if it points to the same the server, but we are pointing to different
> > physical SQL Servers. Is this an Alias issue? Or do I have something
> > configured incorrectly?
> >
> > Darren
>
>