MSSQL: PO Box

Steps to sync the application

1. Add the MSSQL application.
   

   
   

2. Click on Sync Now .
   

   

3. Enable ZUS.
   

   

4. Enable the Zilla Universal Sync (ZUS) and fill in the config details.
   All or any of the configurations can be kept blank here and can be provided in the ZINC local configurations. The configurations are

   1. Database Server Host: The host in the database connection string specifies the hostname or IP address of the database server.

   2. Database Server Port: The port in the database connection string specifies the port number on which the database server is listening. The default value is 1433.

   3. Database Name: The database name in the database connection string specifies the name of the database to connect to.

   4. Database Connection Parameters: It the parameters string from the database connection string. e.g. retry=true&service_name=Zilla

   5. Database Query: It is the query to retrieve the data from the database. This should be readonly query.

   6. Database Dialect: The dialect in the database connection string specifies the type of database you are connecting to. The dialect value should be mssql.

   7. Database Driver: The driver in the database connection string specifies the database driver to be used for the connection. The driver value should be pymssql .

   8. Database Connection String: The database connection string is an alternative method to configure the database connection. Instead of specifying individual values like host, port, database, username, password, dialect, and driver, you can provide a single connection string. The format should be: 'dialect+driver://username:password@host:port/database?parameters'. If this value is provided, it will be masked after saving because it contains username and password.

   9. Database User: The username in the database connection string specifies the user account to connect to the database.

   10. Database Password: The password in the database connection string specifies the password for the user account to connect to the database.
       

       

5. The sync will fail with the error as shown in the image
   

   

6. Go to the Settings
   

   

7. Go to the Audit Logs and Download the CSV file.
   

   

8. Go back to the application and click on the gear icon
   

   

9. Enable the toggle for “Accounts & Permissions CSV File Upload” and click on Sync Now

   

10. Select the “Accounts & Permissions CSV File Upload” and click on Next
    

    

11. Upload the previously downloaded CSV file in step 7 above.

12. Do the CSV column mapping and click on Next
    

    

13. Now the column mapping is saved, Click on Discard.
    

    

14. Go back to the application and click the gear icon again
    

    

15. Disable the toggle “Accounts & Permissions CSV File Upload” and click on Sync Now.

    

16. Now onwards, sync will succeed.