Remote users can access the same shared live database using the AyaNova Data Portal
Users get the full benefits of accessing via the AyaNova v3 program interface.
This is suggested instead of use with terminal services.
Requirements:
High-speed internet / network connection between remote user and network where database resides
Embedded Firebird server default installation can not be used along with a Data Portal
The network Firebird server installation or SQL server must be performed prior to the following steps.
IIS server installed prior to steps below.
Firewall configured for port forwarding for the IIS computer.
Example installation & configuration of Data Portal
| 1. | Firewall is configured to forward port to the database server where the Data Portal will be set up |
| a. | Refer to your firewall documentation for setting up forwarding |
| b. | Our example, the database server’s internal IP address is 192.168.1.100 |
| c. | In the firewall configuration, we configured port 6969 for forwarding |
| 2. | IIS is configured for same port that you have also configured for forwarding above. |
| 3. | Download the AyaNova Data Portal installation file from the AyaNova web site. |
| 4. | Extract the AyaNovaDP installation files to a temporary folder and perform the AyaNovaDP installation by running the Setup.exe |
| 5. | After installation has completed, open Computer Management and confirm that AyaNovaDP is present |
| 6. | Edit the web.config file of AyaNovaDP to reflect the settings as per the AyaNova.exe.config file edited during the network installation and configuration. |
| 7. | Do NOT edit any of the settings below this in the web.config file. If for some reason you do, make sure to document what you have changed so you can revert to the defaults if experiencing any issues. |
| 8. | Stop and Start the IIS |
| 9. | Test that connection via the data portal by opening a web browser on this computer and typing in http://localhost:XXXX/AyaNovaDP/DataPortal.rem?wsdl where XXXX is the port number |
| 10. | You should see a web image like so |
Example configuration for the remote computer once Data Portal configured
Remote computer requires high speed Internet connection between itself and database location
| 1. | Uninstall any previous AyaNova v3 installation of files on this remote computer |
| a. | Use of previous program files or previous beta AyaNova database will result in corruption |
| 2. | Install Microsoft .NET Framework 2 and applicable service patches. |
| b. | Check if already installed by opening Control Panel -> Add/remove Programs -> scroll to determine if Microsoft .NET Framework 2 is installed |
| c. | Refer to the Microsoft downloads web page http://www.microsoft.com/downloads if you do not already have this installed. If not displayed under Popular Downloads, enter Microsoft .NET Framework 2 in the Search for a Download section |
| d. | Be sure computer has been rebooted if just installed |
| 3. | Copy the folder and all files C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 to local hard-drive of this remote computer |
| a. | Do NOT run the AyaNova executable from a networked location – it must reside with all files on that remote computer's local hard drive |
| 4. | Rename the existing AyaNova.exe.config file to AyaNova.exe.config.local |
| 5. | Rename the AyaNova.exe.config.DATAPORTAL.VERSION to AyaNova.exe.config |
| 6. | Edit the AyaNova.exe.config file with your firewall IP address and forwarding port number |
| 7. | Save and close the file |
| 8. | Create a desktop shortcut to the AyaNova.exe |
| e. | Right-click on the desktop |
| f. | Select New -> Shortcut |
| g. | Browse to the location of the AyaNova 3 folder and files that you copied to this remote computer's local hard drive |
| h. | Select AyaNova.exe |
| i. | Select OK |
| j. | Select Next |
| k. | Type a name “AyaNova v3” |
| l. | Select Finish |
| 9. | Run AyaNova by double-clicking the AyaNova desktop icon and confirm successful login. |
| 10. | If you do not connect, ensure that you have a connection to the firewall itself |
| a. | Ping the firewall |
| b. | Confirm your actual network / internet connection |
| 11. | Open a web browser and type in the http://xxx.xxx.xxx.xxx:XXXX/AyaNovaDP/DataPortal.rem?wsdl where xxx.xxx.xxx.xxx:XXXX is the IP address of the firewall and forwarding port number to the IIS computer that is running AyaNovaDP |