Connecting to Azure SQL Database using SQL SSMS

To connect to the created database via SSMS, you can follow these steps:

  1. Navigate to the database blade and copy Server name from the overview page.
  2. Open SSMS, paste the name of the server, change the Authentication to SQL Server Authentication, and enter the SQL Server credentials that you entered during SQL Server creation, as shown in the following screenshot:

  1. Once you click on Connect, you will be connected to your database on Azure, as shown in the following screenshot:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset