Update Service Account User Credentials on Connect Server

Overview

There may be cases where the Student Success & Engagement (SS&E) Service Account User credentials must be updated on the Connect Server. For example, if the service account user password expires, is lost, or is compromised then it may need to be reset.

This applies only to Connect2, not Cloud Connect. See the SIS Data Import Process for a visual on each of these connect methods.

Before completing the steps below, ensure the Service Account User's password is changed at the source--either Active Directory or the Local User. Then follow these steps to update the Connect2 Scheduled Task and Apache Drill (for CSV method) to ensure that your SS&E data feeds are not interrupted.

Update the Scheduled Tasks

Update the Service Account User's password on the Aviso Connect2 and Connect2 Auto-Update scheduled tasks on the Connect Server.

1. Search for Windows Task Scheduler (or press Win + R, type taskschd.msc, and hit Enter).

2. Find the specific task in the Task Scheduler Library.

3. Right-click the task and select Properties.

4. Under the General tab, look at the section "Security options."

5. Click the Change User or Group... button.
   Note: Even if the user name hasn't changed, clicking this or simply clicking "OK" triggers the password prompt.

6. Click OK at the bottom of the Properties window.

7. A dialog box will appear asking for the Password. Enter the new password and click OK.

Update Apache Drill

This step applies to Connect Method 1: CSV only. Connect Method 2: Direct DB does not use Apache Drill.

Update the Service Account User's password for Apache Drill via NSSM on the Connect Server.

1. Update Password in NSSM

   1. Open CMD as Administrator.

   2. Navigate to NSSM directory, ex: cd "C:\Aviso\nssm-2.24\win64"

   3. Run: nssm edit ApacheDrill

   4. Navigate to the Log on tab.

   5. Update the Password and Confirm password fields.

   6. Click Edit service to save.

2. Restart Drill

   1. Search for Windows Service Manager (or press Win + R, type services.msc, and press Enter).

   2. Find the "ApacheDrill" Service.

   3. Right-click on the service and select Restart.

3. Verify Drill is Running

   1. Open a web browser and attempt to visit http://localhost:8047. It may take 2-3 minutes for Drill to start up.

Troubleshooting

If you are unable to complete any of these tasks, or if Apache Drill does not start, please submit a request to Watermark Support with the subject "Assistance updating service account credentials for SS&E Connect Server" so our team can assist you.