SQL Adapater-Remote DB issue

Home Page Forums BizTalk 2004 – BizTalk 2010 SQL Adapater-Remote DB issue

Viewing 1 reply thread
  • Author
    Posts
    • #16150

      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

    • #16171

      Have you checked that the user running the SQL Adapter (i.e. the host) has access to SQL?  I’m guessing it’s a permissions problem.

      • #16197

        That acoount got SQL Admin level access.

        • #16202

          Sorry, permissions is about the only think I can think of for this type of error.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.