{"id":19686,"date":"2021-06-26T09:08:12","date_gmt":"2021-06-26T09:08:12","guid":{"rendered":"https:\/\/dbtut.com\/?p=19686"},"modified":"2021-06-26T13:05:45","modified_gmt":"2021-06-26T13:05:45","slug":"how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/","title":{"rendered":"How To Connect Azure Database From SQL Management Studio and from Azure Portal"},"content":{"rendered":"<p>We will learn how to connect azure database from sql management studio and from azure portal in this article.<\/p>\n<ol>\n<li>How to connect to azure sql database from azure portal<\/li>\n<li>How to connect azure database from sql management studio<\/li>\n<\/ol>\n<h2>How To Connect to Azure SQL Database from Azure Portal<\/h2>\n<h3>Step1:<\/h3>\n<p>Select Query Editor(preview) from the dmcdbpshell window.<\/p>\n<p id=\"jAmoveb\"><img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"391\" class=\"size-full wp-image-19687 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6e90e4a306.png\" alt=\"\" \/><\/p>\n<h3>Step2:<\/h3>\n<p>Sign in at the Query Editor screen.<\/p>\n<p id=\"OlMGufL\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"362\" class=\"size-full wp-image-19688 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6e94080c06.png\" alt=\"\" \/><\/p>\n<h3>Step3:<\/h3>\n<p>In the Query Editor screen, type the following query.<\/p>\n<p>Let&#8217;s create a new orders table<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE orders\r\n(\r\nOrderID INT IDENTITY(1, 1) PRIMARY KEY,\r\nAmount INT, sales MONEY\r\n);<\/pre>\n<p>Let&#8217;s populate the orders table with sample data.<\/p>\n<pre class=\"lang:default decode:true\">;\r\nWITH t1\r\nAS (SELECT 1 AS a\r\nUNION ALL \r\nSELECT 1),\r\nt2\r\nAS (SELECT 1 AS a\r\nFROM t1\r\nCROSS JOIN t1 AS b),\r\nt3\r\nAS (SELECT 1 AS a\r\nFROM t2\r\nCROSS JOIN t2 AS b),\r\nt4\r\nAS (SELECT 1 AS a\r\nFROM t3\r\nCROSS JOIN t3 AS b),\r\nt5\r\nAS (SELECT 1 AS a\r\nFROM t4\r\nCROSS JOIN t4 AS b),\r\nnums\r\nAS (SELECT Row_number()\r\nOVER (\r\nORDER BY (SELECT NULL)) AS n\r\nFROM t5)\r\nINSERT INTO orders SELECT n,\r\nn * 10\r\nFROM nums;\r\nGO\r\nSELECT TOP 10 * from orders;<\/pre>\n<h3>Step4:<\/h3>\n<p>Click Run to execute the query.<\/p>\n<p id=\"pRLmeDv\"><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"98\" class=\"size-full wp-image-19689 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6ea9a2ccb7.png\" alt=\"\" \/><\/p>\n<h3>Step5:<\/h3>\n<p>After the query runs, you will see the following output.<\/p>\n<p id=\"ykeebiL\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"246\" class=\"size-full wp-image-19690 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6ead87ed51.png\" alt=\"\" \/><\/p>\n<h2>How To Connect to Azure SQL Database from SQL Server Management Studio<\/h2>\n<p>We will be connecting and querying an Azure SQL Database from SQL Server Management Studio.<\/p>\n<ol>\n<li>Open SQL Server Management Studio, select &#8220;Database Engine&#8221; if the Server Type is not selected on the &#8220;Connect to Server&#8221; screen.<\/li>\n<li>You can see the Server Name information in the Azure portal in Azure SQL Database in the owerview window.<img loading=\"lazy\" decoding=\"async\" width=\"633\" height=\"140\" class=\"size-full wp-image-19691 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6eb926b7e7.png\" alt=\"\" \/><\/li>\n<li>Select SQL Server Authentication as Authentication Type<\/li>\n<li>Enter your login information for Azure SQL Server and press Connect.<\/li>\n<\/ol>\n<p id=\"LaDRTMZ\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"320\" class=\"size-full wp-image-19692 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6ebe46a0e8.png\" alt=\"\" \/><\/p>\n<p>If you get an error stating that your client&#8217;s IP address does not have access to the server, you need to add the IP Address of the system you want to connect to in Azure SQL Server Firewall. I will explain this step in detail later. If you do not see a screen asking you to enter your IP address, the IP address of the system you want to connect to has been added to Azure SQL Server Firewall.<\/p>\n<p>If your operation is successful, you will be connected to Azure SQL Server as follows. If you do not see the following screen even though you are connected, press F8 and the Object Explorer screen will appear.<\/p>\n<p id=\"aOSnVOS\"><img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"213\" class=\"size-full wp-image-19693 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/img_60d6ecb089aef.png\" alt=\"\" \/><\/p>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_19686\" class=\"pvc_stats all  \" data-element-id=\"19686\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We will learn how to connect azure database from sql management studio and from azure portal in this article. How to connect to azure sql database from azure portal How to connect azure database from sql management studio How To Connect to Azure SQL Database from Azure Portal Step1: Select Query Editor(preview) from the dmcdbpshell &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_19686\" class=\"pvc_stats all  \" data-element-id=\"19686\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1414,"featured_media":19704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[10403,3],"tags":[10461],"class_list":["post-19686","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-azure","category-mssql","tag-how-to-connect-to-azure-sql-database-from-azure-portal"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Connect Azure Database From SQL Management Studio and from Azure Portal - Database Tutorials<\/title>\n<meta name=\"description\" content=\"We will learn how to connect azure database from sql management studio and from azure portal in this article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Connect Azure Database From SQL Management Studio and from Azure Portal - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We will learn how to connect azure database from sql management studio and from azure portal in this article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-26T09:08:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-26T13:05:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"687\" \/>\n\t<meta property=\"og:image:height\" content=\"341\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\"},\"author\":{\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\"},\"headline\":\"How To Connect Azure Database From SQL Management Studio and from Azure Portal\",\"datePublished\":\"2021-06-26T09:08:12+00:00\",\"dateModified\":\"2021-06-26T13:05:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\"},\"wordCount\":322,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg\",\"keywords\":[\"how to connect to azure sql database from azure portal\"],\"articleSection\":[\"Azure\",\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\",\"name\":\"How To Connect Azure Database From SQL Management Studio and from Azure Portal - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg\",\"datePublished\":\"2021-06-26T09:08:12+00:00\",\"dateModified\":\"2021-06-26T13:05:45+00:00\",\"description\":\"We will learn how to connect azure database from sql management studio and from azure portal in this article.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg\",\"width\":687,\"height\":341},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Connect Azure Database From SQL Management Studio and from Azure Portal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\",\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"caption\":\"\u00c7a\u011flar \u00d6zen\u00e7\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Connect Azure Database From SQL Management Studio and from Azure Portal - Database Tutorials","description":"We will learn how to connect azure database from sql management studio and from azure portal in this article.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/","og_locale":"en_US","og_type":"article","og_title":"How To Connect Azure Database From SQL Management Studio and from Azure Portal - Database Tutorials","og_description":"We will learn how to connect azure database from sql management studio and from azure portal in this article.","og_url":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/","og_site_name":"Database Tutorials","article_published_time":"2021-06-26T09:08:12+00:00","article_modified_time":"2021-06-26T13:05:45+00:00","og_image":[{"width":687,"height":341,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg","type":"image\/jpeg"}],"author":"\u00c7a\u011flar \u00d6zen\u00e7","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u00c7a\u011flar \u00d6zen\u00e7","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/"},"author":{"name":"\u00c7a\u011flar \u00d6zen\u00e7","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab"},"headline":"How To Connect Azure Database From SQL Management Studio and from Azure Portal","datePublished":"2021-06-26T09:08:12+00:00","dateModified":"2021-06-26T13:05:45+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/"},"wordCount":322,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg","keywords":["how to connect to azure sql database from azure portal"],"articleSection":["Azure","MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/","url":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/","name":"How To Connect Azure Database From SQL Management Studio and from Azure Portal - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg","datePublished":"2021-06-26T09:08:12+00:00","dateModified":"2021-06-26T13:05:45+00:00","description":"We will learn how to connect azure database from sql management studio and from azure portal in this article.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/06\/connectazuressms-1.jpg","width":687,"height":341},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2021\/06\/26\/how-to-connect-azure-database-from-sql-management-studio-and-from-azure-portal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Connect Azure Database From SQL Management Studio and from Azure Portal"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab","name":"\u00c7a\u011flar \u00d6zen\u00e7","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","caption":"\u00c7a\u011flar \u00d6zen\u00e7"},"url":"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/19686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1414"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=19686"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/19686\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/19704"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=19686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=19686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=19686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}