<< Click to Display Table of Contents >> Navigation: Multiple Database Installation & Configuration on Single Computer > Step 3: Set Up the Client's Database & Applications |
The steps below are for setting up multiple client's hosting of AyaNova using SQL Sever 2005 or higher. Of course, some instructions may be different if using SQL Express.
NOTE: The information below is based on the assumption that you are already familiar with steps for configuring IIS, SQL Server, Data Portal, Generator, MBI and WBI as per the "normal" local area network setup in their respective Help files. If you have not yet reviewed them, and become familiar, do so before proceeding.
NOTE: The information below is based on the assumption that you have already performed the AyaNova Database Setup.
NOTE: You must be using IIS 6 or higher to be able to perform the steps below.
1. Create client's AyaNova SQL Express database
3. Create Data Portal site for use for this client
4. Create Generator service for use for this client
5. Create client's MBI site for use for this client
6. Create client's WBI site for use for this client
7. Create client's RI site for use for this client
1. Create client's AyaNova SQL Express database:
1. Create a folder specifically for each client's AyaNova SQL database files - i.e. C:\Data\Customer1, C:\Data\Customer2, etc
2. Via SQL Server Management Studio, restore the trial AyaNova backed up database to C:\Data\Customer1 and name the database with the client's company name i.e. AyaNova_Customer1
3. This will create a trial AyaNova database file AyaNova_Customer1.mdf and log file AyaNova_Customer1_LOG.LDF to C:\Data\Customer1
2. Create client's AyaNova program folder for Data Portal and Generator use for this client and apply their license:
4. Create a folder specifically for this client's AyaNova program files - i.e. C:\ClientApps\Customer1\AyaNova
5. Copy all files from C:\Program Files\Ground Zero Tech-Works Inc\AyaNova except the config.txt file and paste into C:\ClientApps\Customer1\AyaNova
6. Copy the EXAMPLE_SQLSERVERconfig.txt from the C:\ClientApps\Customer1\AyaNova\Examples folder and paste into C:\ClientApps\Customer1\AyaNova
7. Rename this file to config.txt
8. Edit this config.txt using NotePad as per the AyaNova SQL Server configuration steps in the AyaNova Help file
•Do not use any other program but NotePad to edit this file
•Edit data source=xxxx to your actual SQL Server server's name
•Edit your sa password
•Save this file and exit
9. Run AyaNova.exe from this folder
10. Confirm you are connecting to the correct database by viewing the connection string showing in Help -> About AyaNova
11. Once confirmed you are connecting to the correct database, apply this client's AyaNova and optional add-on's keycode as per its instructions before its Install By date to license this client's database. See also License Requirements
3. Create Data Portal site for use for this client:
12. In IIS, create a new web site named based on the client's company name i.e. AyaNovaDP_Customer1
13. Set a specific port for this DP (different from ports set for all other IIS sites)
14. Point its path to this client's AyaNova program folder i.e. C:\ClientApps\Customer1\AyaNova
15. Allow Anonymous access to web site remains check-marked
16. Check-mark rights for Read, Run and Execute
17. Stop and Start this site AyaNovaDP_Customer1
18. 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 this site
http://localhost:XXXX/DataPortal.rem?wsdl or use your local server's private ip address instead of localhost
You do want to see similar to below:
19. Refer now to Client's Data Portal Connection Setup in this Help file
4. Create Generator service for use for this client:
20. Open a command prompt on this computer
21. Type in the command
sc create AyaNovaGeneratorCustomer1 binpath= "C:\ClientApps\Customer1\AyaNova\Generator.exe"
22. The command prompt will return if applied properly. If it doesn't, than recheck your steps.
[SC] CreateService Success
23. Refresh the list of Services
24. You will now see AyaNovaGeneratorCustomer1 listed
25. Edit its properties so that it starts automatically, as well as start it.
26. Confirm via Event Log that this service started successfully, and connected successfully same as per the original Generator setup steps.
5. Create client's MBI site for use for this client:
27. Create a folder specifically for this client's MBI site files - i.e. C:\ClientApps\Customer1\AyaNovaMBI
28. Copy all files and folders from the original installation C:\Program Files\Ground Zero Tech-Works Inc\AyaNovaMBI into this folder, except for the config.txt in the bin folder
29. From the C:\ClientApps\Customer1\ folder, copy the config.txt into C:\ClientApps\Customer1\AyaNovaMBI\bin - this is the config.txt that you specifically edited to point to this customers AyaNova database
30. In IIS Manager, create a new web site pointing to the C:\ClientApps\Customer1\AyaNovaMBI folder
•Enter a unique port #
•Allow anonymous access to the web site
•The web site access permissions must be at minimum Read, Run scripts and Execute
•Make sure the correct .NET is selected 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)
•You may have to add the default.aspx Document if not already there
31. Stop and Start this new web site that you just created
32. As the site is not under Default Web Site, note of course that the internal URL for testing MBI would be http://xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address and XXXX is the port number
NOTE: you will want to set these additional rights settings 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 bin folder of the AyaNovaMBI site for this client
3. Select Properties of this config.txt file via the IIS Manager
4. Un-check the Read right, and save.
6. Create client's WBI site for use for this client:
33. Create a folder specifically for this client's WBI site files - i.e. C:\ClientApps\Customer1\AyaNovaWBI
34. Copy all files and folders from the original installation C:\Program Files\Ground Zero Tech-Works Inc\AyaNovaWBI into this folder, except for the config.txt in the bin folder
35. From the C:\ClientApps\Customer1\ folder, copy the config.txt into C:\ClientApps\Customer1\AyaNovaWBI\bin - this is the config.txt that you specifically edited to point to this customers AyaNova database
36. In IIS Manager, create a new web site pointing to the C:\ClientApps\Customer1\AyaNovaWBI folder
•Enter a unique port #
•Allow anonymous access to the web site
•The web site access permissions must be at minimum Read, Run scripts and Execute
•Make sure the correct .NET is selected 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)
•You may have to add the default.aspx Document if not already there
37. Stop and Start this new web site that you just created
38. As the site is not under Default Web Site, note of course that the internal URL for testing WBI would be http://xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address and XXXX is the port number
NOTE: you will want to set these additional rights settings 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 bin folder of the AyaNovaWBI site for this client
3. Select Properties of this config.txt file via the IIS Manager
4. Un-check the Read right, and save.
7. Create client's RI site for use for this client
39. Create a folder specifically for this client's RI site files - i.e. C:\ClientApps\Customer1\AyaNovaRI
40. Copy all files and folders from the original installation C:\Program Files\Ground Zero Tech-Works Inc\AyaNovaRI into this folder, except for the config.txt in the bin folder
41. From the C:\ClientApps\Customer1\ folder, copy the config.txt into C:\ClientApps\Customer1\AyaNovaRI\bin - this is the config.txt that you specifically edited to point to this customers AyaNova database
42. In IIS Manager, create a new web site pointing to the C:\ClientApps\Customer1\AyaNovaRI folder
•Enter a unique port #
•Allow anonymous access to the web site
•The web site access permissions must be at minimum Read, Run scripts and Execute
•Make sure the correct .NET pool is selected 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)
43. Stop and Start this new web site that you just created
44. As the site is not under Default Web Site, note of course that the internal URL for testing RI would be http://xxx.xxx.xxx.xxx:XXXX where xxx.xxx.xxx.xxx is the server's internal IP address and XXXX is the port number
NOTE: you will want to set these additional rights settings 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 bin folder of the AyaNovaRI site for this client
3. Select Properties of this config.txt file via the IIS Manager
4. Un-check the Read right, and save.
Refer to the appropriate Help file for detailed information for each of the above applications if needed.