Skip to main content
Dynamics 365 Community / Forums / Finance forum / "Error SQL71626: SQL C...
Finance forum
Suggested answer

"Error SQL71626: SQL CERTIFICATE " while exporting data from Tier 1

editSubscribe (1) ShareShare
ReportReport
Posted on by Community member 21
/ ***Error exporting database : one or more unsupported elements were found in the schema used as a part of data package.
/Error SQL71626: SQL CERTIFICATE ------- is not support in microsoft azure sql v12/  
I got this error while exporting data from Tier 1( cloud hosted environment )
through Powershell.
 
AxDB.bacpac  file is generated in the Temp folder but as you can see in below image 
 
after validating schema those error occured and then file is generated. 
Thanks for your support in Advance
Categories:
Financial Management
Administration and Setup
Data Integration
Attachments
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 3,905 User Group Leader on at
    "Error SQL71626: SQL CERTIFICATE " while exporting data from Tier 1
    Hi,
     
    Try to execute this sql code and redo
    -----Drop Keys and Certificate----------------------

DROP SYMMETRIC KEY SymmetricKeyName;  
GO
DROP CERTIFICATE ISFCertificate  
go
DROP MASTER KEY
Go
    Best regards,
    Mohamed Amine MAHMOUDI
  • Judy Profile Picture
    Judy Microsoft Employee on at
    "Error SQL71626: SQL CERTIFICATE " while exporting data from Tier 1
    Hi, please refer to the link regarding the same error message to see if it can help:

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 222,733 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans