blocks|key|4306478|text|将SQL+Management+Studio连接到SQL+Azure的步骤|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4306479|4306480|向Azure门户进行身份验证|ordered-list-item|4306481|单击SQL+|4306482|+on+Servers|4306483|单击要连接到…的服务器的名称|4306484|单击Configure…|4306485|4306486|如果尚未准备就绪，请单击“添加到允许的IP地址”以添加您当前的IP地址(或指定一个您希望连接的地址)，然后单击“保存”|4306487|打开SQL并连接到数据库服务(通常会在默认情况下出现)|unordered-list-item|4306488|4306489|输入完全限定的服务器名称(.database.windows.net)更改为SQL+server身份验证输入首选登录名(如果是新数据库，则为您在创建DB服务器时指定的用户名)输入正确的密码|4306490|单击连接按钮|4306491|4306492|entityMap^0|Z|2|0|0|0|E|0|0|6|0|0|B|0|0|E|0|0|C|0|0|0|1N|0|0|R|0|0|0|2M|0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|18|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|L|3|M|5|I|7|1F|8|@$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|N|3|O|5|I|7|1I|8|@$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|I|7|1L|8|@$9|1M|A|1N|B|C]]|D|@]|E|$]]|$1|R|3|-4|5|6|7|1O|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|1P|8|@$9|1Q|A|1R|B|C]]|D|@]|E|$]]|$1|U|3|V|5|W|7|1S|8|@$9|1T|A|1U|B|C]]|D|@]|E|$]]|$1|X|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|1W|8|@$9|1X|A|1Y|B|C]]|D|@]|E|$]]|$1|10|3|11|5|W|7|1Z|8|@$9|20|A|21|B|C]]|D|@]|E|$]]|$1|12|3|-4|5|6|7|22|8|@]|D|@]|E|$]]|$1|13|3|-4|5|6|7|23|8|@]|D|@]|E|$]]]|14|$]]

Steps to Connect SQL Management Studio to SQL Azure

<ol>
<li>Authenticate to the Azure Portal</li>
<li>Click on SQL Databases</li>
<li>Click on Servers</li>
<li>Click on the name of the Server you wish to connect to…</li>
<li>Click on Configure…

If not already in place, click on ‘Add to the allowed IP addresses’ to add your current IP address (or specify an address you wish to connect from) and click ‘Save’</li>
<li>Open SQL Management Studio and connect to Database services (usually comes up by default)

Enter the fully qualified server name (.database.windows.net)
Change to SQL Server Authentication
Enter the login preferred (if a new database, the username you specified when yuo created the DB server)
Enter the correct password</li>
<li>Hit the Connect button</li>
</ol>

