Skip to main content
Dynamics 365 general forum
Unanswered

Virtual table setup error with managed sql instance

editSubscribe (0) ShareShare
ReportReport
Posted on by 5

When setting up a new table from external data in D365 CE I am able to establish the connection via a sql connection using sql authentication.  This is attempting to connect into a managed sql instance.  It works fine with a single sql server in the same azure environment.

However when I go to create the virtual table I get this error.

pastedimage1683825995028v1.png

The sql user is a full server admin and I've tried adding to the database individually when that didn't work.  Still the same error.

Any advice on how to resolve this would be appreciated.

  • Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: Virtual table setup error with managed sql instance

    Hi DHoyt,

    To create a virtual table, you must have a Microsoft Dataverse license through Power Apps or Microsoft Dynamics 365. Microsoft 365 or Teams licenses can't be used to create virtual tables.

    If so, have you enabled TDS Endpoint (Preview) feature in your environment? You can refer to this link: Connect D365 CRM CDS Database from SQL Server - Dynamics 365 Field Service Community

    pastedimage1684120051859v1.png

    Here are links about create virtual tables using virtual connectors: 

    Create virtual tables using virtual connectors (preview) (Microsoft Dataverse) - Power Apps | Microsoft Learn

    Create a Virtual Table for SQL with the Virtual Connector Provider - YouTube

    Hope it helps you.

    Best Regards,

    Sayen Zhang

  • DHoyt Profile Picture
    DHoyt 5 on at
    RE: Virtual table setup error with managed sql instance

    The database definitely contains tables because they are being used by other apps, and I'm looking at them in SSMS logged in as the same user the connection is using.

  • Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,482 Super User on at
    RE: Virtual table setup error with managed sql instance

    Hi,

    In this case you must check your dataset in SQL Server

    Base on the screen that you have shared, the database which you have the connection does not contain tables.

    Regards,

  • DHoyt Profile Picture
    DHoyt 5 on at
    RE: Virtual table setup error with managed sql instance

    I'm past that part that part, the step I'm getting the error on is when it's attempting to load the tables from the sql managed instance database I'm attempting to connect to.

    pastedimage1683828455272v1.png

  • Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,482 Super User on at
    RE: Virtual table setup error with managed sql instance

    Hi, 

    Have you followed these steps ? 

    Step 1 : Create a connection reference from make.powerappas.com 

    pastedimage1683828076490v1.png

    Step 2 : Configure your connection Reference 

    pastedimage1683828169294v2.png

    Step 3 : Configure the connection settings (Click on New connection) 

    pastedimage1683828228282v3.png

    Hope that's helpful for you ! 

    Tell us if that's work

    Best regards, 

  • DHoyt Profile Picture
    DHoyt 5 on at
    RE: Virtual table setup error with managed sql instance

    The connection reference itself creates just fine, but which connection settings are you referring to?

  • Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,482 Super User on at
    RE: Virtual table setup error with managed sql instance

    Hi DHoyt,

    Have you created the connection reference ? It's work correctly ?

    I think that the error message is due to a connection reference

    Can you create a connection reference and Check the connection settings ?

    Hope that's helpful

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans