Upgrading if networked SQL Server AyaNova

Top Previous Next Print

It is always recommend to read through all instructions first before proceeding.

NOTE: Refer to the AyaNova Pricing web page and AyaNova FAQ Answers web page for details on upgrade pricing

NOTE: AyaNova 7 requires SQL Server 2005 or higher. Microsoft no longer supports SQL 2000 or lower.

IMPORTANT NOTE: As per the steps below, you apply your AyaNova 7 Activation key after you have performed the upgrade steps. You MUST perform the upgrade steps before the Install By date of your AyaNova 7 Activation key to avoid re-issue charges.

Before proceeding, make sure that you know your AyaNova Administrator username and password

•	ONLY users of type Administrator can edit users, security groups, etc.

•	Make sure you do know your AyaNova Administrator username and password before upgrading to AyaNova 7

•	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, and keep that username and password in a safe place for future use too.

•	If upgrading from much older AyaNova, it would be recommended to test your customized report templates with the latest version. See http://forum.ayanova.com/showthread.php?1503

Upgrading for network SQL Server configuration is a 8 step process

1. Create backup of your SQL Server AyaNova database

2. Remove all AyaNova programs

3. Install stand-alone AyaNova 7 on server

4. Configure the server's AyaNova 7 for network SQL Server database

5. Apply the AyaNova 7 keycode to your AyaNova database

6. Prep and install AyaNova 7 on networked computers

7. Install and configure any additional AyaNova 7 optional server programs (Generator, WBI, MBI, and/or DP)

8. Confirm your SQL backup and restore procedures.

1. Create backup of your SQL Server AyaNova database

a. Make sure all users are out of all AyaNova related programs connecting to the database

•	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 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 if needed in steps further down

2. Remove all AyaNova programs

a. It is recommended to uninstall any previous AyaNova programs via Control Panel -> Add/Remove Programs before installing a new version to make sure only new files are in use

•	Uninstall QBI, PTI, and other plugins

•	Uninstall WBI, MBI

•	Uninstall AyaNova

3. Install stand-alone AyaNova 7 on server

a. Refer to stand-alone AyaNova installation steps

b. Run the AyaNova 7 program and confirm it loads successfully

•	The first time you run AyaNova 7, it will display with the AyaNova Administrator username and password pre-entered as the trial AyaNova database was installed - this is OK and expected.

c. Make sure you have exited out of AyaNova 7

4. Configure the server's AyaNova 7 for your SQL Server database as per step #6 of the network SQL Server configuration

a. perform step #6 of the network SQL Server configuration

Do note that you can instead just replace the stand-alone configuration config.txt file that was just installed with your backup config.txt file.

b. Run AyaNova 7 which will now connect to your networked SQL AyaNova database and will update it

•	The first time AyaNova 7 runs, it will update your AyaNova database. It may take a while to first load as it makes internal changes - let it run as it could take 15 seconds up to 15 minutes or more, and the AyaNova 7 log in screen will show up when it is ready

c. Log into AyaNova 7 as the AyaNova Administrator and confirm loads correctly

•	A message will display that the licenses have expired - this is OK and expected because your AyaNova 7database needs to now be licensed for AyaNova 7.

•	If you encounter an issue connecting to your AyaNova networked database via the server, do go back and double-check each of your steps from the beginning.

d. NOTE: AyaNova 7 has database "fingerprinting" where it compares your database against what is expected. If additional tables or columns have been added or the database schema modified, AyaNova 7 will not start to prevent additional problems arising as a result from those that have modified their database.

If you get a message loading AyaNova that the AyaNova database appears to have been modified and then it lists all the tables in the AyaNova database, and at the end of the list it shows a table called dtproperties, what has occurred is that at some time, someone in your organization created a diagram of the AyaNova database using SQL Enterprise Manager which created this additional table. You need to delete the table dtproperties and then run AyaNova again.

If instead you get a message loading AyaNova that the AyaNova database appears to have been modified and then it lists all the tables in the AyaNova database, and at the end of the list it doesn't show a table called dtproperties, send us the ayalog.txt file from your server where this occurred so that we can see it and help you identify what table/field as been added to the AyaNova database which should not have been done.

5. Apply the AyaNova 7 keycode to your AyaNova database.

a. refer to your AyaNova 7 keycode for steps to apply.

b. Check your report templates. See the forum topics if an error attempting to open http://forum.ayanova.com/showthread.php?1302 and http://forum.ayanova.com/showthread.php?1503

6. Prep and install AyaNova 7 on networked computers as per step #7 of the network SQL Server configuration

a. perform step #7 of the network SQL Server configuration

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

See in this Help documentation:

•	AyaNova Network Generator installation steps

•	AyaNova Data Portal installation and configuration steps

•	MBI Help file for requirements, installation, configuration and use

And refer to the Online Help web page for the Help documentation for:

•	QBI Help file for requirements, installation and use from the AyaNova web site

•	PTI Help file for requirements, installation and use from the AyaNova web site

•	WBI Help file for requirements, installation, configuration and use from the AyaNova web site

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