RVR-MSS-822
Issue summary
- You are encountering the error "Connection missing fieldError Code: RVR-MSS-822" when trying to connect to an Azure SQL database using Data Integration. This indicates that a mandatory field in the connection configuration might be missing or incorrectly set.
Action steps
To resolve the error, follow these steps:
- Check Connection Configuration:
- Ensure that all mandatory fields are correctly filled in your Azure SQL connection settings in Data Integration. Key fields include:
- Connection Name
- Host (Server name)
- Port Number (default is usually 1433)
- Database Name
- Authentication Method (make sure to select if it is SQL Authentication or Azure Active Directory)
- Username and Password
- Ensure that all mandatory fields are correctly filled in your Azure SQL connection settings in Data Integration. Key fields include:
- Test Connection:
- Once you've verified all fields, use the "Test Connection" function in Data Integration to check if the connection details are correct and working.
- Review Access Permissions:
- Ensure that the IPs used by Data Integration are allowlisted in your Azure SQL firewall settings to allow traffic.
- Reconnect if Necessary:
- In some cases, reconnecting to your Azure SQL account can resolve the issue. This may be necessary if recent changes were made to your configurations or credentials.
External references
- For more details on setting up an Azure SQL connection in Data Integration, consider reviewing the official documentation at Data Integration Azure SQL Connection Procedure.
note
If the issue persists or you need further assistance, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.
