SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, logs, …


Moved from: bobsql.com


This blog post focuses on connecting to the SQL Server BDC, some helpful log files and utility outputs.  Understanding a few basics about a SQL Server BDC and the Contained Availability Group (containedag) makes managing and troubleshooting easier.





Cluster IP Address and Port

To connect to a SQL Server BDC use the exposed IP address (FQDN for an AD enabled cluster) and the target’s, listening port.   To locate the IP address and port, use one of the following commands:


kubectl cluster-info

Kubernetes master is running at