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

 

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.

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

  1. 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
  2. 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
    1. 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
  3. 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