A separate Application Server is required as a prerequisite to setting up the VIDIZMO application for On-Premise/Private Cloud deployment. This Server will be used to install the VIDIZMO Application and it will have the SQL Reporting Services installed on it.
This article will cover the following sections:
- Application Server Requirements
- Installation Prerequisites
- Installation on Application Server
- Installing SQL Reporting Services
For On-Premise/Private Cloud deployment of VIDIZMO, the following necessary installations should also be performed:
1. Setting up an SQL Database Server: Click here on How To Install Microsoft SQL For VIDIZMO Application.
2. Installing the VIDIZMO Application. Click here to learn more on How To Install VIDIZMO On-Premise/Private Cloud.
1. Server Requirements
Following are the minimum requirements for installing an SQL Server:
- Windows Server 2012 R2/2016 Standard Edition VM/Physical Server with a minimum of 8GB RAM, 4 Core CPU, 128 GB HDD with 150 Mbps Throughput.
- IIS 8.5 or greater
- Microsoft Office 2013/2016 Professional
- Microsoft .Net Framework 4.5.2
- Microsoft Windows Management Framework 5.1
SQL Reporting Services
2. Installation Prerequisites
Prerequisites for installation and configuration of VIDIZMO in an On-Premise/Private Cloud environment are:
- MS Office 2013/2016 Professional: This is required for conversion and playback of Documents type media and should be installed on VIDIZMO Application Server.
- Domain Name for your Media Portal: This is the domain name users will type in to access your media portal. The domain name should map to a public (or private in case external access is not intended) IP of VIDIZMO Application Server.
- SSL Certificate for Selected Domain Name (Optional): In case use of HTTPS is required for secure communication between users’ browser and VIDIZMO application.
- SMTP Service Credentials: For VIDIZMO Application to send out email notifications to administrators and users triggered in different scenarios such as registration requests, content upload, content sharing etc. This can be a service account (recommended) or user account that can be obtained from your corporate mail server administrator. Alternatively, it can also be setup with a 3rd party SMTP service such as sendgrid.com, Amazon SES etc.
Installation of Prerequisites
Install “Internet Information Services (IIS)”
When the Web Server (UI) role is chosen for the first time while select "Add Roles and Features" in Server Manager, the basic components, and services required for IIS are automatically selected. The following steps will assist in installing Internet Information Services (IIS) on a running server.
1. Open the "Server Manager" by clicking on the icon on the taskbar.
2. Click on "Add new roles and features" from the Service Manager's Dashboard.
3. You will be navigated to the "Add Roles and Features Wizard." You have to make sure that the following requirements are met before moving on to the next step:
i. The Administrator account has a strong password.
ii. The network settings, such as IP addresses, are configured.
iii The most current security updates from Windows® Update are installed.
Click on the "Next" Button to continue.
4. The next screen is "Installation Type" from where you will select "Role-based or feature-based installation." This option will configure a single server by adding roles, role services, and features. Click "Next."
5. On the "Server Selection" screen, you have to choose an option (a server or a virtual hard disk) where you would want to install roles and features. In this instance, we are selecting "Select a server from the server pool" option and then select your target server from the Server Pool. The roles and features will be installed there. Click "Next."
6. On the "Server Roles" screen, scroll down to select "Web Server (IIS)."
7. A pop-up window will open which will ask for the confirmation of adding features required for Web Server (IIS). Click on "Add Features" and make sure that the "Include management tools (if applicable)" checkbox is selected.
8. Click "Next" after selecting and configuring the features for Web Server (IIS).
9. You will move on to "Features" screen from where you do not need to select any features manually. Web Server (IIS) setup will automatically select the features it requires. Therefore, click "Next" to proceed further.
10. On the "Web Server Role (IIS)" screen, go through the information and then click "Next."
11. The next screen is the "Role Services" screen, which is a part of Web Server Role (IIS). Some Role Services are selected by Default.
Select the following Role Services in addition and then click "Next."
- Windows Authentication
- .NET Extensibility 3.5(Just click ADD Features on new window, while selecting this feature)
- .NET Extensibility 4.5
- ASP.NET 3.5(Just click ADD Features on new window, while selecting this feature)
- ASP.NET 4.5
- ISAPI Extensions
- ISAPI Filters
- FTP Service
- IIS Management Console
- IIS 6 Management Compatibility
- IIS 6 Metabase Compatibility
- IIS 6 Management Console
- IIS 6 Scripting Tools (Just click ADD Features on new window, while selecting this feature)
- IIS 6 WMI Compatibility
Note: When you install IIS for the first time by selecting Web Server (IIS), you will at least get the minimum set of role services. You can see at this point that those default services are preselected on the Server Roles page.
12. On "Confirmation" screen, review all the roles, role services, and features etc. you selected in this wizard. Click "Install" to begin the installation process.
13. The installation process will begin. It will take a few minutes to complete.
14. The installation of Web Server (IIS) on your system is completed once you see "Installation succeeded" notification (highlighted below). Click on the "Close" button.
4. Install “SQL Reporting Services”
When we configure Reporting Services, a Database is already created by the name of Report Server and used for reports generated in VIDIZMO. If we use the SQL Server for Reporting Services, we will need to install the Web Server Role on the SQL Server also, which is not required since we just want to run the database on the SQL Server.
1. In Application Server, either install SQL 2012/2014/2016 with the following features:
- Instance Features
Reporting Services – Native
After successful installation, type Reporting Services Configuration Manager in Windows Search and open it:
3. The "Reporting Services Configuration Manager" will require connection to the server as soon as it opens. Enter the Server Name and Report Server Instance in respective fields and click on "Connect":
4. In the Navigation Pane on the Left click on “Database.”
5. In the Database, Window Click on “Change Database.” A new Window “Report Server Database Configuration Wizard” will appear.
6. Select “Create a new report server database,” make sure that there is No ReportServer Database created in your DB Server. Click “Next” to continue.
Server Name: Enter the Name of the “DB Server”
Authentication Type: Select “SQL Server Account” from drop-down
Test Connection: Connectivity established if connection successful.
Username: Provide the “sysadmin” username
Password: Provide Password for above username. Click “Next”
8. In next step, it will show you the details of Database. Make sure the name of Database is “ReportServer”, Click “Next”.
9. Next, it will ask for credentials. Select “SQL Server Credentials” from the dropdown. And provide the same Sysadmin "sa" username and password provided earlier and then click “Next”.
In next step, it will show you the Summary and configure the Report Server Database. After completion click on the “Finish” button.
10. From the Navigation Pane select “Web Service URL” and Click on “Apply” at the bottom.
11. On "Web Service URL" click on the highlighted URL shown below:
12. This will navigate you to an open web page. If you see no errors, then it means that the "Reporting Services" are configured correctly. Close the browser:
13. Do the same for “Web Portal URL” and click on the “Apply” button. The Apply button applies the configuration settings.
14. On “Web Portal URL click on the highlighted URL shown below:
15. Another web page will open.
If you see no errors, then it means that "Reporting Manager" is configured correctly. Close the browser to complete the installation and verification of SQL Reporting Services.