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.
4,668 questions
1 answer
Facing error for MySQL connectivity from Synapse Linked Service
I'm trying to created a Linked Service to Mysql Server hosted on AWS Server. But it is giving me: ERROR [08001] [Microsoft][MySQL] (1004) The connection has timed out while connecting to server: 10.xx.xx.xx. at port: 3306. with Error Code 9603. My other…
asked 2024-03-21T11:49:26.41+00:00
![](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, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sudarshan Bhamare
55
Reputation points
commented 2024-03-26T05:18:00.88+00:00
Sudarshan Bhamare
55
Reputation points
1 answer
Blue Green Deployment of Docker Compose Azure App
I have a docker compose-based Azure App that makes use of Azure MySql Flexible Server and credentials stored in Azure Keyvault. I am wondering if there are any guidelines for blue-green deployment of Docker Compose Azure App. I know Azure App's…
asked 2024-03-25T07:44:05.7566667+00:00
![](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(156.8, 33%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUR%3C/text%3E%3C/svg%3E)
Umer Rashid
85
Reputation points
answered 2024-03-25T08:21:01.2333333+00:00
Deepanshukatara-6769
7,905
Reputation points
0 answers
Azure MySQL flexible server not responding after failed attempt of server version upgrade
I tried to upgrade MySQL flexible server from version 5.7 to 8.0 but process got stuck(was keep on running for more than 60min), so I had to cancel the deployment, but after cancelling, I'm not able to update anything in server like updating server…
asked 2024-03-18T17:07:39.7333333+00:00
![](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(3.2, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dakornarayan Chandra
5
Reputation points
commented 2024-03-19T17:44:58.48+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
MySQL Flexible Servers Deployment is taking a long time/ Unable to delete VNet/Subnet due to serviceAssociationLinks.
Hi, I'm trying to deploy MySQL Flexible Servers, but it's taking too long. As of this writing, the deployment has been running for about an hour. I have successfully deployed before. This time, the difference is that the MySQL server is deployed in a…
asked 2024-03-19T06:13:09.5833333+00:00
![](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(233.6, 86%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Al
21
Reputation points
answered 2024-03-19T08:44:37.1466667+00:00
![](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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
The resource write operation failed to complete successfully, because it reached terminal provisioning state
Hi, I'm on a free tier, and I am trying to deploy a MySQL Flexible server database in East US, and I keep hitting this error: The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'. (Code:…
1 answer
One of the answers was accepted by the question author.
On demand backups for MySQL flexible server. 50 limitation question.
I understand that we have a limit of 50 on demand backups per server. But since the backups have a 7 day retention, does that mean as these backups drop off, that count is restored back? Let's say I run 5 on demand backups on a certain day. This leaves…
asked 2024-02-29T20:19:45.25+00:00
![](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(214.4, 26%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike Huffman
20
Reputation points
commented 2024-03-13T16:42:38.98+00:00
![](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(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
How to fix "Your app is currently in read only mode because new Node programming model experience is in preview."
Function app says "Your app is currently in read only mode because new Node programming model experience is in preview." Running v4 and node 18. Using azure blob storage trigger. Metrics show function being called on file upload, however…
asked 2024-02-18T23:07:04.8866667+00:00
![](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(224.00000000000003, 1%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Danny Bui
5
Reputation points
commented 2024-03-12T17:33:05.19+00:00
Pramod Valavala
20,611
Reputation points Microsoft Employee
1 answer
Installing Azure Data studio and SQL Management studio on VM
I have VM with Windows 10 Enterprise. It is 64 bit OS and processer I would like to install Azure Data Studio or SQL management studio do I need to install both? if yes could you please share appropriate links to download and install, thank you which…
asked 2023-10-16T06:34:52.09+00:00
![](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(214.4, 77%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sns
9,226
Reputation points
commented 2024-03-12T16:20:46.9566667+00:00
Jennifer2112
0
Reputation points
1 answer
¿Por qué no aparece mi suscripción gratuita a Azure para poder crear una base de datos?
Hola, no aparece mi suscripción gratuita de azure al momento de querer crear una base de datos MySQL. ¿Qué puedo hacer?
asked 2024-03-07T20:00:53.2366667+00:00
![](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(89.60000000000001, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Luis Alberto Alemán Díaz
0
Reputation points
answered 2024-03-11T12:35:27.99+00:00
![](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(307.2, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Claudia Dos Santos Haz (CONCENTRIX CORPORATION)
1,010
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to do ADF transformation on Specific Rows to Columns
Hello All, I have a transformation that I have tried a few dataflow scenarios that do not yield the results needed. We have a file that exports data like the below sample: COL1****COL2Manufacturing1-Jan-23Baked GoodsLemon CookiesRaw…
![](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(246.4, 38%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
Unable to connect to mysql flexible server through Vmss.
How can I establish a connection between my MySQL Flexible Server and VM Scale Set (VMSS)? I'm encountering an issue where I'm unable to connect to the MySQL Flexible Server from my VMSS. The error message I'm receiving is "Unable to connect to…
asked 2024-03-06T14:30:37.48+00:00
![](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(137.6, 60%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hrishikesh Mudaye
0
Reputation points
edited a comment 2024-03-08T17:29:20.48+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Deployment of MySQL flexible server failed
I am trying to create a MySqlFlexibleServer. However, after going through the wizard, it fails at the deployment step without giving any good feedback. I have no idea how I can fix it. I have tried to repeat the process in different times without any…
asked 2024-03-08T15:27:18.92+00:00
![](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(278.4, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sara
20
Reputation points
commented 2024-03-08T17:00:07.7533333+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
2 answers
How to change default_authetication_plugin parameter in Azure MySQL DB
Hello Team, My database error log is getting flooded with below warning messages. I am not able to change the default_authentication_plugin parameter to handle this problem like how we do in the MySQL standalone server. [Warning] [MY-013360] [Server]…
asked 2024-03-07T06:43:22.28+00:00
![](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(294.40000000000003, 43%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Srikar Gondesi - UAS Database Administrator
85
Reputation points
answered 2024-03-08T08:18:42.2+00:00
ShaktiSingh-MSFT
14,376
Reputation points Microsoft Employee
2 answers
Azure Data Factory: denied permission when trying to insert data in Azure MySql8
I have a pipeline to introduce data in Azure Database for MySql from Snowflake, all seems to be ok when I go to the preview data. But when I run the Data Flow activity, the system shows this error: Job failed due to reason: at Sink 'outmysql': CREATE…
![](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(208, 40%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
How to fix delayed TDS version error with pymssql when running backend app service
I have an issue when deploying my python flask application, it connects to an azure db using pymssql. For about an hour after deployment, there are no issues and the flask server works as intended. However, after a bit this error starts to show up and…
asked 2024-03-06T22:24:10.2+00:00
![](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(172.8, 51%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jakob B
0
Reputation points
answered 2024-03-07T04:57:34.1633333+00:00
ShaktiSingh-MSFT
14,376
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
To turn off GTID replication in Azure MySQL Database
Hello Team, I am trying to remove GTID data-in replication from my Azure MySQL database instance. I ran the related stored procedure to stop the replication but I am not able to turn off below variables. gtid_mode enforce_gtid_consistency Error: …
asked 2024-03-04T10:38:48.5033333+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
answered 2024-03-05T02:36:35.74+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why do I need to create a support request for already enabled region for my Azure Database MYSQL
Hello Team, Just out of curiosity, why do I have to request a region access if I had the access to a particular region few months back. Recently while deploying Azure database MySQL, I had access to the WE region however I had to raise a request and get…
asked 2024-02-29T12:09:00.07+00:00
![](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(64, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Learn Cloud
80
Reputation points
edited the question 2024-03-04T19:37:55.25+00:00
deherman-MSFT
35,481
Reputation points Microsoft Employee
2 answers
SQL MANAGED INSTANCE STORAGE LIMIT INCREASE
Can we request for an increase of Storage capacity of a SQL Managed Instance Of General pupose of with Hardware configuration of Standard series of 16 TB storage capacity. The storage capacity has reached 16 TB now.Kindly let us know if we can request…
asked 2024-02-27T13:30:27.1133333+00:00
![](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(48, 16%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tamil Selvan M
5
Reputation points
commented 2024-03-04T16:51:51.4433333+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Troubleshooting Connection to Azure Flexible Server with MySQL Workbench
Hello, I'm having trouble connecting to an Azure Database for MySQL flexible server using MySQL Workbench. Even though my IP is whitelisted, and the port is allowed in my Windows firewall settings, I'm still unable to connect. For more information,…
asked 2024-03-01T12:14:14.8133333+00:00
![](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(102.4, 33%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Samer Hajjar
0
Reputation points
commented 2024-03-01T17:21:21.04+00:00
TP
83,711
Reputation points
2 answers
unable to delete a virtual network in Azure due to a service association link
I'm being billed at least $50 a month for a virtual network which I don't use and am unable to delete. It appears the issue is a subnet is assigned to Microsoft.DBforMySQL/flexibleservers. If I try to delete the subnet, or assign the subnet delegation…
asked 2024-02-13T14:35:59+00:00
![](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(140.8, 94%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Yosef
0
Reputation points
commented 2024-02-29T21:27:44.5666667+00:00
![](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(134.4, 59%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChaitanyaNaykodi-MSFT
24,656
Reputation points Microsoft Employee