none
Cannot open database "BizTalkMgmtDb" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\DefaultAppPool RRS feed

  • Question

  • Hi ,

    I have hosted the WCF  service on IIS to accept the Json request sent by wcf-webhttp send port.

     successfully host the service on IIS.

     


    Wednesday, May 11, 2016 7:33 AM

Answers

  • You get this error because your WCF service is running in an application pool (IIS) which security user is not a member of the BizTalk Isolated Host Users group.

    To solve this issue create an application pool with a security user that is part of the BizTalk Isolated Host Users Group** or check the current application pool and add the user to the BizTalk Isolated Host Users.

    To resolve this issue, configure the application pool identity for the Web service to use a user account that is a member of the BizTalk Isolated Host Users group. To do this follow these steps:

    1) Start Internet Information Services (IIS) Manager.
    2) Expand the computer name that you want to configure, and then expand Web Sites.
    3) Right-click the virtual directory for the Web service, and then click Properties.
    4) On the Home Directory tab, note the application pool for the virtual directory, and then click OK.
    5) Expand Application Pools.
    6) Right-click the application pool that you noted in step 4, and then click Properties.
    7) On the Identity tab, configure the application pool to use a security account that is a member of the BizTalk Isolated Host Users group**, and then click OK.

    Note This account must also be a member of the IIS_WPG group.

    8) Exit Internet Information Services Manager.
    9) Click Start, click Run, type cmd, and then click OK.
    10) At the command prompt, type Iisreset /restart, and then press ENTER.

    ** To check the existing security account that is a member of the BizTalk Isolated Host Users group.

    1) Open Microsoft Management Console by clicking the Start button Picture of the Start button, typing mmc into the search box, and then pressing Enter.‌ Administrator permission required If you're prompted for an administrator password or confirmation, type the password or provide confirmation.

    2) In the left pane of Microsoft Management Console, click Local Users and Groups.

    3) If you don't see Local Users and Groups, it's probably because that snap-in hasn't been added to Microsoft Management Console. Follow these steps to install it:

    4) In Microsoft Management Console, click the File menu, and then click Add/Remove Snap-in.

    5) Click Local Users and Groups, and then click Add.

    6) Click Local computer, click Finish, and then click OK.

    7) Double-click the Groups folder

    8) Double click on BizTalk Isolated Host Users and check for the account configured.


    Rachit Sikroria (Microsoft Azure MVP)



    Wednesday, May 11, 2016 7:51 AM
    Moderator
  • You need to use Custom account.

    

    Don't change the security account of DefaultAppPool.

    Instead create new application pool. Refer: Create an Application Pool (IIS 7) then change the security account that is a member of the BizTalk Isolated Host Users group and use that application pool in your application.


    Rachit Sikroria (Microsoft Azure MVP)

    • Marked as answer by Rajeshwari ML Wednesday, May 11, 2016 9:32 AM
    Wednesday, May 11, 2016 9:08 AM
    Moderator

All replies

  • You get this error because your WCF service is running in an application pool (IIS) which security user is not a member of the BizTalk Isolated Host Users group.

    To solve this issue create an application pool with a security user that is part of the BizTalk Isolated Host Users Group** or check the current application pool and add the user to the BizTalk Isolated Host Users.

    To resolve this issue, configure the application pool identity for the Web service to use a user account that is a member of the BizTalk Isolated Host Users group. To do this follow these steps:

    1) Start Internet Information Services (IIS) Manager.
    2) Expand the computer name that you want to configure, and then expand Web Sites.
    3) Right-click the virtual directory for the Web service, and then click Properties.
    4) On the Home Directory tab, note the application pool for the virtual directory, and then click OK.
    5) Expand Application Pools.
    6) Right-click the application pool that you noted in step 4, and then click Properties.
    7) On the Identity tab, configure the application pool to use a security account that is a member of the BizTalk Isolated Host Users group**, and then click OK.

    Note This account must also be a member of the IIS_WPG group.

    8) Exit Internet Information Services Manager.
    9) Click Start, click Run, type cmd, and then click OK.
    10) At the command prompt, type Iisreset /restart, and then press ENTER.

    ** To check the existing security account that is a member of the BizTalk Isolated Host Users group.

    1) Open Microsoft Management Console by clicking the Start button Picture of the Start button, typing mmc into the search box, and then pressing Enter.‌ Administrator permission required If you're prompted for an administrator password or confirmation, type the password or provide confirmation.

    2) In the left pane of Microsoft Management Console, click Local Users and Groups.

    3) If you don't see Local Users and Groups, it's probably because that snap-in hasn't been added to Microsoft Management Console. Follow these steps to install it:

    4) In Microsoft Management Console, click the File menu, and then click Add/Remove Snap-in.

    5) Click Local Users and Groups, and then click Add.

    6) Click Local computer, click Finish, and then click OK.

    7) Double-click the Groups folder

    8) Double click on BizTalk Isolated Host Users and check for the account configured.


    Rachit Sikroria (Microsoft Azure MVP)



    Wednesday, May 11, 2016 7:51 AM
    Moderator
  • You need to use Custom account.

    

    Don't change the security account of DefaultAppPool.

    Instead create new application pool. Refer: Create an Application Pool (IIS 7) then change the security account that is a member of the BizTalk Isolated Host Users group and use that application pool in your application.


    Rachit Sikroria (Microsoft Azure MVP)

    • Marked as answer by Rajeshwari ML Wednesday, May 11, 2016 9:32 AM
    Wednesday, May 11, 2016 9:08 AM
    Moderator