In our previous post, we introduced you to the SMTrak Enterprise Dashboard by Signature Consultancy. In this post we will walk through the Requirements.



Following along with the Deployment and Configuration Guide provided by the Vendor, the use of these Enterprise Dashboards has the following requirements.

  1. System Center Service Manager 2012 (RTM or Later)
  2. System Center Service Manager Data Warehouse 2012 (RTM or Later)
  3. Web server with IIS 7.0 (or later)


Supported Web Browsers

  • Internet Explorer v10 and Above
  • Google Chrome v33 and Above
  • Firefox v28 and Above
  • Safari v5.1 and Above


SMTRAK v01 Features and Functions

  • Business analytics
  • Supports Localization
  • Component security level
  • Active Directory integrated
  • ITIL processes visualization and measurement
  • Support ITIL V3 KPIs


Installing Internet Information Services (IIS)

This walk through on installing the Web Server (IIS) server role has been done on Windows Server 2012 R2. If you are using a different Windows Server version other than Windows Server 2012 or R2, your steps may be slightly different.

Start by launching Server Manager from the taskbar.

Launch Server Manager

Click on Manage, and select Add Roles And Features.

Server Manager - Add Roles And Features

On the Before You Begin screen, click Next.

Add Roles And Features Wizard - Before You Begin

On the Installation Type screen, select Role-based or feature-based installation, then click Next.

Add Roles And Features Wizard - Installation Type

On the Server Selection screen, ensure that your web server is listed and selected, then click Next.

Add Roles And Features Wizard - Server Selection

On the Server Roles screen, scroll to the bottom of the Roles list and select Web Server (IIS).

Add Roles And Features Wizard - Server Roles

NOTE: You will be prompted with the following message. Click Add Features to continue. The Web Server (IIS) role should now be selected, then click Next.

Add Roles And Features Wizard - Required Features

On the Features screen, click Next.

Add Roles And Features Wizard - Features

On the Web Server Role (IIS) screen, click Next.

Add Roles And Features Wizard - Web Server Role (IIS)

On the Role Services screen, scroll down to the Security section, and select Windows Authentication, then click Next.

Add Roles And Features Wizard - Role Services

On the Confirmation screen, click Install.

Add Roles And Features Wizard - Confirmation

Once the installation has completed, click Close.

Add Roles And Features Wizard - Results

We now have the Web Server (IIS) role installed. There are still a few remaining things to do before we can install the Enterprise Dashboards.


Internet Information Services (IIS) Configuration

Now that we have IIS installed, we need configure the Application Pool that will be used.

Start by launching the Internet Information Services (IIS) Manager.

Launch IIS Manager

Expand the web server node.

IIS Manager - Expand Server Node

Click on Application Pools.

IIS Manager - Application Pools

In the details pane, select the DefaultAppPool.

IIS Manager - Default App Pool

In the Actions pane, click on Advanced Settings.

IIS Manager - Advanced Settings

In the General section, set Enable 32-Bit Applications to True, then click OK.

IIS Manager - Enable 32Bit Apps

Then close Internet Information Services (IIS) Manager.


Create and Configure SMTRAK Access Account

Now we need to create the account that the Enterprise Dashboards will use.

Start by creating an Active Directory User Account. As an example, the Vendor documentation suggestions using the username of SMTrak.Connect.

NOTE: I will not detail how to create a User Account. However, if you do truly need assistance with how to do this, please contact me and let me know, so that I can add the steps the this article for others.

After the User Account is created, we need to provide it with the appropriate access permissions into the Service Manager databases.

Start by launching SQL Server Management Studio with an account that has Administrative rights on the SQL Server where the SCSM Data Warehouse databases are located.

Launch SQL Server Management Studio

Connect to the SQL Server.

Connect To Server

Expand Security, right-click on Logins, and then select New Login.

SQL Server - New Login

On the General page, under Login Name, type the username of the Service Account we previously created (i.e. DOMAINSMTrak.Connect), or click Search to find the required Service Account.

Verify that Windows Authentication is selected, and change the Default Database to the SCSM Data Warehouse DataMart (i.e. DWDataMart).

SQL Server - Login - New

Next click the User Mapping page, and select the checkbox beside DWDataMart. Then in the ‘Database role membership for: DWDataMart‘ area, select db_DataReader, then click OK.

SQL Server - User Mapping

You will need to repeat these last few steps again, but for the Service Manager database (i.e. ‘ServiceManager‘).

SQL Server - User Mapping (ServiceManager)

We now have the prerequisites installed for the Enterprise Dashboards, and the Service Account has been granted the required permissions. Next we will walk through the installation of the Enterprise Dashboards.


As always, if this post helped you in any way, and you would like to show your appreciation, please rate it, comment on it, and share it. Also, feel free to contact me (via the About Me page) with requests for future articles.