Share via

Data Discovery and classification using SSMS ask me MIP

Alen Cappelletti 1,047 Reputation points
2023-04-01T13:07:10.58+00:00

Hi,

in the past I have already used this feature to do some tests. Now after months I really have to use it.
Following the classic data discovey procedure, an authentication window pops up (show below).

I don't understand why this appends 'cause on other machines I don't have this kind of windows.
I got after few seconds presented my report.

User's image

I still tried to authenticate with the corporate account but I'm not getting any correct data output.

User's image

Thanks Alen

SQL Server | Other
0 comments
Accepted answer
  1. Ronen Ariely 15,206 Reputation points
    2023-04-02T00:01:16.2233333+00:00

    Hi,

    It seems the same as if you clicked on "Set Microsoft Information Protection Policy" instead of "Classify Data".

    Note! I did not succeed to reproduce the issue using simple steps (I did as explained below using cheat), but maybe this will help solve the issue.

    Option 1: Make sure you clicked "Classify Data" and not "Set Microsoft Information Protection Policy"

    Option 2: Maybe Someone configured (probably tested this new feature) the Microsoft Information Protection (MIP) and there is an issue with the authentication which was used so the SSMS keep asking you to set it since the database uses this remove MIP Policy.

    👉 Try: Try to reset MIP User's image

    Note! there is a bug. If you reset the MIP then it is clear all labels instead of actually reset it to the default. As a result, if you try to "Set Microsoft Information Protection Policy" again, then you will probably get the error:

    Label policy did not contain data, NoPolicyError.Category=SyncFile, NoPolicyError.Category=SyncFile

    The solution is to use the SQL Data Discovery and Classification once and check the Classify Data.. No need to save anything: In the SSMS Object Explorer, select the database that you would like to classify and choose Tasks > Data Discovery and Classification > Classify Data....

    In your case there should be no issue since this is what you want to do anyway.

    Option 3: (should not happen in regular use but maybe someone cheat) Your SSMS menu is not set well, as a result of a bug or manual changes. This is the type of things, which I do to my teams many times in April 1. It is very simple to change the nam in the menu and the order of command to make this play like this that the "Classify Data" actually behaves like "Set Microsoft Information Protection Policy" and vise Vera 🤪

    Try to bring more information is nothing helped you

    https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver16&tabs=t-sql&WT.mc_id=AZ-MVP-5001699

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Madhumita Tripathy 81 Reputation points Microsoft Employee
    2023-04-03T14:54:18.7866667+00:00

    Ronen Ariely has already answered the question. Someone had tried setting MIP (Microsoft Information Protection) policy in past hence when you click on the Classify Data menu, It asks for authentication to Microsoft 365 (Microsoft Purview compliance portal). If you are not using MIP feature then you can reset the Information protection policy to default which is SQL information protection policy by clicking on "Reset Information Protection Policy to Default". Or if you have a custom information protection policy then select "Set Information Protection File" option.

    https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver16&tabs=t-sql

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.