SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
355 questions
1 answer
while connecting to my sql server sqlcmd is not working
while connecting to my sql server it is showing this error. while investigating with cmd: odbcinst -j it yielded: unixODBC 2.3.7 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA…
asked 2022-02-18T07:32:21.46+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(60.8, 51%, 15%)' 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)
sudharsan moorthy
1
Reputation point
answered 2022-02-18T07:32:50.963+00:00
sudharsan moorthy
1
Reputation point
2 answers
mysql in bash does not work
I installed mysql using installer and when I enter mysql -v in bash it says command not found. I also added environment variable.
asked 2022-02-15T20:42:40.313+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(128, 91%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Radhika b
1
Reputation point
answered 2022-02-16T05:38:44.407+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(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YufeiShao-msft
7,056
Reputation points
1 answer
creating azure for MySQL and setting vcore and GB
In configure option while creating azure for MySQL and setting vcore and GB What actually is happening behind? Is there any size limit in SQL server installation in an on-premises server
asked 2022-02-09T05:18:28.593+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(67.2, 31%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pradhumn Sharma
1
Reputation point
commented 2022-02-15T12:15:12.827+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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,571
Reputation points
2 answers
Cannot view "Databases" tab under Azure Database for MySQL flexible server
This is in regard to the Azure portal. I'm the owner of the subscription in which this service resides and for some reason the "Databases" tab is not available for me. It is visible for other users on the subscription. If I navigate directly…
asked 2022-01-31T16:59:11.5+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(201.6, 12%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joel Marshall
1
Reputation point
commented 2022-02-14T16:25:26.913+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
mySql database table sync between Local and Remote using VB.Net
I am trying to update multiple tables from local mysql database to remote mysql database. Following code I am using for insert/update the remote table. But table is not inserted/updated. Dim tblStr As String = "select id,tablename from…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
712 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,568 questions
asked 2022-02-03T08:38:09.593+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(240, 45%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Ashish Dhar
61
Reputation points
accepted 2022-02-10T11:37:53.27+00:00
Ashish Dhar
61
Reputation points
0 answers
MySQL - The server is currently in starting state. Please wait for the operation to complete.
I stopped my MySQL database on Azure. Now it won't start. It's been hours. It times out and I try again and nothing. I've seen a post on how to restart via command line, but how exactly do I do that? Thanks
asked 2022-02-03T11:52:17.887+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(256, 68%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
lunarsafari
6
Reputation points
commented 2022-02-04T22:26:38.463+00:00
lunarsafari
6
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Mysql connection issue using python
I am facing connection issue using python not sure if i am installing all the required pip.
![](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(163.2, 50%, 25%)' 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)
0 answers
connection errors
when I connect to Azure date studio I find this message. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and…
asked 2022-01-25T09:21:16.387+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(304, 77%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mohammed Almuzaiqer
1
Reputation point
commented 2022-01-28T13:58:46.317+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
1 answer
Issues connecting deployed .NET Core 6 API to Azure Database for MySQL via SSL
Hi, I have a .NET Core 6 API that I've deployed to and hosted on an Azure App Service for Windows. I've also set up an Azure Database for MySQL service as well, and I am attempting to connect these services via SSL. I've set up application insights…
![](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(240, 86%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
0 answers
How do you allow groups to start and stop DBforMySQL servers?
I've tried adding Microsoft.DBforMySQL/flexibleServers/start/action and Microsoft.DBforMySQL/flexibleServers/stop/action to a role which is showing as inherited in the server, as well as all of the other SQL built in roles and my IT group is still unable…
asked 2022-01-27T14:23:43.69+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(310.4, 72%, 40%)' 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)
gollymashed
1
Reputation point
commented 2022-01-27T23:16:42.327+00:00
gollymashed
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Why Azure MySQL database compromised?
This question is being posted as part of an internal effort at Microsoft to share emerging content with the community. A Microsoft employee will be following up with an answer shortly. If you have feedback regarding this issue, we encourage the community…
asked 2022-01-25T16:44:00.03+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, 84%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ahmed Samy Mahmoud
21
Reputation points Microsoft Employee
accepted 2022-01-26T12:00:07.117+00:00
Ahmed Samy Mahmoud
21
Reputation points Microsoft Employee
0 answers
Azure MySQL Flexible Server does not start
I'm facing some issues trying to start a MySQL Flexible Server. To operation returns an error every time ResourceOperationFailure An unexpected error occured while processing the request Is there anything I can do to solve this issue?
asked 2022-01-21T12:51:15.807+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(124.80000000000001, 28.999999999999996%, 22%)' 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)
Renato Rezk
1
Reputation point
commented 2022-01-25T21:16:46.487+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
1 answer
try_convert question to convert nvarchar to datetime
Hi guys, please can you help to convert column eventime (nvarchar) to event_time_date. thanks in advance
asked 2022-01-16T02:11:28.173+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(12.8, 70%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
rdboy_9727
61
Reputation points
commented 2022-01-24T17:17:13.94+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
0 answers
MySQL Database Point In Time Recovery Takes Long
Hi Team, I have started point in time recovery for MySQL database. The database has many schemas and have size around 60GB. It is more than 12 hours now. Still it is in process. Any idea how I can check progress? Or how I can check if it is…
asked 2022-01-21T16:28:22.997+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(204.8, 53%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Anant Trivedi
1
Reputation point
commented 2022-01-24T16:19:06.857+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
what is the primary objective of data security controls?
The primary objectives of data security controls are to prevent, detect and provide corrective measures for the risks and threats faced by organizational data but how?
asked 2022-01-18T14:49:03.023+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(144, 77%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Walacor Corporation
1
Reputation point
commented 2022-01-20T17:29:48.81+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
Python error connecting to Azure MySQL
I have setup Azure MySQL 5.3 Flexible along with setting up my IP to access. I created a connection from MySQL workbench and was able to create a table. When trying to connect via my Python script from my local machine i keep getting the below error. I…
asked 2022-01-17T13:21:11.177+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, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES2%3C/text%3E%3C/svg%3E)
SC-2022
1
Reputation point
commented 2022-01-20T16:40:28.95+00:00
GeethaThatipatri-MSFT
27,102
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Convert JSON file to DB file
Dear Sir or Madam, Is it possible to convert a JSON file into a DB file? If yes, I would be very grateful for an answer with a possible solution. Best regards
![](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(249.60000000000002, 90%, 34%)' 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)
2 answers
One of the answers was accepted by the question author.
Empty query text in Query Performance Insight
For the last 2 days the Query text in Query performance Insight is empty. This make the performance analysis not useful because we don't know in which query we have delays.
asked 2021-12-16T07:33:06.467+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, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Petros Vassiliou
26
Reputation points
commented 2022-01-13T18:18:21.417+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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,671
Reputation points Microsoft Employee
0 answers
How to connect to mySql remotly
I created an Azure Database for MySQL and I am trying to connect to the database with node js. But when I try to connect it shows me this error: code: 'ER_SECURE_TRANSPORT_REQUIRED', errno: 3159, sqlMessage: 'Connections using insecure transport…
asked 2022-01-07T11:02:44.287+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(67.2, 34%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vojta Simek
1
Reputation point
commented 2022-01-11T21:38:32.94+00:00
Saurabh Sharma
23,671
Reputation points Microsoft Employee
0 answers
Unable to restart mysql server for operation loop
Today i tried to add a new firewall rule but the task was never completed. At this moment I am not able to restart the server because It seems that the operation "Write new firewall rules" is started but never ended. How can i stop that…
asked 2022-01-11T14:43:40.893+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(227.2, 63%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vincenzo Morelli
1
Reputation point
commented 2022-01-11T20:25:58.833+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee