Enterprise Edition Installation

The Enterprise Edition offers advanced processing features for medium to very large environments. This section discuss the installation steps necessary for both hosting the SmartBatch database on one of the many supported database platforms and the steps required to install the Remote Agent.

The Enterprise Edition Windows Installer must be used to install the Enterprise Edition of the product. The name of the installer is setup.exe. Double-click on this setup file to run the installer. Follow the prompts and provided the requested information to install SmartBatch.

The Free, List, Standard and Enterprise Editions by default use the Microsoft Access database file (sb.mdb). This database is sufficient for product evaluation purposes and some production environments. If you need assistance determining which database product to use with SmartBatch, contact OnLine ToolWorks Corporation for guidance. You do not need to separately license a database product. All the databases supported by SmartBatch have a free version available (e.g., SQL Server Express). If you wish to use an existing database instance, you can identify this by using the SmartBatch Database Management tool. The Executive Server connects to the database server configured using the Database Management tool. No other component in SmartBatch connect to the data source other than the Remote Agent in the Enterprise Edition. All other components connect to the Executive Server.

The Remote Agent provides the ability to send processing (execution of Operations) to computers on your network. When an Operation is configured a computer name or Computer Group can be specified (see Operation Properties). By default the computer information is not entered and the Operation is processed on the computer where the Executive Server is installed.

You must install the Remote Agent on each computer that you plan to use to schedule/process SmartBatch objects. Any computer to be included in a computer group must have a Remote Agent installed except for the Executive Server computer. You should not install the Remote Agent computer on the Executive Server as it will not be used. The Remote Agent setup program can be downloaded from OnLine ToolWorks Corporation web site.

When the Remote Agent Installation completes, you will be prompted to enter the database connection information. This must be the same database instance used for the Enterprise Edition installation. A message queue is used to provide messaging between the Executive Server and the Remote Agent.

Use Integrated Security

Check this box if the Connection string indicates that you are using integrated (trusted) security. You must provide a connect string in the Connect with field that has the correct value to use for integrated security. An example for SQL Server is:

Data Source=<instanceName>;Catalog=SmartBatch;Integrated Security=SSPI;

	RA Computer Name
	The name of the Remote Agent. By default, the name of the computer where the Remote Agent Configuration program is run is placed into this field. This value is used in conjunction with the Delete Queued Entries button. You can place the name of another Remote Agent computer into this field and any entries that exist in the Remote Agent Queue table (RAQueue) will be deleted for that computer.

Buttons

Test Connection Button

Attempts to connect to the SQL Server Instance and Database Name based on the information provided (User, Password, etc.). If the connection is successful, be sure to use the Save Settings button to save the information. The Remote Agent will use these settings to connect to the database.

Save Settings Button

Save the information entered.

You must register SmartBatch in order to use it. If you are evaluating the product, you must enter the Support ID and Password sent to you from the download email or you can obtain this value from support@onlinetoolworks.com. If you have purchased SmartBatch, you can enter the Support ID and Password provided to you.

Delete Button

Selecting this button will delete entries in the Remote Agent Queue table (RAQueue) in the database. You may want to do this if the Remote Agent was down for some period of time and their are old entries in the queue. The action deletes only the queued entries associated with the computer running the remote agent.

The setup in the picture above uses SQL Server security with the sa User ID and Password. Integrated security can also be used by specifying a Windows Account that is known to the SQL Server as a Login and has been configured as a User in the Database. Please refer to SQL Server Books Online for more information about SQL Server security or contact OnLine ToolWorks Corporation for assistance.

Note: The use of the Access database is not supported for use with Remote Agents with the Enterprise Edition.

	Database Type
	Identifies the type of database that will be used to host the SmartBatch configuration. For example: SQL Server.

	SQL Instance Name
	The value for the SQL Server instance (e.g., mycomputer\SQLExpress or .\SQLExpress).

	Database Name
	The name of the database that exists within the SQL Server Instance that is used to maintain the SmartBatch configuration.

	User ID
	The User ID associated with the Password used to connect to the database server used to host the SmartBatch configuration.

	Password
	The password associated with the User ID used to connect to the database server that hosts the SmartBatch configuration.