How to connect to SQL on Windows Azure Pass

1 signing in to Windows Azure China Edition: Https://account.windowsazure.cn/Home/Index

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/57/85/wkiol1sc2_2jfg_maaikbzapx68528.jpg "height=" 459 "/>

2 Click on "SQL Database"--"new"

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/57/85/wkiol1sc2_6g9ygiaafl7hw8gim415.jpg "width=" 744 "height=" 426 "/>

3 Select "Custom Create"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/57/88/wkiom1sc21cs3jnhaadnunpbk5u973.jpg "height=" 414 "/>

4 Enter the SQL name and select Create Server

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/57/85/wkiol1sc2__t-y1kaahdex5iqya989.jpg "height=" 619 "/>

5 Set the login name and password, select the region. The mark account here is equivalent to the SA account in SQL.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/57/88/wkiom1sc21ltt7h2aadi6hmzhpw815.jpg "height=" 590 "/>

6 Click the SQL1 database after creation is complete

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/57/88/wkiom1sc21lac3wnaae2cpu8hmc149.jpg "height=" 424 "/>

7 The FQDN of the replication server, the port is the default 1433

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/57/88/wkiom1sc21oha-rdaahspurheo0676.jpg "height=" 420 "/>

8 Using SQL Administration tools locally to connect to a database on Azure

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/57/85/wkiol1sc3ahzukg-aagsn9gjmg4289.jpg "height=" 456 "/>

9 An error that occurs when an IP address is not allowed is just a security mechanism.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/57/85/wkiol1sc3alxsldyaahzsfa3dga358.jpg "height=" 260 "/>

10 back to the Azure interface, click on "SQL Database"--"server"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/57/88/wkiom1sc21tx6s9saaeykosrjic670.jpg "height=" 441 "/>

11 Select the configuration, add the currently allowed public IP address, click Save.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/57/88/wkiom1sc21wwhsvnaafxa-96wd8863.jpg "height=" 444 "/>

12 is done!

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/57/88/wkiom1sc21xzdifqaaelgzg1qgc402.jpg "height=" 373 "/>

This article is from the "Month Missing" blog, please be sure to keep this source http://yueque.blog.51cto.com/4580340/1596178

How to connect to SQL on Windows Azure Pass