VERY WEIRD error. What is going on?

Hi Anonymous,

Thanks for reaching out to the Microsoft fabric community forum.

To resolve the "InvalidCredentialFormat - Signature does not match" error when connecting your On-Premises DB through a data pipeline in Microsoft Fabric, follow the below steps:

• To transfer data from an on-premise database to a fabric database, it is necessary to add a gateway. Please find the link to download the standard gateway below.

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-monthly-updates

• Ensure the On-Premises Data Gateway is installed and configured correctly, and gateway is registered under the correct workspace and can access the On-Prem DB. Go to Fabric > Manage Gateway and confirm the gateway is online.

• Verify that the credentials used in the data pipeline are exactly the same as those in your connections page.
• Ensure proper authentication type (SQL Authentication, Windows Authentication, etc.) is used consistently.
• For my part, I have implemented Windows Authentication.

• In the Data Pipeline UI, go to the source dataset and ensure the credentials are re-entered or refreshed. Test the connection within the pipeline setup to verify the authentication works.

In destination add your sql database which already exists in your workspace.

• Then validate and run the copy data activity. After running the pipeline you can see you data which you copied from SSMS to fabric sql.

You can see the below image where I got successfully implemented it.

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

If this post helps, then please give us 'Kudos' and consider 'Accept it as a solution' to help the other members find it more quickly.

Thank you.