An attempt to connect to "BizTalkMgmtDb" SQL Server database on server "<ServerName>" failed. Error: "Login failed for user ”. The user is not associated with a trusted SQL Server connection."

Home Page Forums BizTalk 2004 – BizTalk 2010 An attempt to connect to "BizTalkMgmtDb" SQL Server database on server "<ServerName>" failed. Error: "Login failed for user ”. The user is not associated with a trusted SQL Server connection."

Viewing 1 reply thread
  • Author
    Posts
    • #18633

      Hi Gurus,

      I am new to Biztalk.

        I have installed Biztalk server 2006 in Windows Server 2003. In that server, I am able to create Biztalk Project, deploy and publish an orchestation as web service. And I am able to access that webservice in other web application. Everything going fine.

       I have installed only Biztalk SDK in other system Windows XP, through which i can develop an orchestration and deploy. i have developed an orchestration that can take request and send resonse( it takes a string as input and sends a string as output). I am able to deploy it to server and able to publish as web service. But i am not able to invoke that web service from other appliations. I have added this web service as web reference to web application and written code to invoke the service. when i run the application it is throwing the following error:

      System.Web.Services.Protocols.SoapException: Internal SOAP Processing Failure
        at Microsoft.BizTalk.WebServices.ServerProxy.ServerProxy.Invoke(String functionName, Object[] parameters, ParamInfo[] inParamInfos, ParamInfo[] outParamInfos, Int32 bodyPartIndex, String bodyType, ArrayList inHeaders, ArrayList inoutHeaders, ArrayList& inoutHeaderResponses, ArrayList& outHeaderResponses, Type[] outHeaderTypes, String[] outHeaderNamespaces, SoapUnknownHeader[] unknownHeaders, SoapUnknownHeader[]& unknownHeaderResponses, Boolean oneway, Boolean spsSsoEnabled, Object cookie)
        at Microsoft.BizTalk.WebServices.ServerProxy.ServerProxy.Invoke(String functionName, Object[] parameters, ParamInfo[] inParamInfos, ParamInfo[] outParamInfos, Int32 bodyPartIndex, String bodyType, ArrayList inHeaders, ArrayList inoutHeaders, ArrayList& inoutHeaderResponses, ArrayList& outHeaderResponses, Type[] outHeaderTypes, String[] outHeaderNamespaces, SoapUnknownHeader[] unknownHeaders, SoapUnknownHeader[]& unknownHeaderResponses, Boolean oneway, Boolean spsSsoEnabled)
        at BizTalkApp.BizTalkProject1_BizTalk_Orchestration1_Port_1.Operation_1(String part)

       

      I have gone through the event log, there the following errors has logged:

      1) An attempt to connect to “BizTalkMgmtDb” SQL Server database on server “gi-app02” failed.

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

       2)The Messaging Engine failed to register the adapter for “SOAP” for the receive location “/BizTalkApp_Proxy/BizTalkProject1_BizTalk_Orchestration1_Port_1.asmx”. Please verify that the receive location exists, and that the isolated adapter runs under an account that has access to the BizTalk databases.

       From these errors i can understand that this problem is because of lack of permissions.

      Can u please help me.. in this regard. Thanks in advance.

      Thanks and Regards

      Venkat.

       

    • #18635

      hi,

      hey u are creating a application in one server , i.e is used in another machine. thats why u are getting servername errror.

      first u can set the theese properties.

      R.C on project name goto-properties-deployemt – server – set ur server name.

      bye

      • #18636

        Hi,

        Thank u for ur response…

        I have already given the server name…, without servername we cannot deploy the orchestration to server.

        and i have published as web service. I am not able to invoke the method…

        I hope  the problem is because of lack of permissions at server to invoke the service.

        Please try to solve this issue…

        • #18637

          Hi Venkat,

          This link below should help you.

          http://msdn2.microsoft.com/en-us/library/ms946383.aspx

          Regards,

          Praseedha S

           

          • #18672

            Hi Praseeda,

            Thank u for helping me…

            I gone through the link, i found that the setting are related to web server of Biztalk Server.

            Is it posisble to deploy and publish an orchestration as webservice to Biztalk Server from developer system, just by installing the BizTalk SDK in developer’s system.

            Do we need to install any other components, or any setting to be done. Please let me know…

            Thanks and Regards

            Venkat

             

            • #18675

              Venkat,

              The problem is

              The UserID under which your Biztalk Isolated Host runs doesnot have enough rights on the SQL database.

              Are you using 2 different accounts for the Host

              Biztalk Server Application

              Biztalk Isolated Host

              Check that the account is a member of Biztalk Application User Group,Biztalk Administrator Group on your Biztalk Application Server.

              • #18690

                Hi Nishil,

                For both BizTalk Server Application and BizTalk Isolated Host has same user account.

                Nishil, I will clearly explain my issue:

                 I have installed BizTalk Server 2006 in Win2k3 server. There i had created a biztalk Project that has an orchestration which perform String concatenation. and i deployed it. And Published the same Orchestration as web service. I added the web reference to asp.net application, and invoked that method that accept string and return string. it is working fine.

                After that I have installed Biztalk SDK in Developer system, there I developed the same project with other names for all artifacts in that. i have deployed it and i have published this orchestration as web service, this web service is created in developers system (in wwwroot). I added this web reference to the web application and tried to invoke method, it is throwing an exception stating : System.Web.Services.Protocols.SoapException: Internal SOAP Processing Failure.

                I have gone through the event log, there I found the following errors:

                1) An attempt to connect to “BizTalkMgmtDb” SQL Server database on server “gi-app02” failed.

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

                 2)The Messaging Engine failed to register the adapter for “SOAP” for the receive location “/BizTalkApp_Proxy/BizTalkProject1_BizTalk_Orchestration1_Port_1.asmx”. Please verify that the receive location exists, and that the isolated adapter runs under an account that has access to the BizTalk databases.

                From this I have a doubt that, can we publish the orchestration from developer’s system to access the web service.

                I hope that u can solve this…

                If u want any futher information let me know…

                Please try to solve this issue… Thanks in Advance.

                Thanks and Regards

                Venkat

                • #18696

                  As my experience, the second issue might be caused by the unauthenticated account for your web service, just go to IIS management console, and create a new AppPool within proper identity to your published web service.

                  • #18704

                    The BizTalk SDK I have installed in Windows XP(IIS 5.1). How can i create a new application pool.

                    • #18705

                       There is no Concept of creating new Application Pool in IIS 5.1

                      • #18716

                        Hi Nishil,

                        Then what might be the reason for the errors? I think it is because of lack of permissions.

                      • #18718

                        Ttry giving the User sysadmin rights on the SQL box.

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