0

In my SQL MI i have a ad group (called Group A) which was already assigned to the Active Directory Admin through Portal. I'm trying to update/replace that with a new group called Group B.

When I tried I get the error like

{"error":{"code":"ServerPrincipalAlreadyExists","message":"The requested server principal already exists on Managed Instance. Consider dropping the server principal and retrying operation."}}.

When I tried to add another new group called Group C it works. But the issue with Group B still exist

Questions:

  • How come the new group B has been already exists on the MI ?
  • How to remove the service principal ?

P.S I tried by removing the existing group from the active directory admin and add the new group B still the same issue

Jayendran
  • 9,638
  • 8
  • 60
  • 103

1 Answers1

1

You need to check whether group B exists among service_principals and drop it. You can check that by looking at server_principals table https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-server-principals-transact-sql?view=sql-server-ver15. If it exist you need to drop sp(probably you added it as a login and thus it is server principal).

Andrija Veljkovic
  • 26
  • 3