Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,380 questions
Azure Synapse Analytics - stitch - short password
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Krzysztof Kurek
6
Reputation points
Hello,
I am having issue with connection between Stitch and Azure Synapse
Stitch:
Azure Synapse:
password: #Af2r47K%v4,T
can you help me to solve this problem? I am trying for couple of days to handle that but each time I got the same error....
I connected to Azure Synapse Analytics via Stitch, but just after successful extraction of data, I got an error in load mode.
stitich user which I am trying to connect to Azure has got grant control parameter over my destination database.
Azure Synapse Analytics
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 75%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vidya Narasimhan 2,126 Reputation points Microsoft Employee2022-04-26T13:51:15.773+00:00 @Krzysztof Kurek Can you please go through this link ? https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/synapse-sql-password-so-secure-that-even-you-cannot-use/ba-p/2118544
As per the link, this issue has been observed in certain scenarios based on the client & protocol you use to connect to the database. There are multiple workarounds listed including checking for special characters in password : [] () , ; ? * ! @ =
-
Krzysztof Kurek 6 Reputation points
2022-04-26T17:25:57.557+00:00 Thank you for your replay. Unfortunately that didn't help for my problem. I changed password into: EUwX9wIJqlYm4Np, got connection with Azure but still duting loading data I am getting same error as before: Password validation failed. The password does not meet policy requirements because it is too short.
-
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator2022-04-30T10:24:30.133+00:00 Hi @Krzysztof Kurek ,
Thankyou for using Microsoft Q&A platform and posting your query.
As I understand your query, you are getting password validation error while trying to establish a connection between Azure synapse analytics and Stitch . Please let me know if my understanding is incorrect.Could you please share more details on how are you generating the credentials. Are you using SAS URL to generate your credentials or creating login and password via SQL pool in synapse .
Could you please share any document which you are following or screenshot of your steps covered so far so that I can share the same with the internal team to escalate this issue? Here is one such blog post I found mentioning the steps for connecting Azure synapse analytics to Stitch:
Please let me know if it is aligned to what you are trying to do?
-
Krzysztof Kurek 6 Reputation points
2022-05-03T08:47:58.133+00:00 @AnnuKumari-MSFT Thanks for replay.
Yes, your understating is correct.I followed with this documentation: https://www.stitchdata.com/docs/destinations/microsoft-azure-synapse-analytics/connecting-a-microsoft-azure-synapse-analytics-destination-to-stitch
I made each step as it's described and used direct connection instead SSH tunnel.
I created "stitch" data base and "stitch" user was created via Microsoft SQL Server Management. -
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
2022-05-05T10:27:00.27+00:00 Hi @Krzysztof Kurek ,
I have raised the query with internal product team. I haven't yet heard back from them . Will be keeping you posted once I get response from their end. Thankyou for your patience! -
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
2022-05-18T15:48:51.577+00:00 Hi @Krzysztof Kurek ,
I am not getting response from internal team on this issue. I would recommend you to kindly raise a support ticket with Microsoft. Here is how you can do the same: Create an Azure support request
Sign in to comment
Sign in to answer