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."
- This topic has 11 replies, 1 voice, and was last updated 9 years, 1 month ago by
community-content.
-
AuthorPosts
-
-
December 18, 2007 at 12:45 AM #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.
-
December 18, 2007 at 1:33 AM #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
-
December 18, 2007 at 2:25 AM #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…
-
December 18, 2007 at 4:37 AM #18637
Hi Venkat,
This link below should help you.
http://msdn2.microsoft.com/en-us/library/ms946383.aspx
Regards,
Praseedha S
-
December 24, 2007 at 12:40 AM #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
-
December 25, 2007 at 6:22 PM #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.
-
December 28, 2007 at 3:19 AM #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
-
December 28, 2007 at 7:39 PM #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.
-
-
-
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.