Installation with SQL Express server

1.	Ensure network communication between computers and server

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

2.	As recommended in the installation - 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.

a.	Information and download of SQL Server Express – (free via Microsoft) http://www.microsoft.com/sql/editions/express/default.mspx

c.	When installing, take Mixed mode, and enter a password for user sa

2.	Ensure SQL Server (SQLEXPRESS) and SQL Server Browser are running, and set for Automatic startup

3.	Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

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

6.	Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

7.	Confirm both SQL Server (SQLEXPRESS) and SQL Server Browser are running

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

Server=COMPUTERNAME\SQLExpress;initial catalog=master;User Id=sa; Password=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)

4. 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.MSDE_SQLEXPRESS_VERSION file to AyaNova.exe.config

b.	Edit where COMPUTERNAME is your computer's name, and PASSWORD is your sa password

"Server=COMPUTERNAME\SQLExpress;initial catalog=AyaNova;User Id=sa; 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:

“Server=COMPUTERNAME\SQLExpress;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.