Microsoft Dataverse for Teams is a free edition of Microsoft Dataverse with some limitations. one of those limitations is that it does not support conections from SQL Server Management Studio (SSMS). You won't be able to connect to dataverse's SQL Endpoint with SSMS when you are using Microsoft Dataverse for Teams. If you decide to move to the full version of Microsoft Dataverse then you will be able to use SSMS.
SSMS error 40000 connection issues to TDS endpoint
Hunter McCarthy
1
Reputation point
Hi, when trying to connect to my organizations endpoint I get a message saying "The 'ExecutePowerBISql' message is not supported in the dataverse for Teams offering" with an error code "Microsoft SQL Server, Error: 40000". I've been trying to find help elsewhere but don't seem to be making much headway.