| Neal Walters 2004-09-29, 8:02 pm |
| 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 been
> 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
|