Home : Hach WIMS Multi-User with MS SQL Server Database Support IT Prep Document
Q13522 - INFO: Hach WIMS Multi-User with MS SQL Server Database Support IT Prep Document

The following is an overview of the steps necessary to get the WIMS system operational from an IT standpoint.  Your Hach Project Manager will step you though the install and configuration via WebEx.  Please review the steps below in preparation for the remote install.  

  1. We will install and use our SQL Server Setup tool to create an account named OPSDBA, create a database named OPSROOT on your MS SQL Server Instance.  We will need you to enter your SA username and password in order to create the OPSDBA account.  At that point we will not need to login as SA anymore.  NOTE:  Hach WIMS requires mixed mode authentication. 
  2. Attach the SQL database we’ve created for your system to your SQL Server instance.  Database owner must be set to OPSDBA.  
  3. Install the Hach WIMS NT Services on whatever computer / application server you’d like that is on the same network.  These services should be on a powerful PC that has a stable connection to the database Server.
    • AdoCalc: The WIMSTM Calc engine is an NT Service that monitors the WIMSTM databases and calculates data.
    • Email Gateway (optional): Connects to your SMTP mail server and relays the emails generated by the Hach WIMS. 
    • Scheduler (optional): Used to schedule output of reports or graphs and database calculations.
    • GNR Server (optional): Receives requests from the scheduler to output reports and graphs, sends the output to a printer, a file, or to email.
    • Interfaces (optional):  Connects to other systems (i.e. SCADA, LIMS, etc…) and imports specified data into the WIMS database.  

     4.  Install the Client application on a pc connected to the network and test functionality

 

For more information:

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 9/15/2011 5:37 PM.
Last Modified on 9/16/2011 1:26 PM.
Last Modified by Scott Dorner.
Article has been viewed 5949 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article