I got same error yesterday when trying to use my laptop on my own workgroup
to connect to a SQL Server on a domain using an SQL (non-windows)
users/password.   I can connect fine in Enterprise Manager or Query Analyzer
.
Today we are going to try the same thing on the domain and we think it will
work - but why can't we run it from a non-domain PC?

Another laptop got a similar message - something about a distributed
transaction failed.

Neal Walters
http://Biztalk-Training.com - Biztalk Training Videos


"sg" wrote:

> Hi All,
>        I have a small problem.
> My host machine have
> a>Windows 2003 server machine
> b> Biztalk Server 2004
> c> SQL Server
>
> Remote Server
> a>Windows 2000 Server
> b>SQL Server
>
> I am trying to generate Schema using SQL Adpter in receive location in my
> host machine.SQL Adapter connect to Remote Server for generating schema.I 
can
> able to connect to remote server but as soon as i provide stored procedure
> name and click next i am receiving following error.
>
> Failed to connect SQL Statement.Please ensures that the supplied syntax be
en
> correct.The Transaction has already been implcitly or explicitly committed
 or
> aborted.
> my storedprocedure look like this
> select * from orders for xml auto,xmldata
>
> Thanks
> sg

[ Post a follow-up to this message ]