1. Go to Computer Management > System Tools > Local Users and Groups > Users.
2. Right-click in the Users window and select New User.
3. In the New User dialog:
   1. Enter a User name (for example, cm4dervice).
   2. Enter the Full name (for example, CM4D Service).
   3. Enter a Description (optional).
   4. Enter a strong Password and Confirm Password.
   5. Uncheck 'User must change password at next logon'.
   6. Check User cannot change password.
   7. Check Password never expires.
   8. Click Create.
   9. Click Close.
4. Right-click on the user you just created and select Properties.
5. Select the Member Of tab.
6. Click Add.
   1. Enter the object name for your administrators group (typically, Administrators) and click Check Names.
   2. If the correct account is found, click OK.
7. Close Computer Management.

1. Create a new Login (e.g., cm4duser).
2. Select SQL Server authentication.
3. Enter a secure Password.
4. Confirm password.
5. Clear the Enforce password expiration check box.
6. For the Default database, select your new Site database (or CM4D database if you are not using a Site).

Using certificates is only required if your SQL Server instance uses a certificate. If SQL Server does not use a certificate, this section can be skipped.

If CM4D is running on a different machine than SQL Server, the SQL Server certificate must also be placed into Trusted Root Certificates on the CM4D Server.

All SQL Server Names across CM4D must use fully qualified domain names (e.g. ATSVMCM4Dxxx.ats-global.local) and must match the "CN=" value of certificate.

CM4D requires a few SQL databases to be created and configured for the CM4D software to access. This can be done manually by running the database scripts individually in SSMS or using the CM4D Database Utilities provided in the CM4D install folder.

If the task you selected did not work, the authentication user may have insufficient database privileges. Check the authentication user credentials or try executing the Database Utility using 'Run as administrator'.

See the topic Database Utilities for details.

Site Database

Create new CM4D Site Database:

CM4D Database(s)

Create a new CM4D Database:

1. Run DbConnect (as Administrator).
   1. Connection Type - Change the dropdown to "Site Connection".
   2. Windows Authentication - Select one of the two available methods of authentication for connecting to the databases:
      1. Windows Authentication - Set the dropdown to 'True'.
      2. SQL Authentication - Set the dropdown to 'False'.
         1. Database User ID - Enter the user name of the SQL user login.
         2. Database Password - Enter the password for the SQL user.
         3. Confirm Password - Re-enter the SQL user password.
   3. Server Name - Enter the name of the database server. If using a Named Instance, include this in the server name.
   4. Database Name - Enter the name of the CM4D Site database.
2. Click Apply.
3. Click Test Connection.
   1. If successful, click OK and continue to the next step.
   2. If the connection fails on an existing database, check your settings and then test again.
   3. If the connection fails in a new installation (before the db is created with Database Utilities), this is acceptable; continue to the next step.
4. Click OK to exit DbConnect.

1. Run SiteManager. The first time you log in, use the following credentials:
   1. Username: cm4dsingle
   2. Password: cm4dsingle
2. On the Sites tab, create a New Site and enter in the information you want to enter about this Site database.
3. Go to the Managed DataSources tab and create a new Data Source.
   1. Label - Enter a label; this does not have to match the actual database name.
   2. Site - If you are using multiple Sites, select one from the dropdown to assign this Managed DataSource to that Site.
   3. Windows Authentication - Select one of the two available methods of authentication for connecting to the databases:
      1. Windows Authentication - Set the dropdown to 'True'.
      2. SQL Authentication - Set the dropdown to 'False'.
   4. DataBase UserName - Enter the user name of the SQL user login.
   5. Password - Enter the password for the SQL user.
   6. Confirm Password - Re-enter the SQL user password.
   7. Server Name - Enter the name of the database server. If using a Named Instance, include this in the server name.
   8. Database Name - Enter the name of the CM4D database.
      1. Click Test DataSource Connection.
         1. If successful, click OK and continue to the next step.
         2. If the connection fails on an existing database, check your settings and then test again.
         3. If the connection fails in a new installation (before the db is created with Database Utilities), this is acceptable; continue to the next step.
   9. Click Save.
4. Go to the Users tab.
   1. Create a new user.
      1. User Name - Enter the users' Windows ID as the user name (for example, cm4duser or jsmith).
      2. Full Name - Enter the user name as you want it displayed.
      3. Password - Enter a password. This is not the Windows password for the user; can be any password.
      4. Confirm Password - Enter the password again.
      5. E-Mail Address - Enter an email address for the users that will receive EventSmith notifications.
      6. Must Change Password - Only set this to Yes if you want a user to log into Site Manager to set their own password.
   2. Create any additional users.
   3. Change the password for the cm4dsingle user to something other than the default password.
   4. Click Save.
5. Go to the Groups tab and create a new Group.
   1. Group Name - Enter a name for the group, such as Admin, that is descriptive of the purpose or scope.
   2. Users - Assign users to the group; click on the Users row 'click to change user list ->' and then click the ellipses button.
      1. Available Users - Click to select one or more user names to add to the group.
      2. Selected Users - Highlight users in the Available Users window, then click the left pointing arrow to add the users to the Selected Users list.
      3. Click OK.
   3. Access Privileges - Select the check boxes for each Site and CM4D databases you want to grant access to the group.
   4. Data Privileges - Select the check boxes for the privileges you want to assign to the group. See here for descriptions of the user privileges.
