SQL Server - Big Data Clusters
Summary:
-
Problem with enabling SQL Agent on multi-node BDC with HA
Currently, if you attempt to enable the SQL agent service on a multi-node BDC (CU4, with HA configured), the local instances are enabled, but the HA listener isn't. You get an error pop up when attempting to log into the HA listener instance (port 31433) using SSMS, see file attached for screenshot.
3 votesThank you for raising this issue. The team will investigate this and get back to you.
-
Fix Knox authentication on default deployment
Using SQL 2019 CU2, single node AKS, Knox is configured to use Shiro JDBCRealm with permissionLookupEnabled = true.
However, no override defines permission query and there is no roles_permissions define in the controller database.
This setting should be set to false.
2 votes
- Don't see your idea?