AVIcode Part 4 – Install SE-Viewer

Before you install SE-Viewer 5.7, or any other version we need IIS as SE-Viewer is an web based application. In Addition to this this is the first step to the installing AVIcode as you have to install the Standalone version before you you can integrate it into Operations Manager 2007 R2.

The install file we need to get started is SEViewer 5_7

image

 

Which in turn will start the install wizard

image

Agree to the Software License Terms

image

Enter your Customer Information

image

Choose the Destination Folder, please note if you use a 64 bit server this will in Program Files (x86) directory.

image

 

image

This can be changed if required, a reason you may want to change is a SEViewer is a web application so you may want to move it to another drive as per your internal security policy.

image

*This is an important step so ensure you enter the correct name for the FQDN DNS Host Name of the server that will be the host of the SE-Viewer.

image

Then we can start the install process

image

If we use a low privilege domain account to run the install we are going to run into a problem in this install process

image

We need to create a Event Log (Intercept Event Log), so ensure that you adjust the UAC control and the account can create an event log, this will be a problem if you have adjusted the GPO settings for Event logs in the Security Settings. 

image

Once the install process is finished we are given the option to open the Configuration Utility, if this is closed and the option had been un-ticked we can still open the Configuration Utility by navigating to to Start – All Programs – AVIcode Intercept Studio – Intercept Configuration – SE-Viewer Configuration Utility. Also note there is a link to the ‘SE-Viewer Configuration’ this is a config file that I will cover in future posts. Also note we are given the option to open the MSSQL Express download page, stick to SQL. The database can get large so you will want to install MSSQL for production a server on it’s own or shared with other SQL DB’s. Never the less for testing yes you can have the SQL and SE-Viewer on the same box.

image 

Click finish to open the Configuration Utility.

image

The data manager gives us the option to choose the type of SQL.

image

I have opted for MS SQL Server. Please note we have to enter some information to complete the process.

image

Here I have entered the name of the SQL server and left the name of the database as the default ‘SEViewer’ name. Also I going to select for ‘Use Windows NT Integrated security’ again being a web application using we need to secure the information. The connection string is encrypted in the SE-Viewer Configuration Utility like this.

“<add key=”connectionString” value=”AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAADP/qSueXBEqZiFgcP2c2jAQAAAACAAAAAAADZgAAqAAAABAAAACSM+jglWFc2YALClvgOWqmAAAAAASAAACgAAAAEAAAAHfYJADb4ofr74LqCJ7kMOdQAAAA1/CD7Np6Xe1+XZYJcb

/svlhOItv6Apyqa3q00QZZvOHr9brEKIqE/veNue2x4LhUPjSzrDDoVCVsSW7eFvutxpYCSGy7q6mxxGL66UsnB40UAAAApI3iW7BAmFR3jIam3mGWB/sy83g=” />”

image

After adding this SQL server name if you are not use an account with ‘sysadmin’ rights you will get this error, I am going to do the next steps in a long winded way but where I can use a low privilege account and be in control of the SQL security.

image

If you have used an account with ‘sysadmin’ right you can use the AVIcode configuration tool.

image

But I want to show you an alternative way to create the SE-Viewer DB, via scripts.

image

For this post I have created a database called SEviewer1 as I already have a SEViewer db in use. So in the normal way create a DB called, in this case SEViewer1 then take your SEViewer.sql script and run it against the SEViewer1 DB. If you are creating a new db without another AVIcode DB then you will not have to pre-create a DB the script will create the SEViewer DB for you.

image

Click Execute

image

This will create the tables and DB structure required for the SEViewer. Now all we need to do is add the security to the DB.

image

The rights required for the SEViewer are db_datareader, db_datawriter you can also enter it as the db_owner.

image

For full SPPI  I have added the computer name of the SEViewer host as db_datareader and the db_datawriter, Once these permissions are set then we can go back to the server hosting the SEViewer  and click the ‘Test’ button this will if all steps where correct show up as ‘Test configuration succeeded’.

 

image

With these steps complete then we can click the ‘Apply’ which will save the config.

image

Navigate to the AVIcode Intercept Studio in ‘All Programs’ to open the SEViewer or apply for the URL http://localhost/seviewer or with a FQDN instead of localhost from another machine.

SNAGHTML2ba8ef4

This will complete the install for the SEViewer.

SNAGHTML2b953c8

 

Next is this series will be the Configuration and the general structure of the SEViwer.

 

Simon Skinner MVP

0 thoughts on “AVIcode Part 4 – Install SE-Viewer

  1. tmartin

    Thanks Simon, these documents are very helpful. Where can I find a list of any prerequistits needed for the SE Viewer? Also, is it ok to install the SE-Viewer on the same server hosting the SCOM database?

    Thanks,

    Tom

Leave a Reply

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