6. Go to the Results DataSource tab and enter the required information. No Results Db yet? No Results Db yet? The Results database object may not exist at this point if this is a brand new installation (Test Connection will FAIL - this is OK). The information still needs to be entered here and tested because it will be used by the Results Database Utility to create the database object when the tool is run.
   1. Server Name - Enter the name of the database server. If using a named instance include the instance name with the server.
   2. Database Name - Enter the name of the Results Database.
   3. Windows Authentication - Select one of the two available methods of authentication for connecting to the databases:
      1. Windows Authentication - Set the dropdown to 'True'.
      2. SQL Authentication - Set the dropdown to 'False'.
   4. DataBase UserName - Enter the user name of the SQL user login; must have the 'dbowner' privilege level in SSMS. This is the login used by Results Database Utility to create/modify the Results database in SQL Server.
   5. Password - Enter the password for the SQL user.
   6. Confirm Password - Re-enter the SQL user password.
   7. Click Test Connection.
      1. If successful, click OK and continue to the next step.
      2. If the connection fails on an existing database, check your settings and then test again.
      3. If the connection fails in a new installation (before the db is created with Database Utilities), this is acceptable; continue to the next step.
   8. Click Save.
7. Go to Settings > EventSmith SMTP Settings menu and configure the following:
   1. SMTP Host - The server address of the SMTP mail server.
   2. Port - The port number used to connect to the SMTP mail server. It must match the SMTP port used on your mail server.
   3. Enable SSL - Check this option only if the mail server requires SSL.
   4. Username - The username that will be used to log in to Authenticate on the mail server. For anonymous relay, leave this empty.
   5. Password - The password for the Authentication user name. For anonymous relay, leave this empty. The password is encrypted in the database.
   6. From Address - The email address from which the event notifications are sent. If this is left empty, EventSmith will attempt to obtain an address from the Site database based on the user running the service. If neither exist, the service will not start. If you are using Authentication, the from address should match the account used to log in to the SMTP server or it will likely fail to send any email.
   7. Click OK.
8. Click Save & Exit.

1. Go to the CM4D install folder (.\CM4D\Database Utilities\Results Database Utility) and run ATS.CM4D.ResultsDatabaseUtility.Migrator.exe.
2. Follow the prompts in the console window to create or update the Results database.
3. Once the operation is complete, the command window closes automatically.
4. Wait for the process to complete.
5. When it is finished running, the Command Prompt will read ''Successful migration. Press any key to exit application".

1. Open the following Firewall ports:
   1. TCP 36057 - Client PCs need access to the automation server running Scheduler services to be able to manage Scheduler jobs via Scheduler Manager.
   2. TCP 8001 - Client PCs need access to the ATS Licensing Server to retrieve CM4D licenses.
   3. TCP 80 - Web clients need access to the server hosting CM4D Web.
   4. TCP 1433 - Database servers must allow access to any clients connecting to CM4D databases.

1. Select User Mapping.
   1. Check the boxes next to your CM4D Site database, CM4D database(s) and Results database.
   2. For each of the databases, set the Database role membership to 'public' and 'db_owner'.
2. Click OK.

1. Browse to the folder where CM4D is installed. By default, this is C:/Program Files/Applied Tech Systems/CM4D.
2. Right click on DataSmithBatchManager.exe and select Run as administrator.
   1. In the top left of the interface, find the Batch Processor Settings section.
      1. Click the ellipses following the File Path.
      2. Browse to a network folder that is accessible to Batch Users.
      3. Select the folder and click OK.
   2. Click Make Default.
3. Click New to create a job.
4. Click Save & Exit.

1. Browse to the CM4D install folder (.\Applied Tech Systems\CM4D).
2. Edit the Cm4d.ini file (requires READ/WRITE Administrator privileges).
3. In the [default] section find the parameter "PDFPRINTDRIVER".
   1. Set the value to "ATS CM4D Printer".
   2. Comment out (#) the other print driver options or delete the unused lines entirely.
4. Save and close the Cm4d.ini file.

1. Open Control Panel > Administrative Tools > Services.
2. Start one of the CM4D services.
3. For new installations, the services may not start. If you are using a service user account that has never been granted the Log On As A Service rights, complete the following steps on one service.
   1. Right-click on the Service and select Properties.
      1. Go to the Log On tab.
      2. In the Log on as section, select This account.
      3. Enter the User credentials for the user account that will run the CM4D service.
      4. Click OK.
   2. Click OK on informative message ‘The account … has been granted the Log On As A Service right.’
   3. Try to start the services again.

• Scheduler Service
• Scheduler Launcher
• DataSmith Batch

If you are starting the Scheduler or Batch services for the first time, the services will request an Enterprise license from the ATS Licensing Server. You must open ATS Licensing Server Manager in ATS Security and Configuration Manager and approve the license request. Once it is approved, you can retry the Service start.