SSMS error 40000 connection issues to TDS endpoint

Hunter McCarthy 1 Reputation point
2022-06-28T22:01:25.46+00:00

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.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2022-06-29T02:35:45.19+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.