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
Which in turn will start the install wizard
Agree to the Software License Terms
Enter your Customer Information
Choose the Destination Folder, please note if you use a 64 bit server this will in Program Files (x86) directory.
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.
*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.
Then we can start the install process
If we use a low privilege domain account to run the install we are going to run into a problem in this install process
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.
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.
Click finish to open the Configuration Utility.
The data manager gives us the option to choose the type of SQL.
I have opted for MS SQL Server. Please note we have to enter some information to complete the process.
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
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.
If you have used an account with ‘sysadmin’ right you can use the AVIcode configuration tool.
But I want to show you an alternative way to create the SE-Viewer DB, via scripts.
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.
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.
The rights required for the SEViewer are db_datareader, db_datawriter you can also enter it as the db_owner.
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’.
With these steps complete then we can click the ‘Apply’ which will save the config.
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.
This will complete the install for the SEViewer.
Next is this series will be the Configuration and the general structure of the SEViwer.
Simon Skinner MVP