Updating if networked SQL Express AyaNova

<< Click to Display Table of Contents >>

Navigation:  Updating from an older AyaNova version >

Updating if networked SQL Express AyaNova

Compare the AyaNova version listed on our Download web page with your version listed in Help -> About AyaNova to determine if your version needs updating.

 

NOTE: the version stated in the screenshot below may not be the actual latest version. Refer always to the latest available via https://www.ayanova.com/download.htm

HelpAbout

NOTE: the version stated in the screenshot above may not be the latest version. Refer always to the latest available via https://www.ayanova.com/download.htm

 

Steps to update an AyaNova network SQL Express configuration (version 4.2, 5.1, 6.6 or 7.x):

 

1. Requirements before proceeding

2. Create backup of your SQL Express AyaNova database

3. AyaNova 7 installation

4. Apply your AyaNova subscription license(s) Activation Key

5. Update your database

6. Prep and install AyaNova 7 on networked computers

7. Install and configure AyaNova 7 optional programs on the server

8. Confirm your backup and restore procedures for SQL

 

 

 

1. Confirm these four requirements BEFORE proceeding:

 

Do not proceed until you have confirmed yes to each of these requirements:

 

1) CONFIRM Do you know your AyaNova Administrator login name and password?

 

i.If you don't know it, it could still be the default login name manager and password letmein - try it and confirm!

ii.If you do not know your AyaNova Administrator username and password, log in as another user that does have rights to the Administration Users grid, and edit the AyaNova Administrator username and password. It would be suggested to write down that username and password and keep in a safe place for future use too.

iii.You MUST log in where indicated in the steps as the AyaNova Administrator, not another user, so that your database schema can be successfully updated.

 

2) CONFIRM Do you have an active support & updates subscription as shown in your AyaNova database?

 

i.Log into your AyaNova, select Help -> About

ii.View your database's "Support and updates until:" date

1.If your version is lower than 7.4, your About will not have a "Support and updates until:",  you will need to purchase subscription(s) for your database to be able to complete the upgrade.

2.If your  "Support and updates until:" date has passed, your subscription(s) have expired, and you will need to purchase subscriptions for your database  to be able to complete the upgrade.

3.If your  "Support and updates until:" date is a future date, that means you do have an active support and updates subscription, Proceed to the next requirement.

 

3) CONFIRM Does your version of AyaNova program files require updating?

 

a)Confirm your version of AyaNova to determine if requires updating:

a.Refer to your Help -> About to view your version

b.Compare your version in your Help -> About to that of the latest version at https://www.ayanova.com/download.htm

c.Any questions, do include all text from your Help - About AyaNova when contacting support.

 

1.If your AyaNova version is already at the latest version shown at https://www.ayanova.com/download.htm :

a.If you have received a new subscription Activation Key via email, just apply it as per its instructions for a database that is already at the latest version.

b.That's it, you are done!

2.If your AyaNova is version 7.4 or newer BUT not the latest version AND your Support and Updates until: is currently valid by showing a future date:

a.As your subscription(s) are active and not expired, your database is eligible to upgrade as well as receive support.

b.Go ahead and follow the steps below to update your AyaNova.

i.NOTE: Skip the steps below related to applying a Subscription Activation Key as your database already has its current Subscription Key applied

3.If your AyaNova is version 7.4 or newer  BUT not than the latest version,  AND your Support and Updates until: has expired by showing a date that has past:

a.As your subscription(s) have expired, you will need to purchase new subscription(s) before proceeding.

b.When received your Subscription Activation Key, perform the steps below.

4.If  your AyaNova is between version 7.3 - 3.x:

a.Purchase your resource and optional add-on subscriptions

b.When received your Subscription Activation Key, perform the steps below.

5.If your AyaNova version is 6 or older:

a.Purchase your resource and optional add-on subscriptions.

b.Confirm your report templates (that you normally use) run successfully with the latest version of AyaNova.

i.Download and install the latest AyaNova onto a separate stand-alone computer with a sample database.

ii.Export your custom report templates to files.

