When you call WebService in BizTalk, you often encounter permission problems and fail to exchange permissions. The following is a specific solution:
Symptom:
The following error message is displayed in the Event Viewer:
User 'nt AUTHORITY \ NETWORK service' Login Failed.
An error occurred while attempting to connect to the "BizTalkMgmtDb" SQL Server database on "JINJZ2003. Error: "unable to open the database you requested" BizTalkMgmtDb ". Logon Failed ."
(An attempt to connect to "BizTalkMgmtDb" SQL Server database on server "Server" failed with error: "Cannot open database requested in login 'biztalkmgmtdb'. Login fails .".)
Solution:
1. check that the application pool corresponding to the web services in IIS is defaappapppool, and change the account corresponding to defaappapppool to "IWAM _ machine name ", in addition, "IWAM _ machine name" is added to the BizTalk Isolated Host Users Group and to the IIS_WPG group.
2. Restart IIS. (run the IISReset command)
3. read and write permissions for the "IWAM _ machine name" account % systemroot % \ Temp folder.
For details, refer to the following URL:
Http://chnking.cnblogs.com/archive/2006/06/10/422639.html