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.
- System Center Service Manager 2012 (RTM or Later)
- System Center Service Manager Data Warehouse 2012 (RTM or Later)
- 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.
Click on Manage, and select Add Roles And Features.
On the Before You Begin screen, click Next.
On the Installation Type screen, select Role-based or feature-based installation, then click Next.
On the Server Selection screen, ensure that your web server is listed and selected, then click Next.
On the Server Roles screen, scroll to the bottom of the Roles list and select Web Server (IIS).
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.
On the Features screen, click Next.
On the Web Server Role (IIS) screen, click Next.
On the Role Services screen, scroll down to the Security section, and select Windows Authentication, then click Next.
On the Confirmation screen, click Install.
Once the installation has completed, click Close.
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.
Expand the web server node.
Click on Application Pools.
In the details pane, select the DefaultAppPool.
In the Actions pane, click on Advanced Settings.
In the General section, set Enable 32-Bit Applications to True, then click OK.
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.
Connect to the SQL Server.
Expand Security, right-click on Logins, and then select New Login.
On the General page, under Login Name, type the username of the Service Account we previously created (i.e. DOMAIN\SMTrak.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).
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.
You will need to repeat these last few steps again, but for the Service Manager database (i.e. ‘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.