Client-Server Setup Instructions.
Client/Server is more secure and is much less prone to data corruption. Only the server accesses the data so if it is in good working order you will not see any data corruption. The workstations access it only via the server.
The following instructions are general in nature and may vary depending on your specific server configuration.
- Download the version of Channergy that you are licensed for from here.
- When you run the installer on your server make sure that you select the Client-Server option.
- After the install is complete, create a folder on your system for each company that you will be running through client-server. For example C:\Channergy\ClientServer
- Share the new folder and give it full permissions to Everyone.
- Copy the reports folder from your data directory to the new directory. Normally this is C:\Channergy\Data\reports
- Create a tools folder in the new directory. For example C:\Channergy\ClientServer\Tools
- Copy all of the Channergy Script files (.mws extention) into the new C:\Channergy\ClientServer folder. NOTE: Do not copy the Channergy Scripts into the tools folder.
- Create a new file in the C:\Channergy\ClientServer folder and call it clientserver.ini
- Open Notepad or some other text editor and add the following to the new clientserver.ini file
- Change the IPAddress = to be the IP address of the server that the client server (and the Channergy data) are installed on.
To check your IP address click the Windows Start button then choose Control Panel (you may need to select Settings, then Control Panel). Double click Network Connections. In the dialog that opens double-click your network connection. In the dialog that opens click the Support tab which displays your IP address (Note: this is the IP address for the PC, not the IP for the Internet.).
- Save the clientserver.ini in the C:\Channergy\ClientServer folder.
- To Ensure that the client-server is set up as a service do the following.
- Open a Command window (Start -> Run -> Cmd)
- Navigate to the directory that contains the client server file. It will be in C:\Program Files (x86)\Channergy\CS Engine.
- Type the following command in the Command Prompt: dbsrvr /install
- If the client-server engine was installed correctly you will get a prompt similar to
- To start the Service you will need to do the following
- Double click on the Administrative Tools from the Control Panel
- Double click on the Services icon
- Locate the Channergy Client-Server service, it will have the form DBSRVR_MW_20XX_YYYY where XX is the version year of the software and YYYY is the build number.
- Click on the Start hyperlink to start the service.
- On your server, click the Windows Start button and select All Programs ->DBIASAM Additional Software and Utilities -> Server Administration Utility.
- If you are installing Channergy 2010 or later the Server Administration Utility will be located under Channergy in the start menu.
- From the Server Administration Utility
- Click on File Login to Server you will get a login screen.
- For the default login use Admin as the User Name and DBAdmin as the Password.
- Click on the Databases tab and then the Add button.
- In the Name field that appears type Channergy. By using the Select button next to the directory field, browse to the directory that contains your Channergy data, then click Save (Note: You must name the database Channergy (or whatever you named it in the clientserver.ini file).
- Click on the Users tab and add as many users as you need.
- Click on the Database Users table and then click Add at the bottom. Select one of the users you added from the pulldown that lights up. Check all of the Rights to Grant and click Save. Repeat this for all users.
- Close the Server Administration Utility.
- Click for more detail information on the Server Administration Utility
- Open Channergy and click File -> New Database from the text menu.
- From the Open Database screen
- Click on the button
- Give the Company a name such as ChannergyCS
- Click on the button and navigate to the C:\Channergy\ClientServer folder.
- Click on the Ok button after you have saved the location and then click Ok again to exit the Open Database screen.
- You should now get a login prompt similar to
- To test your connection to the Channergy database through the client-server use the User Name of Admin and DBAdmin as the Password.
NOTE: For setting up multiple companies:
- Create a new database in the server admin utility, then
- Create a separate folder for each company with its own clientserver.ini and,
- Name the RemoteDatabase above to the same name as the db you created.
- For all folders include a reports and tools folder to store reports and script shortcuts.
Scripts are stored in the same folder as the clientserver.ini file