Installation with SQL Server

Use of AyaNova with SQL Server utilizes the same steps as that for SQL Express, except you use a SQL Server connection string in the AyaNova.exe.config and in the TOMSSQL utility, instead of a SQL Express connection string.

1.	Ensure network communication between computers and server

2.	Embedded AyaNova database and program is installed to the server

2.	As recommended in installation steps - take all defaults – install to the suggested program path C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3

3.	Once installation is complete, log into AyaNova and confirm successful

5.	It is very important that the AyaNova database is not accessed unless stated so in the following steps. Failure to not have AyaNova closed will result in database issues.

3.	Ensure Autostart is set for SQL Server and for SQL Server Agent

5.	Reboot the computer and log in as the computer administrator

1.	Download the Firebird to MSSQL Converter utility from the AyaNova website

2.	Extract the ToMSSQL.exe file from the download to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 directory

3.	Run the ToMSSQL.exe file to bring up the Firebird to MSSQL Migrator

i.	if have taken all defaults with installed AyaNova v3, edit the connection string so it shows as follows (note that the User=AYANOVA;Password=AYANOVA; is removed):

ServerType=1;DataBase=C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3\AYANOVA.FDB;Dialect=3;

ii.	Or refer to your present AyaNova.exe.config file for what the connection string for ServerType, Database location, user and password should be if presently using the network firebird configuration

data source=SQL_SERVER_NAME;initial catalog=master;User Id=LOGINNAME; Password=PASSWORD

where SQL_SERVER_NAME is your SQL Server's name, LOGINNAME is the SQL Server login name with full rights and PASSWORD is that users password

i.	Select Open Database Connections to test your connection strings

(of course your connection strings will be different that those shown in the screenshots)

ii.	If the connection strings are not correct, a message will appear that you need to correct them - there may be an incorrect text entry – check your punctuation, your spelling, your database location and retry

iii.	You will receive a message if connection is successful – select the OK button to proceed to create the SQL AyaNova database.

(of course your connection strings will be different that those shown in the screenshots)

iv.	The creation of the SQL AyaNova database will now progress. When finished at 100%, select the cancel button to close (the X)

c.	Delete the ToMSSQL.exe file from the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 folder

1.	Delete the existing AyaNova.exe.config file in C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3

2.	Rename the AyaNova.exe.config.MSSQLSERVER_VERSION file to AyaNova.exe.config

b.	Edit where SQL_SERVER_NAME is your SQL Server's name, LOGINNAME is the SQL Server login name with full rights and PASSWORD is that users password

data source=SQL_SERVER_NAME;initial catalog=AyaNova;User Id=LOGINNAME; Password=PASSWORD

d.	You will have noted that the editing would have been the same that you entered in the TOMSSQL.exe

4.	Double-click on the AyaNova icon on your desktop to confirm successful

5.	First time the AyaNova log in screen loads, it may take a few seconds – it will come up.

6.	If you receive an error instead of the AyaNova login screen, go back through each step and confirm spelling and steps

7.	Once you have confirmed successfully launching of the AyaNova program to the SQL Server AyaNova database, you may also want to edit the configuration file AyaNova.exe.config so that it does not display your SQL Server username and password by using integrated security. For example, re-edit to:

“data source=SQL_SERVER_NAME;initial catalog=AyaNova; integrated security = true”

a.	Use of previous program files or previous beta AyaNova database will result in corruption

2.	Install Microsoft .NET Framework 2 and applicable service patches.

a.	Check if already installed by opening Control Panel -> Add/remove Programs -> scroll to determine if Microsoft .NET Framework 2 is installed

b.	Refer to the Microsoft downloads web page http://www.microsoft.com/downloads if you do not already have this installed. If not displayed under Popular Downloads, enter Microsoft .NET Framework 2 in the Search for a Download section

3.	Copy the folder and all its files C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3 from the server you configured in the previous steps to the local hard-drive of each networked computer.

a.	Do NOT run the AyaNova executable from a networked location – it must reside with all files on each computer's local hard drive

c.	Browse to the location of the AyaNova 3 folder and files that you copied to this networked computer's local hard drive

5.	Run AyaNova by double-clicking the AyaNova desktop icon and confirm successful login.