It is always recommend to read through all instructions first before proceeding.
Requirements before proceeding:
| • | The network Firebird server installation or SQL Express or SQL Server must be performed before following the Data Portal configuration steps. |
| • | Confirm that you can connect to the networked AyaNova database from a local networked connected computer |
| • | IIS server installed before steps below. |
| • | Your router/firewall has a static external IP address (you can not use a dynamic IP address as that means it constantly changes, and therefore your remote users won't be able to connect as won't know what IP address to use) |
| • | Your router/firewall configured for port forwarding for the IIS computer. |
| • | High-speed internet / network connection between remote user and network where database resides |
There are two distinctive sections of the Data Portal setup
| 1. | First the installation and configuration of the Data Portal itself |
| 2. | And second the configuration of the remote to connect to the Data Portal |
1. Data Portal installation and configuration
1. Confirm what the external static IP address is for your router/firewall
2. Confirm that your router/firewall is configured to forward port to the database server where the Data Portal will be set up
| • | Refer to your firewall documentation for setting up forwarding as every firewall is different and we would not be able to put here examples of every type available. |
| • | in our example screenshot - the database server’s internal IP address is 192.168.1.100 and the forwarding port we have set is 6969 |
3. Confirm that IIS is configured for this port
| • | In our example, we have the TCP Port as 6969 because as the above example, we have want to have remote users forwarded to port 6969 onto the server. |
4. Run the AyaNovaSetup.exe installation again on this same server where you have already configured network AyaNova use and confirmed.
5. Select to Install AyaNova Data Portal (requires IIS)
6. Proceed with the installation.
7. During the installation it will notify you that it created the virtual directory AyaNovaDP from C:\Program Files\Ground Zero Tech-Works Inc\AyaNova
8. If during the installation, it sees that there already is a config.txt file and do you want to overwrite it - click NO
| • | You do NOT want to overwrite your config.txt file because it is already configured to point to your networked AyaNova database |
9. After installation has completed, open the IIS Manager and confirm that AyaNovaDP is present
10. There is no editing of the web.config file because AyaNovaDP uses the same config.txt that the AyaNova program uses to connect to the networked database.
11. Confirm that AyaNovaDP web site is using Microsoft.NET Framework 2 (or higher)
12. Stop and Start the default web site
13. Test that connection via the data portal by opening a web browser on this server where you have just performed the steps above, and typing in the URL where XXXX is the port number of your Default Web Site
http://localhost:XXXX/AyaNovaDP/DataPortal.rem?wsdl
| • | You do want to see similar to below: |
14. Data Portal is now installed and you are now ready for the remote computer configuration
15. The following is additional rights settings you may want to set so that external users can not view the contents of the config.txt file
1. Open the IIS Manager or Computer Management
2. Right-click on config.txt that is within the folder of the AyaNovaDP site
3. Select Properties
4. Un-check the Read right, and save.
NOTE: If on your server you can not use a web site off of Default Web Site as per the steps above, you can manually create a new virtual web site pointing to the AyaNova folder.
| 1. | Install as above steps. |
| 2. | In IIS Manager, delete the installed web site AyaNovaDP under Default Web Site (this should not remove the installed files) |
| 3. | In IIS Manager, create a new web site pointing to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder with its own port # |
| • | Allow anonymous access to the web site |
| • | The web site access permissions must be at minimum Read, Run scripts and Execute |
| • | Make sure .NET 2 is selected in the ASP.NET tab for this new site |
| • | You may or may not have to set the IP Address property of your new website to the computer's actual internal ip address instead of (All Unassigned) |
| 4. | Stop and Start this new web site that you just created |
| 5. | As the site is not under Default Web Site, note of course that the URL for step #13 above would be http://localhost:xxxx/DataPortal.rem?wsdl where xxxx is the port number you gave when you manually created the site. (or use xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address) |
2. Remote computer configuration
A. Test connection to AyaNova database via local area network connection computer and internal IP address and port
a. Move to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova/examples folder on this server
b. Rename the EXAMPLE_DATAPORTALconfig.txt file to config.txt
c. Edit this new config.txt using NotePad
| • | Do not use any other program but NotePad to edit this file |
| • | Edit the example IP Address with the server's internal IP address and the port number for Data Portal |
| • | For example, if your server's internal IP address is 192.168.1.100, and the port your Default web site is using is 6969 (which is also the same port set in the Default Web Site), that config.txt would look like |
<ConnectionType>DataPortal</ConnectionType>
<PortalServer>http://192.168.1.100:6969/AyaNovaDP/DataPortal.rem</PortalServer>
| • | Save the file |
d. On an existing local area networked computer that has AyaNova already installed and connecting to the network AyaNova database, do the following:
| • | Make sure that local area networked computer is exited out of the AyaNova program |
| • | Rename their config.txt on their C:\Program Files\Ground Zero Tech-Works Inc\AyaNova to config.txtnetwork |
| • | Paste into their AyaNova folder the above edited config.txt file from the server |
| • | Do not test the Data Portal connection from the server itself as this will not work by design. The config.txt file in the C:\Program Files\Ground Zero Tech-Works\Ayanova folder is shared by the Data Portal interface as well as other AyaNova programs such as QBI, PTI, import utilities running on the server. The Data Portal connection via config.txt can be used from any other machine, except the server where the dataportal is installed to. |
| • | Run AyaNova on this local area networked computer and confirm can log into AyaNova successfully, and am connecting by data portal by checking Help -> About AyaNova |
e. If not successful:
| • | Recheck your steps and reconfirm the details |
f. Once successful - exit out of AyaNova on that local area networked computer
g. Now edit that config.txt again, this time you will be testing to ensure connection via the external router/firewall but still from within your local area network
B. Test connection to AyaNova database via local area network connection computer and external IP address and port
a. Edit the config.txt on that local area networked computer again using NotePad
b. Edit the example IP Address with the router's external IP address and the port number (that you configured in step 1 for your router/firewall that is the same in the Default Web Site)
| • | For example, if your router's public IP address is 222.333.111.6, and the port your Default web site is using is 6969 (which is also the same port you configured in the router/firewall), that config.txt would look like |
c. Save the file
d. Run AyaNova on this local area networked computer and confirm can log into AyaNova successfully, and am connecting by data portal by checking Help -> About AyaNova
e. If not successful:
| • | Recheck your steps and reconfirm the details |
f. Once successful - exit out of AyaNova on that local area networked computer and restore the config.txt back to the regular config.txt for local area network access
| • | delete the config.txt |
| • | rename the config.txtnetwork back to config.txt |
| • | confirm able to run AyaNova and connect successfully. |
g. Once successful, continue to the next step
C. Provide configuration for remote computer now that internal local area connection is confirmed working
a. Move to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova/examples folder on this Data Portal server
b. Edit that config.txt using NotePad again
| • | Do not use any other program but NotePad to edit this file |
| • | Edit the example IP Address with the router's external IP address and the port number (that you configured in step 1 for your router/firewall that is the same in the Default Web Site and also performed in the step B.b above) |
| • | For example, if your router's public IP address is 222.333.111.6, and the port your Default web site is using is 6969 (which is also the same port you configured in the router/firewall and for AyaNovaDP), that config.txt would look like |
<ConnectionType>DataPortal</ConnectionType>
<PortalServer>http://222.333.111.6:6969/AyaNovaDP/DataPortal.rem</PortalServer>
| • | Save the file |
d. Make that config.txt file accessible to your remote user - either give that config.txt file to your remote user by email or put it on a disk, etc) and have them save to a folder on their local hard drive
| • | For example, have them save it to C:\Temp |
e. Have your remote user download the AyaNovaSetup.exe installation file and save to their local hard drive into that same folder
| • | So now that folder has both the AyaNovaSetup.exe file and the special config.txt file. |
f. Have that remote user run the AyaNovaSetup.exe file from that folder location that also has the edited config.txt in that same shared location.
| • | Make sure the remote user selects AyaNova - Networked computer installation |
The AyaNovaSetup.exe will "see" that config.txt file and automatically copy it to that computer's AyaNova program directory so no additional configuration is needed on that user's station.
The install will only install the AyaNova program files it has been told to install, will copy that config.txt file to the remote user's local hard drive workstations AyaNova program folder and will not install a trial database.
The AyaNova installation will place a desktop icon for AyaNova on the desktop as well as in the start menu.
If an issue with the Data Portal, you first need to confirm at what point an issue first occurs. This means the first thing you do is re-check every step.
If continue to experience an issue, check the AyaNova Support Forum for a solution similar to your issue
If continue to experience an issue, either post the following on the AyaNova Support Forum or send via direct email to AyaNova support:
| • | Identify the issue you are having and what step it relates to - provide details of what exactly was done, possibly screenshots etc of the issue |
| • | Confirm each step taken up to the point of the issue providing details on each of those steps |
| • | If issue in remote computer configuration, identify step at and config.txt with that step along with confirmation of testing steps done previously to that point |