SQL Adapter Access Response issue

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adapter Access Response issue

Viewing 1 reply thread
  • Author
    Posts
    • October 17, 2006 at 6:46 AM #16078
      community-content

        Hi,

        i created SPROC Schema using SQL Adapter  and created static-solicit sendport(windowsNT authintication connection string)

        when i run the process i am getting follwing warning and no response back:

        The adapter "SQL" raised an error message. Details "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ".

        I have admin rights to my computer and i am in the domain, i configured MSDTC(checked allowed remote client\admin,checked inbond\outbond and no authantication required)

        Any help is appreciated

        Thanks

        R-

      • October 18, 2006 at 4:56 PM #16104
        community-content

          Hmm. What rights does the Biztalk Host Instance account have?  Is that also an admin?  Does that user have "execute" rights on the proc?

          • October 19, 2006 at 6:48 AM #16124
            community-content

              Thanks for your response.

              What rights does the Biztalk Host Instance account have?  Is that also an admin? 

               Local account with admin rights.

              my m\c and sql server both are in same domain.

               Does that user have "execute" rights on the proc?  

               Yes i have excute rights on sproc

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