HDInsight Cluster 4.0 with existing Hive metasore. Error - FailedToSetupDatabaseErrorCode

Question

As per Azure HDInsight documentation,

I see new user interface with existing Hive metastore database name input and not needed to authenticate the database connection.

Is this UI as per expectation and database credentials will be fetched by HDInsight deployment process in background?

Error for cluster creation - FailedToSetupDatabaseErrorCode

Detail Error-

{"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details.","details":[{"code":"Conflict","message":"{\r\n \"status\": \"Failed\",\r\n \"error\": {\r\n \"code\": \"ResourceDeploymentFailure\",\r\n \"message\": \"The resource operation completed with terminal provisioning state 'Failed'.\",\r\n \"details\": [\r\n {\r\n \"code\": \"FailedToSetupDatabaseErrorCode\",\r\n \"message\": \"Internal server error occurred while processing the request. Please retry the request or contact support.\"\r\n }\r\n ]\r\n }\r\n}"}]}

Answer 1

Make sure you have configured "Authenticate SQL Database" to resolve this issue.

Note: It's mandatory to configure "Authenticate SQL Database" while creating Hive metastore with Azure HDInsight Cluster.

Hope this helps.