Versions Compared

Version Old Version 8 New Version Current
Changes made by

Peter Ransom

Peter Ransom

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

SkySync creates its database using SQL software. The versions and their uses are explained briefly below and a more in depth explanation can be found in our Best Practices article. It is advised to read the best practices article prior to installing as it contains the hardware and OS requirements for properly using SkySync. This will allow you to ensure that you have optimized your computer and database infrastructure to best suit your needs. 


If you are intending to utilize metadata imports it is advised that servers having SkySync installed on it be set to UTC time. This is because SkySync uses the timezone the SkySync server is set to as the 'starting' timezone, then converts to UTC, which can result in time stamps being shifted to the next day.


It is important to note that the Operating System SkySync is installed needs to be set to a US English Local

SQL CE 

SQL Compact Edition or CE is the default database used when utilizing the standard installation, which is the simplest SkySync installation possible. SQL CE and the standard installation are best used for smaller customers as there are some inherent limitations. SQL CE can only have up to 3 million folder and file objects and is limited to a 4GB database size. Additionally it is more difficult to move a SQL CE database to a new server, where as SQL express and Full SQL are much more portable. Additionally the use of SQL CE will also limit SkySync to running no more then 2 jobs simultaneously. 

...

Note

It is considered a best practice to utilize a SkySync Specific SQL User with Ownership rights to the SkySync Database

10) Leave the Port: field blank to use the default port for SQL. If there is a resulting network issue and SQL server cannot be found, try port 1433 and verify if SQL ports are being blocked via security software/firewalls.

11) Click Validate followed by next to complete the install process

...

12) You will be prompted to enter your license key when first launching SkySync


Windows Defender Warning

It is possible when installing SkySync, that you will receive a message from Windows Defender blocking the install. This message can be manually bypassed by expanding the More Info.

...

Expand
titleExpand for more information

Firewall configuration for SkySync

SkySync requires HTTPS communication to "api.portalarchitects.com" during activation to verify your software license key.  When SkySync starts, it will also communicate with "api.portalarchitects.com" to determine if there has been any published updates to the software. Additionally communication with "windows.net", "microsoftonline.com", and "microsoftonline-p.com" will also be necessary.

Communication with cloud storage platforms vary, but in general requires standard web (port 80) and HTTPS (port 443) to be allowed through the firewall. There may also be specific configurations required for each individual connector. For more information on that the individual connectors support articles should be accessed though two have been provided below for your convenience.

Proxy Server

Note

  • Know your proxy server's address or .pac file location. If you don't have this information, check with your IT or Network Administrators.

    • Proxy Address Example: http://<IP ADDRESS>:<PORT>/

    • Proxy Pac File URL Example: http://<IP ADDRESS>/<PROXY SCRIPT>.pac

    • It is required to use the IP address of the Proxy Server and not the FQDN.  

  • Have administrator access to the machine SkySync is installed on.

  • Remember: SkySync does not support more than one proxy server. If there are two or more proxy servers in a load balanced configuration simply use the IP Address of one of the Proxy Servers. 



Editing the Config Files

We'll be editing two configuration files, opening them in your preferred text editor (as an Administrator):

  1. <INSTALL DRIVE>:\Program Files (x86)\SkySync\skysync.exe.config

  2. <INSTALL DRIVE>:\Program Files (x86)\SkySync\skysyncservice.exe.config

Add one following snippets, replacing your necessary values, inside the <system.net> </system.net> tags,

Using IP Address and Port:


<system.net>
    <defaultProxy enabled = "true" useDefaultCredentials = "true">
    <proxy autoDetect="false" bypassonlocal="true" proxyaddress="http://<IP ADDRESS>:<PORT>" usesystemdefault="false" />
    </defaultProxy>
</system.net>

Using a Proxy Config Script (.pac):


<system.net>
    <defaultProxy useDefaultCredentials="true">
      <proxy usesystemdefault="False" scriptLocation="http://<IP ADDRESS>/<PROXY SCRIPT>.pac" />
    </defaultProxy>
  </system.net>

Save your edits to each file, and restart the SkySync service for them to take effect.

Restarting the SkySync Service 

  1. Open the Windows Services menu. (You can hit the left-hand Windows key and "R" keys together and type in "services.msc" in the run field.)

  2. Right-click on the SkySync service.

  3. Click Restart.

...