SSMS To Dataverse can't find the tables I created

(0) Share

Report

Posted on by _Judy_

Hi, I used SSMS to Dataverse sucessfully.

But there have two strange things.

First, I can't find the tables that I created.( Which means the named of tables start with crfb.....)

Second, how to solve the problem that "
Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access
"?

【please open the SSMS_Tables.png 】

Thanks a lot.

Categories:

Microsoft Dataverse with Power Apps

SSMS_Tables.png

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (2)

Report

@_Judy_

1.Make sure your user is assigned system administrator role.

2.you must setup the security role priveliges for your new tables, so if you have custom roles assigned to your account you must set their privileges.

https://docs.microsoft.com/en-us/power-platform/admin/database-security

The other issue you're having is MFA which requires additional verification method for accessing your account .

https://support.microsoft.com/en-us/topic/what-is-multifactor-authentication-e5e39437-121c-be60-d123-eda06bddf661

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @_Judy_ ,

What user are you connecting with using SSMS? It looks like you are utilizing a user that does not have a role assigned in Dataverse to access any tables. When you created the tables you might have been using a Global Administrator user that has System Administrator in Dataverse which automatically has access to all tables but if you are connecting with a different user through SSMS you need to add the custom tables (at least read privilege).

https://docs.microsoft.com/en-us/power-platform/admin/database-security

Was this reply helpful? Yes No
_Judy_ 95 on at

Like (0)

Report

Thank you Mira_Ghaly.
: )
That is helpful.

Was this reply helpful? Yes No
_Judy_ 95 on at

Like (0)

Report

Thank you dpoggemann.
I read the website you give first.
: )

Was this reply helpful? Yes No