Forum Discussion
VERY WEIRD error. What is going on?
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!
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.
4 Replies
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.
Hi Anonymous ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi Anonymous,
I wanted to follow up on our previous suggestions regarding error - "InvalidCredentialFormat - Signature does not match". We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.