Network SQL Express configuration
|Top Previous Next Print|
Read through all instructions first before proceeding.
Make sure you have the latest Windows operating system service patches installed before proceeding.
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.
SQL Express 2005 or higher only
If using SQL Express 2012, make sure to implement as per http://forum.ayanova.com/showthread.php?1804-Potential-numbering-issue-with-SQL-2012
It is your responsibility to be knowledgeable about SQL databases, especially about how to backup.
Use of AyaNova with SQL Express is a 7 step process
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.
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
b. Once installation is complete, run the AyaNova program and confirm you can log in
c. Exit out of the AyaNova program
a. Install SQL Express 2005 or 2008 - either is acceptable, but do make sure you install the management tools too.
b. After installing, enable the TCPIP and Named Pipes protocols via SQL Server Configuration Manager (for some reason, SQL Express has these disabled by default)
c. If using SQL Express 2005, configure for remote access
d. restart the SQL services or reboot your computer and log in as the computer administrator
If there is a firewall enabled on the "server" 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
For example, if you are using Windows Firewall:
If you are using a third-party software firewall, you will need to follow their instructions to add exceptions to sqlservr.exe and sqlbrowser.exe
a. Via the server's Start menu, select to run AyaNova -> Utilities -> Firebird to MSSQL
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:
(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 AYANOVASUPPORT/SQLEXPRESS and your sa username password is letmein, then your string would look like
Server=AYANOVASUPPORT/SQLEXPRESS;initial catalog=master;User Id=sa; Password=letmein;
Do note you can also find what the name is of your SQL Express server by running SQL Management Studio as is identified in the Service name: field.
d. Select Open Database Connections to test your connection strings
e. You will receive a message if connection is successful – select the OK button to proceed to create the SQL AyaNova database.
f. When finished at 100%, select the cancel button to close (the X) – wait until both lines show at 100%
g. The AyaNova SQL database has now been successfully created
a. Delete the existing config.txt 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
h. Now run the AyaNova program and confirm you can log in.
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. Now that you have confirmed it works you can re-use it at all work stations.
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. When a network setup is run it will automatically use the config.txt file it finds in the same folder as the setup program.
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.