Step 3: Set Up the Client's Database & Applications

<< 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

2. Create client's AyaNova program folder for Data Portal and Generator use for this client and apply their license

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:

 

DPInstall5

 

 

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.