Forum Discussion

UBdev's avatar
UBdev
Copper Contributor
Apr 07, 2023

Getting error when dataverse connecting through MS SQL SERVER 2022

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-...

 

If you anyone have answer. Please help me.

Thanks

 

 

1 Reply

  • LainRobertson's avatar
    LainRobertson
    Silver Contributor

    UBdev 

     

    This isn't really the correct place to ask about the Dataverse.

     

    While you can access the Dataverse via the TDS endpoint, SQL Server and the Dataverse are still very different beasts.

     

    As to the error itself, there's no way we can help you with this one other than to say that it's probably quite correct.

     

    Perhaps run a simple "SELECT TOP 1 * FROM [yourDataverseTableName]" and verify that you haven't made a spelling error with that column name.

     

    Otherwise, you'd have to leverage another approach such as using the Dataverse REST calls or the Power Platform's native environment explorer to try and confirm where the discrepancy lies.

     

    Cheers,

    Lain

Resources