blocks|key|3646078|text|首先，考虑将您计算机的当前IP地址添加到Azure+SQL+Database防火墙，如this官方文档中所述。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3646079|现在获取连接到Azure+SQL数据库所需的连接信息。在接下来的过程中，您需要完全限定的服务器名或主机名、数据库名和登录信息。|3646080|SQL+|3646081|登录Azure+portal.|unordered-list-item|3646082|
|3646083|Navigate到数据库或SQL托管实例页。|3646084|在概述页上，查看单个数据库的服务器名称旁边的完全限定的服务器名称或托管实例的主机旁边的完全限定的服务器名称。要复制服务器名称或主机名，请将鼠标悬停在其上并选择复制图标。|3646085|3646086|3646087|创建防火墙规则并获取服务器信息后，连接到Azure+SQL数据库的步骤如下：|3646088|1.打开SSMS。此时将出现连接到服务器对话框。2.输入服务器信息，如下图所示：|3646089|​|3646090|📷|atomic|3646091|3646092|3.选择“连接到服务器”对话框中的选项。在连接到数据库下拉菜单中，选择您的数据库。|3646093|3646094|3646095|3646096|4.选择Connect。此时将打开对象资源管理器窗口。|3646097|5.要查看数据库的对象，请展开数据库，然后展开数据库。|3646098|3646099|3646100|3646101|有关详细的分步教程，请阅读this文档。|3646102|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/azure/sql-database/sql-database-server-level-firewall-rule|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/71136fcd8bcdb5e58c2f8af545802afa.png|imageAlt|2|https://ask.qcloudimg.com/http-save/yehe-900000/9eff6aba804d0ed47c13a000a3b97c4f.png|3|https://ask.qcloudimg.com/http-save/yehe-900000/c94e62a688fa3cb7882c4a1b74faabb0.png|4|https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms^0|17|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|1|2|0|0|0|0|0|0|1|3|0|0|D|4|4|0^^$0|@$1|2|3|4|5|6|7|20|8|@]|9|@$A|21|B|22|1|23]]|C|$]]|$1|D|3|E|5|6|7|24|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|25|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|26|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|27|8|@]|9|@]|C|$]]|$1|M|3|N|5|J|7|28|8|@]|9|@]|C|$]]|$1|O|3|P|5|J|7|29|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|2A|8|@]|9|@]|C|$]]|$1|R|3|-4|5|6|7|2B|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|2C|8|@]|9|@]|C|$]]|$1|U|3|V|5|6|7|2D|8|@]|9|@]|C|$]]|$1|W|3|X|5|6|7|2E|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|10|7|2F|8|@]|9|@$A|2G|B|2H|1|2I]]|C|$]]|$1|11|3|X|5|6|7|2J|8|@]|9|@]|C|$]]|$1|12|3|13|5|6|7|2K|8|@]|9|@]|C|$]]|$1|14|3|X|5|6|7|2L|8|@]|9|@]|C|$]]|$1|15|3|Z|5|10|7|2M|8|@]|9|@$A|2N|B|2O|1|2P]]|C|$]]|$1|16|3|X|5|6|7|2Q|8|@]|9|@]|C|$]]|$1|17|3|18|5|6|7|2R|8|@]|9|@]|C|$]]|$1|19|3|1A|5|6|7|2S|8|@]|9|@]|C|$]]|$1|1B|3|X|5|6|7|2T|8|@]|9|@]|C|$]]|$1|1C|3|Z|5|10|7|2U|8|@]|9|@$A|2V|B|2W|1|2X]]|C|$]]|$1|1D|3|X|5|6|7|2Y|8|@]|9|@]|C|$]]|$1|1E|3|1F|5|6|7|2Z|8|@]|9|@$A|30|B|31|1|32]]|C|$]]|$1|1G|3|-4|5|6|7|33|8|@]|9|@]|C|$]]]|1H|$1I|$5|1J|1K|1L|C|$1M|1N]]|1O|$5|1P|1K|1Q|C|$1R|1S|1T|-4]]|1U|$5|1P|1K|1Q|C|$1R|1V|1T|-4]]|1W|$5|1P|1K|1Q|C|$1R|1X|1T|-4]]|1Y|$5|1J|1K|1L|C|$1M|1Z]]]]

First consider to add the current IP address of your computer to Azure SQL Database firewall as explained on <a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-server-level-firewall-rule" rel="nofollow noreferrer">this</a> official documentation.
Now get the connection information you need to connect to the Azure SQL database. You'll need the fully qualified server name or host name, database name, and login information for the upcoming procedures.
<ul>
<li>Sign in to the Azure portal.</li>
<li>Navigate to the SQL databases or SQL managed instances page.</li>
<li>On the Overview page, review the fully qualified server name next to Server name for a single database or the fully qualified server name next to Host for a managed instance. To copy the server name or host name, hover over it and select the Copy icon.</li>
</ul>
After creating the firewall rule and get the server information, the steps to connect to an Azure SQL Database are the following:
1.Open SSMS. The Connect to Server dialog box appears.
2.Enter the server information as shown in the following image:
<a href="https://i.stack.imgur.com/CRsNg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CRsNg.png" alt="enter image description here" /></a>
3.Select Options in the Connect to Server dialog box. In the Connect to database drop-down menu, select your database.
<a href="https://i.stack.imgur.com/EFgTe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EFgTe.png" alt="enter image description here" /></a>
4.Select Connect. The Object Explorer window opens.
5.To view the database's objects, expand Databases and then expand your database.
<a href="https://i.stack.imgur.com/jHXi8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jHXi8.png" alt="enter image description here" /></a>
For a detailed step-by-step tutorial please read <a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms" rel="nofollow noreferrer">this</a> documentation.

How do I connect Azure with SQL management if I want to link my database with azure
Connecting to SQL Azure with SQL Management Studio

How to connect azure with SQL manager

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如果要使用SQL management Studio将我的数据库与Azure连接到SQL azure，如何将Azure与SQL管理连接

问如何将azure与SQL管理器连接
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将azure与SQL管理器连接EN