| Author |
SQL Adapter Wizard Error
|
|
|
| Hi
I'm trying to configure the sql adapter for stored procedure using the SQL
Adapter Wizard. Biztalk databases are running in the local SQL Server but
the SQL Server Database with the stored procedure is runnig on a remote
machine.
I've followed the steps in the article "Using the SQL Adapter with a Stored
Procedure in an Orchestration"
(http://msdn.microsoft.com/library/d..._adapt_tbdk.asp)
and I'm getting the following error in the last step of the wizard:
"Failed to execute SQL Statement. Please ensure tha the supplied syntax is
correct.
New transaction cannot enlist in the specified transaction coordinator."
I've tried the DTCPing tool for troubleshooting MSDTC connectivity issues
between the servers and everything seems to be ok!
Any help?
Thanks in advance!
| |
|
|
|
|
|
| Biztalk server is installed on a VPC in a workgroup (Windows Server 2003
Standard SP1) and the remote SQL is on a domain!
IŽll try adding the VPC to the domain and see what happens! IŽll comment you
later!
IŽve tested a distributed transaction using .Net and works fine! I think
this is a Biztalk issue
Thanks for the reply!
"Marian Drumea" <mdrumea@gmail.com> wrote in message
news:1133321242.949075.273290@z14g2000cwz.googlegroups.com...
> Is the remote server on a distinct domain?
>
> Thanks,
>
> Marian
> http://www.MarianDrumea.com/BizTalk
>
| |
|
| Finally adding the Biztalk Server machine to the same domain as the remote
SQL solved the problem!
Thanks u all!
"Marian Drumea" <mdrumea@gmail.com> wrote in message
news:1133321242.949075.273290@z14g2000cwz.googlegroups.com...
> Is the remote server on a distinct domain?
>
> Thanks,
>
> Marian
> http://www.MarianDrumea.com/BizTalk
>
|
|
|
|