Getting error when dataverse connecting through MS SQL SERVER 2022

(0) Share

Report

Posted on by UBDev

HI, I am getting error message

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

"Invalid column name 'is_dropped_ledger_column'."
RequestId: TDS;1e3443e5-c370-40a1-98a6-043ec6d6cdd7;10
Time: 2023-04-07T05:51:35.1090605Z (Microsoft SQL Server, Error: 40000)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-40000-database-engine-error

If you anyone have answer. Please help me.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@UBDev

Are you trying to establish a connection through SQL server management studio to Dataverse?

Are you getting the error while connecting or while executing a query?

Was this reply helpful? Yes No
ubdeve 2 on at

Like (0)

Report
Copy link

Link copied!

I am trying to establish a connection through SQL server management studio to Data verse and getting the error while executing a query.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@UBDev @ubdeve

As from the error message looks like the column name is incorrect, can you paste your whole query maybe I could help more.

Was this reply helpful? Yes No