Close Menu
    Monday, November 18

    How to Install MBAM 2.5 SP1 and integrate with SCCM Configmgr 2012 R2 SP1 – Part 2

    Eswar KonetiBy 3 Mins Read Active Directory 43,536 Views

     

    In part 1 here ,we have created the AD user accounts,security group and register SPN .In part 2 of this multiple series guide ,we will install windows roles/features ,SQL server 2012 SP1 and configure database,permissions etc on our MBAM server (MBAM01).

    MBAM SQL server Requirements:

    image_thumb[3]

    Login to the MBAM01 server using account that has local administrator rights (I use my SCCM installation account in this case CM_srv, if you have created mbam_admin,use that account) ,open Server Manager ,select add roles and features.

    image

    select the following roles and features:

    Roles:
    • Web Server (IIS) Management Tools (Click IIS Management Scripts and Tools.)
    • Web Server Role Services
      • Common HTTP features
        Static Content
        Default Document
      • Application development
        ASP.NET
        .NET Extensibility
        ISAPI Extensions
        ISAPI Filters
      • Security
        Windows Authentication
        Request Filtering
      • Web Service IIS Management Tools
    Features:
    • .NET Framework 4.5 features
      • WCF Activation
        HTTP Activation
        Non-HTTP Activation
      • TCP Activation
      • Windows Process Activation Service:
        Process Model
        .NET Framework Environment
        Configuration APIs

    During the installation,you must provide sources\sxs folder from your server media else .net framework features will fail to install.

    Next prerequisites is ,download and install  ASP.NET MVC 4  from http://www.asp.net/mvc/mvc4

    Reboot the server ,once the server is up, Login to server using CM_SRV Account to install SQL server 2012 SP1 on our MBAM01 server.

    Setup Role

    image

    Feature Selection

    • Database Engine
    • Reporting Services
    • Client Tools Connectivity
    • Management Tools – Complete

    image

    Instance:

    image

    image

    Database locations:

    image

    image

    Next ,we will have to enable named pipes and TCP IP in SQL server configuration manager.

    image

    After this ,Open services.msc (you can type this from RUN command ) and change the SQL server service log on to Local System account from its properties instead of NT service account. Domain account would be recommended but in lab,I go with Local system account.

    image

    Restart the SQL Agent service.

    we will now try to configure the Permissions for the user account who do the installation of MBAM Database and reporting roles on this Database instead of using full administrator account.

    Open the SQL server management Studio

    image

    select the user account (MBAM_hd_apppool):

    image

    image

    click on serve roles

    image

    Also configure the Rights for user Account/Group (MBAM_HD_Reports) who create and publish report to SQL Server Reporting Services:

    • Create Folders
    • Publish Reports

    Run Internet Explorer as administrator and browse http://mbam01/Reports/Pages/Folder.aspx (change the server name)

    Click on Folder settings

    image                  image

    Type MBAM_HD_Reports

    image                      image

    With this,we completed the Prerequisites for windows roles/Features and SQL server database.

    In the next part (part 3),we will look at the prerequisites for the Configuration Manager Integration feature with MBAM.

    Share.

    Related Posts

    15 Comments

      • Eswar Koneti on

        Hi ,
        For SQL server ,you can download MBAM server installation file to install on MBAM server and MBAMclient to install on clients .Note that ,these additional components are to be installed after you install the original installation files.

        Thanks,
        Eswar

        Reply
    3. Alexandre on

      i can't access the report server : it replaces HTTP by https then say certificate is not good , then 404 error .... what's wrong ? i followed all the steps from part 1 to part 2

      Reply
      • Eswar Koneti on

        did you enable https SSRS services ? check the reporting services configuration wizard

        Regards,
        Eswar

        Reply
    4. Harri Hoyla on

      Hi,

      I followed your instruction, but when I run Internet Explorer as administrator and browse http://my_mbam_server/Reports/Pages/Folder.aspx I get error

      Server Error in '/' Application.

      The resource cannot be found.
      Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

      Requested URL: /Reports/Pages/Folder.aspx

      Thanks

      Reply
    5. Mike Virata on

      Hi Eswar, I also have a question about "Also configure the Rights for user Account/Group (MBAM_HD_Reports) who create and publish report to SQL Server Reporting Services:"

      Our SQL Server is on a separate server than our MBAM01 server, so I'm not going to be able to browse to http://mbam01/Reports/Pages/Folder.aspx

      I guess the main question is: since I have two servers MBAM01 and MBAMDB01, do I have to install mbam 2.5 on both servers, then configure them separately?

      Reply
    6. Angel on

      Hi Eswar,
      Great guide but I agree with DPL, there seems to be a gap between creating the SQL login and configuring the Reporting Services. I am using SQL 2012 sp1 and the Reports/Pages/Folder.aspx does no exist
      Once again thanks for putting this together.

      Reply
      • Eswar Koneti on

        Hi Angel,
        I am going to re-look at the guides later this week or so and also am trying to setup new lab so i can correct if there is anything confusion.

        Regards,
        Eswar

        Reply
    7. Paras Kumar Jain on

      Hi Eswar,

      Can you please share the URLs for all the parts for this integration guide here?

      Reply
    9. DPL on

      Hello Eswar,

      nice guide, but i have one question.
      Your words:
      "Also configure the Rights for user Account/Group (MBAM_HD_Reports) who create and publish report to SQL Server Reporting Services:

      Create Folders
      Publish Reports
      "
      Where can i make this settings?
      Can you give me some detailled informations?
      Thanks

      DPL

      Reply

    Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.