iii.Import into your testing setup of the latest version of AyaNova.

iv.Confirm your custom report templates load successfully with your testing setup of the latest version of AyaNova

v.If you encounter errors attempting to load your custom report template, refer to http://forum.ayanova.com/t/report-error-issue-for-some-ayanova-7-users/1987 and http://forum.ayanova.com/t/report-error-issue-for-some-ayanova-6-users/1832 to confirm the errors indicate that the report template must be replaced.

vi.Obtain copies of the latest sample report templates via https://www.ayanova.com/reporting.htm#replacement and customize as needed.

c.Proceed with the upgrade

d.Once the upgrade is complete, you would remove the non-working report templates and import your new customized report templates into your live upgraded AyaNova

 

 

If have not previously purchased a subscription:

Subscriptions are required to receive support and to be able to apply upgrades to the latest version.

Refer to answers to common questions about licensing, pricing, purchasing on http://www.ayanova.com/purchase.htm

and/or contact us with all text from your present Help - About AyaNova

 

If you had previously purchased subscription(s) but allowed your subscription to expire without paying the renewal(s):

Only active (non-expired) subscriptions are eligible for support and upgrades.

Only active (non-expired) subscriptions are eligible to renew at the discounted renewal subscription price.

You will need to purchase your subscriptions again, at the full subscription price.

 

If you have an active subscription with an upcoming expiration date for support and updates:

Your registered email address will receive a reminder from our payment processing partner that your renewal subscription will automatically be processed if your payment method is valid.

NOTE: your renewal at the discounted renewal price can only occur if your payment method provided (such as your credit card's expiry date) is valid.

Follow the email instructions to check your payment method is valid before the purchase date to ensure no loss of access to purchase at the discounted renewal price.

If your existing payment method with our payment processing partner is valid, your renewal subscription Key will be emailed following the process of the renewal charges (Monday to Friday).

If any issue or did not receive, contact us immediately with your details.

 

 

4) CONFIRM Is your existing SQL version 2005 or higher?

 

a)AyaNova 7 requires SQL 2005 or higher. Microsoft no longer supports SQL 2000 or lower

b)Additionally, you may want to look into where you have optimized your SQL yet

c)Additionally, you may want to look into using using SQL 2012 or newer

 

 

 

2. Create backup of your SQL Server AyaNova database and edited files

 

a. Make sure all users and all AyaNova related programs connecting to the database are shut down fully.

 

Make sure all users have exited out of the AyaNova program

Make sure all remote access options are shut down via your IIS (i.e. Data Portal, WBI and/or MBI)

Make sure that your application pool(s) used by your AyaNova remote access options are shut down

Make sure the network Generator service is shut down

 

b. Make a backup of your AyaNova database using  an approved SQL Server utility such as SQL Server Management Studio

c. Make a backup of your config.txt file so that you can refer to it/copy back if needed in steps further down

 

 

 

3. AyaNova 7 installation

 

Either follow A or B below.

If you encounter an issue following A, then restore and start from step 1 this time following B when get to this step

 

 

3.A. Install over top of existing AyaNova desktop program on your server

 

a. Make sure every AyaNova program and service is shut down unless specifically identified to run. Failure to do so will result in needing to restore from backup and performing the steps again.

 

On your server:

oconfirm that your Generator service is shut down

oconfirm that your IIS application pool(s) for your AyaNova remote access options are all shut down

oconfirm that any AyaNova desktop program and option is shut down

On your workstations:

oconfirm that any AyaNova desktop program and option is shut down

 

b. Download the latest AyaNova 7 setup file from https://www.ayanova.com/download.htm

 

c. Install taking the check-marked previous selections that are already selected - this is OK, as long as you do not run before stated to do so

 

When installing overtop of an existing installation, select No when receive the following message (so that you keep your existing custom config.txt confiugration connection file)

 

updateoverwriteconfig

 

d. Continue with step 4.

 

 

3.B. Remove all AyaNova programs from the server -> install stand-alone -> copy back config.txt

 

