I have a problen getting response from biztalk SQL Adapter.
I generated SPROC schema using SQL Adapter windows Authantication, completed all the process(orchastration).
when i am run the process i am getting bellow error:
The adapter "SQL" raised an error message. Details "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
My SQL BOX is Remote Server(security-sql and windows mode), i have admin rights. BizTalk and SQL Box both are in same domain.
i am Attaching MSDTC configuration.
i can't login as username\pwd, only i can login as windows authentication.(mandatory for client)
Any help is appreciated.
Thanks