question

AntonUdalov-3166 avatar image
0 Votes"
AntonUdalov-3166 asked MikeMcGranaghan commented

SSMS 18.9.2 error in connection with D365 online TDS endpoint.

Since v18.9.2, SSMS no longer works properly in connection with my D365 Online TDS endpoint. The connection can be established, but as soon as I want to open the tables in object exprorer, I get the message: Invalid table name extended_properties for schema sys. It still works fine for me with SSMS v.17.9.1.

sql-server-general
· 9
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Anton, Thanks for reporting the issue. It turns out that with SSMS 18.9.2 an incompatibility in the Dataverse emulation of the TDS protocol was identified. We are working on a fix from the Dataverse/Dynamics side. And will update this documentation when it is in deployment. https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query

At this point the only option is to go back to 18.9.1 version. We are working to get this fixed as quickly as we can.

Sorry for the pain,
Rich PM Microsoft Dataverse

1 Vote 1 ·

What is D356 Online TDS endpoint? My googling only found this post. And an ad for Dynamics 365. If your question is related to that product, maybe you should add a tag for Dynamics 365.

0 Votes 0 ·

Hi Erland,

The "Dataverse" (Dynamics data platform) Has built a endpoint which emulates the SQL TDS (tabular data stream) protocol over the top of the Dataverse business logic layer. This makes it much easier for applications like Power BI to connect to the Dataverse data stores. Here is a couple articles that might help.

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/view-entity-data-power-bi

Hope this helps,
Rich Dickinson MSFT - PM Microsoft Dataverse

1 Vote 1 ·

In my opinion, it has nothing to do with either Power Platform or D365 directly. As I said, it worked flawlessly in earlier SSMS versions, and also now, if you don't use Object Explorer but send queries from the SQL window. Unfortunately, I don't know exactly which SSMS version I have updated, but I think that this Object Explorer bug only arose from v18.8, because the integration of Azure Data Studio installation was introduced there. The TDS protocol has existed since 1984 and can also be found in Wikipedia. MS provides a read-only stream from Power Platform, more precisely, probably from Dataverse, which also does not contain any system databases. Accordingly, the sys.extended_properties view is also missing (extended-properties-catalog-views-sys-extended-properties), which is empty in most trivial databases. Why the current Object Explorer in SSMS absolutely needs it is a mystery to me.


0 Votes 0 ·

Bug? Yes, if SSMS claims to support D365. Do you have any document that states this?

From my corner, I could just as well claim that it is a shortcoming in D365 (whatever that is) of not supporting sys.extended_properties.

I can't say exactly why SSMS wants to look in sys.extended_properties, but then again, I cannot say why it should not. I believe it stores data for data classification for versions earlier than 2019 in extended properties.

0 Votes 0 ·

Thank you Erland for flagging this issue to us.

Anton, Frank, and others affected by this issue: apologies. SSMS support for the TDS endpoint for Dataverse is still in Preview: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query

We will investigate, and determine where the potential fix needs to be.

0 Votes 0 ·

Hello, Anton. We are in touch with the owners of the TDS endpoint in Dataverse and the investigation is ongoing. Thank you for your patience while we figure this out.

Also, to be clear, the SSMS Support for this feature is still in Preview, as mentioned in the doc I linked to earlier: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query

0 Votes 0 ·

Any luck? I'm having the exact same issue. 17.9.1 works fine

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft rolled back

Hi @AntonUdalov-3166,

I am not familiar with D365, I search this from google, I find this blog.

Your issue is related to Microsoft Dynamics CRM, please ask your issue on Microsoft Dynamics CRM forum, people there will give your help.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FrankvanderSteen-0406 avatar image
0 Votes"
FrankvanderSteen-0406 answered Cathyji-msft commented

I have the exact same error.
I am new to Dynamics 365 and was looking for a way to view tables with SSMS.
I found this artcicle from Microsoft
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query
I installed SSMS 18.9.2 assuming the lastest version supports this.
Like AntonUdalov-3166 I can connect to the database but get an error when I click on Tables to view the table in the database.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FrankvanderSteen-0406,

The classification of this MS document belongs to Power Apps. You may also ask help on Power Apps forum


0 Votes 0 ·
RichardDickinson-1311 avatar image
2 Votes"
RichardDickinson-1311 answered MikeMcGranaghan commented

Hi Anton, Thanks for reporting the issue. It turns out that with SSMS 18.9.2 an incompatibility in the Dataverse emulation of the TDS protocol was identified. We are working on a fix from the Dataverse/Dynamics side. And will update this documentation when it is in deployment. https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query

At this point the only option is to go back to 18.9.1 version. We are working to get this fixed as quickly as we can.

Sorry for the pain,
Rich PM Microsoft Dataverse

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for this tip. I reverted to SSMS 18.9.1 (had to search for the downloaded) and now object explorer in SSMS works as expected.
As an application manager for me a tool like SSMS is vital in supporting an ERP or CRM system.
As longs as Dynamics-365 doesn't offer an alternative, I will stick to SSMS.

0 Votes 0 ·

Thank you very much! This worked for me

0 Votes 0 ·