RVR-MSS-819

Issue summary

• The error message "Connection missing field - Error Code: RVR-MSS-819" in the context of configuring an azure_sql connection in Data Integration indicates that one or more necessary fields are not provided or are incorrectly set up in the connection configuration.
• This error usually arises when essential connection parameters, such as host, database name, username, or other credentials, are either missing or improperly configured.

Action steps

To resolve the error, follow these steps:

• Review your Azure SQL connection details in Data Integration. Ensure that all required fields, such as the Host, Database, Username, and Password, are correctly filled out .
• Make sure that Data Integration IPs are allowlisted in your Azure setup to ensure smooth connectivity .
• Validate your credentials. Test the connection using the "Test Connection" button in Data Integration to verify that the details provided can successfully connect to the database .
• If you're using Azure Active Directory for authentication, ensure that Azure AD is configured correctly and the credentials are input accurately .
• Check if there are any specific permissions required for the user account being used that might not be set .

External references

• Azure SQL Database Documentation - Microsoft's official documentation which might provide insights into specific configuration details or permissions required.

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.