How to connect azure virtual machine to SQL database Azure

Lucas Escudero 191

I just created a virtual machine in Azure with Windows Server 2022 and I need to create a database within the same resource group but outside of the Windows Server. I need to know how to connect to the database from the server to save the information.

Accepted answer

Alberto Morillo 32,886 Reputation points MVP

2022-05-10T13:07:49.207+00:00

Please follow the steps provided on this quickstart article, on how to create an Azure SQL Database. After that, you can create a firewall rule to add the IP of your Azure VM as a trusted connection using this step-by-step documentation.

Finally, you can install SQL Server Management Studio (SSMS) on the Azure VM and get connected to your Azure SQL Database or you can create an ODBC Data Source to test connectivity.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

1 additional answer

Lucas Escudero 191 Reputation points

2022-05-10T13:11:34.833+00:00

Excellent Albert.
I'll try and let you know how it went.

Thank you very much.
Please sign in to rate this answer.
Alberto Morillo 32,886 Reputation points MVP

2022-05-10T13:14:36.367+00:00

Thank you for visiting Microsoft QA. Anything you need about Azure SQL Database please let us know. Have a good day!

Lucas Escudero 191 Reputation points

2022-05-17T17:46:19.79+00:00

Alberto the connection was a success.
I only have a problem about import and export.
I need to migrate a SQL Server 2017 Express database to the current one I have inside the Azure SQL Server 2019 server.
I can't do it..

Alberto Morillo 32,886 Reputation points MVP

2022-05-17T19:30:34.123+00:00

To better help you, please answer this question to me. Are you trying to migrate from SQL Server Express (on-premise) to Azure SQL 2019 VM? Or are you trying to migrate from SQL Server Express (on-premise) to Azure SQL Database (DTU-model or vCore model)?

Lucas Escudero 191 Reputation points

2022-05-17T19:39:56.96+00:00

I am trying to move 2 databases from SQL Server Express (on premise) to Azure SQL Database 2019 (vCore model)

Alberto Morillo 32,886 Reputation points MVP

2022-05-17T20:27:51.247+00:00

Please forget about the import/export process involving bacpacs. Let me share with you the easiest way to do that migration.

Please use Azure Data Migration Assistant to first perform an initial assessment (optional but recommended) and then the tool will do the migration for you, once you create an empty database on Azure SQL.
Sign in to comment