Step-by-step installation of OfficeClip

Revised Feb 11, 2021

Manual installation can be done by just copying files. However, there are prerequisites that needs to be installed.

Fresh Installation

1. Unzip the downloaded file in a folder

2. Make sure you have Sql Server Installed in your organization that can be accessed by the computer where you install OfficeClip.

   If you do not have Sql Server installed follow these steps to install Sql Server to your machine:

   1. Download Microsoft Sql Server 2016 Express and install it on your computer.
   2. Bring up a Windows Command Prompt and run the following command from the directory where you downloaded the file SQLEXPR_x64_ENU /extract. This will extract the file to a subdirectory.
   3. Find the Configuration.ini file supplied with the installation and open it in a text editor. Note the key SAPWD, the sa password of the database server. Feel free to change it to your own, keeping it in quotes.
   4. Copy the configuration.ini file to the folder where Sql Express downloaded file has uncompressed.
   5. Bring up an administrator command prompt and run setup.exe /ConfigurationFile=configuration.ini. Wait till the installation completes (it may take a while).
   6. Optionally you may also want to install the Sql Server Management Studio 2016 which can help in managing the database.
3. Some IIS settings are necessary to run OfficeClip. To set these:
   1. Open a Windows Command Prompt in administrator mode
   2. Run the file dism-command.cmd that is included with your download
4. In IIS, create a new application (or website) and point it to the install\officeclip folder.
5. In the officeclip folder change the rename the following files:
   • db.config.ocbuild to db.config
   • dynamic.config.ocbuild to dynamic.config
   • web.config.ocbuild to web.config
6. Finally bring up a browser window and visit http://localhost/officeclip (Note: This url may be different based on where OfficeClip is configured in IIS)

To Upgrade

Copy the content of the install\officeclip to the same folder in the OfficeClip application, restart IIS and run OfficeClip again.

Issues with Windows 2012 R2 Server

In some cases .NetFramework 2.0 is not installed in Windows 2012 R2 Server machines by default. To install it mount the OS DVD (or iso file) and run the following command in command prompt in Administrator mode. dism.exe /online /enable-feature /featurename:NetFX3 /Source:D:\sources\sxs /all