SharePoint Online Connector Configuration (6.1)

This article describes the steps needed for configuring the SharePoint Online Connector (SPOC) after the installation has succeeded.

1. Configure Primary Account for SPOC (Web Interface Access)

The Administrator account must first be created before the SharePoint Online Connector can be configured.

1. Navigate to https://[your-server]:[port number]

   1. Verify the interface loads correctly [screenshot]

2. Set up the Administrator user for SPOC

   1. The Administrator password is set on the first login

   2. Click on the Login drop-down button

   3. Choose Login Locally

   4. Enter Administrator for the Email field

   5. Enter a password of your choosing. (Note: The password must be at least 12 characters)

   6. Click Login

The Administrator account can be used to provision new Users as well as manage any aspect of the connector. This account information should be kept secure.

2. Configure Connection to Gimmal Records

This section configures the communication between the SharePoint Online Connector and Gimmal Records.

1. Access Web Interface: Navigate to https://your-server:8083 (Note: the port will depend on what was chosen during installation)

2. Connection Management: Go to Connection Management > Gimmal Records

3. Enter Configuration:

   • URL: URL for the Gimmal Records application

   • Username: Gimmal Records connector service account username

   • Password: Gimmal Records connector service account password

3. Configure Microsoft Graph API Connection in the SharePoint Online Connector

This section configures the connection to the Microsoft Graph API used to authenticate to SharePoint.

1. Click on ‘Microsoft Graph API’ in the left panel

2. Enter the Tenant ID and Client ID from the App Registration step:

   • Tenant ID: Your Azure AD Directory (tenant) ID (A)

   • Client ID: Your Azure AD Application (client) ID (B)
     

     

3. Click the ‘Save’ button (C)

4. An Upload Certificate button will appear. Click it to upload the .PFX version of the certificate file used during App Registration.

   1. Upload the .PFX certificate file created during App Registration using the ‘Select File’ button (A)

   2. Enter the certificate password (B)

      

   3. Click the ‘Upload’ button to complete the certificate upload (C)

   4. Verify the certificate thumbprint and expiration dates match the original (D)

5. Test Connection: Click “Test Connection” to validate authentication (E)

6. Save Configuration: Click ‘Update’ to save the settings (F)

   

Troubleshooting

Common Installation Issues

SSL Certificate Errors:

1. Ensure the certificate is properly bound to the IIS site

2. Verify that the certificate is not expired and includes the server name

3. Check certificate chain and root CA trust

Service Account Permissions

1. Verify the service account has the ‘Log on as a Service’ right

2. Ensure the service account has database permissions

3. Check the IIS application pool identity permissions

Database Connection Issues

1. Test SQL Server connectivity from the server

2. Verify connection string format and credentials

3. Check SQL Server authentication mode (Windows/Mixed)

4. Ensure the database exists and is properly configured

5. Ensure the service account has database permissions

Azure AD Authentication Failures

1. Verify Tenant ID and Client ID are correct

2. Check that the certificate is properly uploaded and not expired

3. Ensure Azure AD app has required Microsoft Graph permissions

Log File Locations

• Application Logs: C:\Program Files\Gimmal Records\Logs

• Service Logs: Windows Event Log > Application

• IIS Logs: C:\inetpub\logs\LogFiles

• Installation Logs: MSI log files created during installation