VERY WEIRD error. What is going on?

[blackflag]

I have a connection in Fabric to my On prem db. It works and is online.

When I try to connect to the same connection via a data pipeline in Fabric I get the following error:

An exception occurred: InvalidCredentialFormat - Signature does not match

How is it that in my connections page, the connection works and everything is OK, but when I try to connect via the data pipeline app in Fabric it throws an error?

For reference, I'm trying to set up a copy activity to copy data from my on prem db to Fabric SQL.

Thanks in advance for the help guys! 

[v-tsaipranay]

Hi @blackflag,

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.