Error while deploying BizTalk assembly

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Error while deploying BizTalk assembly

Viewing 1 reply thread
  • Author
    Posts
    • August 14, 2008 at 7:34 AM #20412
      community-content

        Hi I get following error while deploying a BizTalk assembly

         

        Login failed for user ”. The user is not associated with a trusted SQL Server connection.  

        What could be the possible reason for this. I have logged in as Administrator for deploying the assembly

        Regards,

        SKL

      • August 14, 2008 at 8:22 AM #20413
        community-content

          SKL,

          See http://support.microsoft.com/kb/555332 – The SQL server has been configured to operate in Windows Authentication Mode and doesn’t allow the use of SQL accounts.

          HTH, Nick.

          • August 19, 2008 at 10:34 PM #20443
            community-content

               Hey Nick,

              Thanks for the reply!!! It works dude… one more thing i noticed was SQL server was running under Admin login and not Network Service login so the problem was somebody changed the password of Administrator and that made SQL server also not to work properly.

              Thanks once again

              Regards,

              SKL

              • August 20, 2008 at 1:44 AM #20446
                community-content

                  SKL,

                  Pleased to hear that it worked, can you mark the thread as answered.

                  Cheers, Nick.

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