a. Make sure every AyaNova program and service is shut down unless specifically identified to run. Failure to do so will result in needing to restore from backup and performing the steps again.

 

On your server:

oconfirm that your Generator service is shut down

oconfirm that your IIS application pool(s) for your AyaNova remote access options are all shut down

oconfirm that any AyaNova desktop program and option is shut down

On your workstations:

oconfirm that any AyaNova desktop program and option is shut down

 

b. It is recommended to uninstall any previous AyaNova programs via Control Panel -> Add/Remove Programs before installing a new version

Uninstall plugins if installed OLI, OutlookSchedule, ExportToXLS, QuickNotify, AyaScript

Uninstall WBI, MBI, RI

Uninstall AyaNova

oif option to delete installed databases is displayed, select Yes. These would be the stand-alone sample trial databases from your original install that should have been removed anyways.

 

c. Download the latest AyaNova 7 setup file from https://www.ayanova.com/download.htm

 

d. Install as per stand-alone AyaNova installation steps (do not select to install anything else at this time - do NOT select to install the Generator, etc)

 

e. Run the AyaNova 7 program

 

f. Because this is a fresh install including installation of  a sample database, the default AyaNova Administrator login and password will be pre-entered for you.

 

g. Log in and confirm loads successfully. Yes, it is expected that this opens to sample data, don't freak out.

 

h. Exit out.

 

i. Delete the existing sample database config.txt file in your AyaNova program folder.

 

j. Paste in the backup of your original config.txt file

 

k. Continue with step 4.  

 

(Generator install, remote access options and other options would be installed at a later step below)

 

 

 

 

4. Apply your AyaNova subscription license(s) Activation Key

 

 **this step will not occur if your existing AyaNova version is 7.4 or higher and  has active scheduleable resources subscription**

 

 

a. Run the AyaNova 7 desktop program on your server

 

b. Log in as your AyaNova Administrator account

 

c. A message displays:

74Upgrade1

 

 

d.  Click on Fetch License as per your Activation Key email instructions

74Upgrade2

 

e. Enter in your registered email address into the Fetch address field, and your Fetch code into the Fetch code. Click on the green checkmark OK button to complete the fetch (internet access is required)

74Upgrade2b

 

f.Select OK and AyaNova will close.  We are not done yet!  Go to the next step.

74Upgrade3

 

 

 

5. Update your database

 

Run the AyaNova 7 program.

 

i. Log in as the AyaNova Administrator.  

 

You MUST log in only as the AyaNova Administrator this first time.

 

 

j. As per the message, make sure no one and nothing is accessing the AyaNova database

74Upgrade4

 

k. Schema update won't take long - let it finish!

74Upgrade5

 

l. Check your Help -> About AyaNova to confirm your licenses and to confirm your version.

74Upgrade6

 

 

m. Now you can complete the update on the workstations and install any other options.

 

 

 

6. Prep and install AyaNova 7 on networked computers

 

a. perform step #7 of the network SQL Server configuration on your workstations so they too are updated to the latest AyaNova 7 program version.

 

b. Install and configure your licensed AyaNova 7 optional plugins (i.e. ExportToXLS, OLI, OutlookSchedule)

 

When installing overtop of an existing installation, select No when receive the following message (so that you keep your existing custom config.txt confiugration connection file)

 

updateoverwriteconfig

 

 

7. Install and configure AyaNova 7 optional programs on the server (Event Generator, RI, WBI, MBI, and/or DataPortal) as needed

 

See in this Help documentation:

AyaNova Network Generator installation steps

AyaNova Data Portal installation and configuration steps

RI installation and configuration steps

WBI installation and configuration steps

MBI Help file for requirements, installation, configuration and use

 

When installing overtop of an existing installation, select No when receive the following message (so that you keep your existing custom config.txt confiugration connection file)

 

updateoverwriteconfig

 

 

8. Confirm your backup and restore procedures for your AyaNova SQL database

 

 

See also:

What's new in AyaNova 7

What's new in AyaNova 6

What's new in AyaNova 5