MultiUser/Network Configuration
	Please contact:   Apothesoft Software Support.  

Warning:  Unauthorized changing of either the pharmacy name or registration information will cause the program to go into demo mode.

Steps In setting up MultiUser:
1)  Install program  (install demo version and we will convert it)   It can be downloaded from the Apothesoft web site:   
                 http://apothesoft.com/demo/demosetup.exe    
Install the program to the computer that will be serving as the HOST or "Server".     The install will create two directories off the C: drive:    C:\ApotheSQL   and   C:\ ASQLDB      The first stores the program files and the second stores the database files.
2) Ensure your workstations are all connect to the same router and your network setup and working.
3) From the Server computer, right click on MyComputer from the Windows Start menu and select "Properties"   and make note of the Computer Name.
4)  From   C:\ASQLDB  open the  SQLiteningServer.Cfg  file using Notepad.   Edit the line that says  Hosts=   to  Hosts= (your servers IP address or your servers Computer Name)  ie:  Hosts=196.168.1.103  or  Hosts=MyComputer   Some routers will assign the computer a different IP address each time the computer boots up.  It is usually better to use you servers computer name when setting the  Hosts=   setting.     Then save the changes.
5) Run the  SQLiteningServerAdmin  program and install the server software.  After software installed then select  the "Start" button to start the server.  If you get an error go back to step 4 and ensure the hosts= field is correct  and Port=51234  is set.
6) From  C:\ApotheSQL  open  the  ApotheSQL.INI  file  using Notepad.   Edit the line that says  IP=   to say  IP= (your servers IP address or your servers Computer Name)              ie:  Hosts=196.168.1.103  or  Hosts=MyComputer   Some routers will assign the computer a different IP address each time the computer boots up.  It is usually better to use you servers computer name when setting the  Hosts=   setting.       Then save the changes.
7) Also edit the  DBname  line  to say  DBname= (yourDBname).db3  or (YourPharmacyName).db3   example would be   DBname=MyPharmacy.db3   If you are using the demo database the line would be:   DBname=Demo.db3
8)  If you are starting with the default  database,  then go to  C:\ASQLDB  directory and rename the demo.db3  database file  to   (YourPharmacyName).db3   ie:  MyPharmacy.db3    Test the set up by running the  ApotheSQL.exe  program.   If no errors then setup workstations.
     If you are converting an old ApotheRx database then follow instructions in the help file  ConvertDatabase.rtf.
Setting Up Workstation:
1)  Copy the  C:\ApotheSQL  directory to each workstation computer.   Then create a shortcut to the  ApotheSQL.exe  program on the desktop of the workstation.
2)  Now test the ApotheSQL program by launching it using the shortcut.
If you get an error -16 when trying to run the ApotheSQL program from a workstation. You will need to go to the server's  Windows Control Panel --> System & Security then to "Allow program through Windows FireWall"  then add the  SQLiteningServer.exe to the "allowed" list.
If, when the computer is rebooted, the SQLiteningServer is not Automatically restarted  then open the Windows Services Manager "properties" for the SQLiteningServer and edit to restart in Automatic Mode.  In Recovery set Failure 1 and 2 to "Restart the Service" and set Failure 3 to "Run a Program"   Set the program to be RUN as "C:\ASQLdb\StopRestartDB.exe"    Click Apply the OK.   To get to the Windows Services Manager do the following:
1. Goto the Start Menu
2. Select Run
3. Open services.msc and select OK
4. Windows Services Manager will open.  

You should now be ready to run the program.   If you have problems or questions please give Apothesoft Support a call.   (360) 830-6365