It is always recommend to read through all instructions first before proceeding.
NOTE: Make sure you have the latest Windows operating system service patches before proceeding.
NOTE: It is recommended to never perform installation via remote computer. If you do, and you encounter any issues, go physically to the server and redo all steps from scratch again.
NOTE: If there is a firewall enabled on the computer where the SQL Express configuration is installed and setup, set exceptions for sqlserver.exe and sqlbrowser.exe, and/or UDP port 1434 and 1433 in some cases
Use of AyaNova with SQL Express is a 6 step process
| 1. | Ensure network uses TCPIP for communication between computers and server |
| 2. | Stand-alone AyaNova database and program is installed to server |
| 3. | SQL Express is installed and configured |
| 4. | Creation of SQL Express AyaNova database |
| 5. | Configure and confirm access for the AyaNova program on the server to the database |
| 6. | Configure and confirm access from network computers to networked database |
1. Ensure network uses TCPIP for communication between computers and server
The server and networked computers will communicate via TCPIP. If your network is not configured, please contact your local computer center. To confirm this, determine the server’s static internal IP address and ping from a local area networked computer
a. Open a command prompt on the server (Start -> Run -> type in cmd and click on OK) and type ipconfig in the DOS prompt
b. Make a note of your server’s IP Address
c. Confirm that network computers can “talk” to the server by opening a command prompt on a local area networked networked computer and typing ping xxx.xxx.xxx.xxx and the Enter key where xxx.xxx.xxx.xxx is the IP address of your server
For example, if your server's IP address is 192.168.1.15, you would type ping 192.168.1.15
If you get a timeout, there is an issue connecting via TCPIP. Please contact your local computer center to troubleshoot.
2. Stand-alone AyaNova database and program is installed to server
a. Install the stand-alone AyaNova database and program to the server's local hard-drive while logged into that server itself. Refer to Stand-alone default AyaNova installation
| • | You must also select to install the Install Import and migration utilities as these include the utility to create the AyaNova SQL database ToMSSQL.exe |
| • | Do not bother selecting to install anything else at this time (i.e. do not install QBI, Data Portal, Generator etc until after the network configuration has been done) |
| • | Do note that once you have completed all of the network steps, you can remove the AyaNova program from the server itself if you do not want the program files on it and won't be installing any optional add-on's such as Data Portal, Generator, etc. Do note that having AyaNova program files on the SQL Express Server does not hamper it in any way, and takes up a maximum of 50MB in space; and provides you with a location to confirm your setup with AyaNova Support in the event you experience an issue. |
b. Once installation is complete, run the AyaNova program and confirm successful
c. Exit out of the AyaNova program
d. The AyaNova program files are installed by default to C:\Program Files\Ground Zero Tech-Works Inc\AyaNova
e. The AyaNova sample database is installed to %AllUsersProfile%\AyaNovaData\AYANOVA.FDB
| • | this usually refers to C:\Documents & Settings\All Users\Application Data\AyaNovaData\AYANOVA.FDB |
3. SQL Express is installed and configured
a. Install SQL Express
| • | Information and download of SQL Server Express – (free via Microsoft) http://www.microsoft.com/sql/editions/express/default.mspx |
| • | Refer to Microsoft for requirements |
| • | When installing, take Mixed mode, and enter a password for user sa |
| • | Take all other defaults |
b. After installation completes, ensure SQL Server (SQLEXPRESS) and SQL Server Browser are running, and set for Automatic startup
c. Set protocols used by SQL Express
Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager
Expand Protocols for your SQL Express server under SQL Server 2005 Network Configuration
Make sure both Named Pipes and TCIP/IP are Enabled
c. Configure SQL Express for remote access
Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Surface Area Configuration Utility
Click on the link for Surface Area Configuration for Services and Connections
Select Remote Connections option under the Database Engine for the SQL Express server and make sure Local and Remote Connections is checked with Using TCP/IP Only
d. Reboot the computer and log in as the computer administrator
e. Confirm both SQL Server (SQLEXPRESS) and SQL Server Browser are running
4. Creation of SQL Express AyaNova database
a. On the server's Start menu, select to run the Firebird to MSSQL utility
b. This will open the ToMSSQL utility
c. You now need to edit the connection strings to what you actually have
Firebird database connection string
| • | If have taken all defaults with installed stand-alone AyaNova v4, your connection string will be as shown by default in the screenshot above unless you are using a Vista computer, than the default for %AllUsersProfile% may mean you need to edit it similar to as follows: |
ServerType=1; Database=C:\ProgramData\AyaNovaData\AYANOVA.FDB;Dialect=3;
| • | If instead you had previously configured AyaNova for network Firebird use and are now converting to SQL, you need to instead enter like the following: |
ServerType=0;DataSource=SERVERIPADDRESS_OR_NAME;DataBase=AYANOVA;User=SYSDBA;Password=masterkey;Dialect=3;
(where SERVERIPADDRESS_OR_NAME is your network Firebird server's name or ip address, where AYANOVA is the database name you set in the aliases.conf, and where masterkey is the password you set for your Firebird Server)
Microsoft SQL database connection string
You need to edit this string to your SQL Express server settings
Server=SERVERNAME\SQLExpress;initial catalog=master;User Id=sa; Password=PASSWORD;
(where SERVERNAME is your server computer's name, and PASSWORD is your sa password, and note also that the initial catalog is master for this utility)
So if your SQL Express server is called mycomputer/SQLEXPRESS and your sa username password is letmein, than your string would look like
Server=mycomputer\SQLExpress;initial catalog=master;User Id=sa; Password=letmein;
d. Select Open Database Connections to test your connection strings
| • | As the message says, it will now confirm connection to the original AyaNova database, and to the SQL server. |
| • | If the connection strings are not correct, a message will appear that you need to correct them - there may be an incorrect text entry in either the Firebird database connection string or the Microsoft SQL database connection string – check your punctuation, your spelling, your database location, your server name, your server password etc and retry |
j. You will receive a message if connection is successful – select the OK button to proceed to create the SQL AyaNova database.
k. When finished at 100%, select the cancel button to close (the X) – wait until both lines show at 100%
5. Configure and confirm access for the AyaNova program on the server to the database
a. Delete the existing config.txt using NotePad in the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
b. Move to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova/examples folder
c. Copy the EXAMPLE_SQLEXPRESSconfig.txt file
d. Move back to the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
e. Paste in the EXAMPLE_SQLEXPRESSconfig.txt file into the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder
f. Rename this file to config.txt
g. Edit this new config.txt using NotePad
| • | Do not use any other program but NotePad to edit this file |
| • | Edit Server= to your SQL Express server's name |
| • | Edit your sa password |
h. Now run the AyaNova 4 program and confirm you can log in.
6. Configure and confirm access from network computers to networked database
a. Copy your network SQL Express configured config.txt file from the C:\Program Files\Ground Zero Tech-Works Inc\AyaNova folder to a shared location that your networked users can access.
b. Copy/Move to this same shared folder the AyaNova installation file AyaNovaSetup.exe that you used to install on the server
c. Have each local networked computer run the AyaNovaSetup.exe file from that shared location that also has the edited config.txt in that same shared location.
| • | Make sure the networked computer selects AyaNova - Networked computer installation |
If the local networked computer will also run QBI, or PTI or perform an import, select when installing on that computer those optional AyaNova programs. Refer to the QBI Manual or PTI Manual available from the AyaNova download web page if using QBI or PTI. Refer to the appropriate Import CSV utility section in this help file if using one of the import utilities.
The AyaNovaSetup.exe will "see" that config.txt file and automatically copy it to that computer's AyaNova program directory so no additional configuration is needed on that user's station.
The install will only install the AyaNova program files it has been told to install, will copy that config.txt file to the networked workstations AyaNova program folder and will not install a trial database.
The AyaNova installation will place a desktop icon for AyaNova on the desktop as well as in the start menu.
You can confirm that AyaNova is configured correctly on the networked computer by logging in on that networked computer, selecting Help -> About AyaNova so that you know that you are correctly connecting to the networked SQL Express configuration
Refer to Network Generator installation steps to install and configure the Event Generator in a network setup if applicable.
Refer to the Data Portal installation and configuration steps to install and configure the AyaNova Data Portal if applicable.