SQL azure (iii) Create an SQL azure Server

1. First, log on to the Windows azure Management User Interface https://windows.azure.com/and enter your account number.

2. Select database --> select your subscription --> click "create server"

3. In the pop-up "Create a new server" window, select the location of the data center where you want to create the server. We select "East Asia" and then click "Next.

4. Enter the Administrator account and password. The Administrator account is the master account used to manage SQL azure)

Note:

5. After the Administrator is created, a window appears in the firewall rules window.

We know that SQL Azure is a relational database on the cloud. That is to say, any machine connected to the Internet can connect to the SQL azure database. However, in some cases, this is not safe. As a user, I only want to connect my own enterprise to the SQL azure database I created; no one except me can connect to this SQL azure database. This function can be implemented by setting SQL azure firewall rules.

Click "add" and select "allow other Windows azure services to access this server ". That is, any Web Service hosted in the Windows azure data center can be connected to the SQL azure database server I created.

Click "add". The "add firewall rule" window is displayed, and the IP address of the current machine is displayed.

I name the rule "enterprise user", and set the start value and end value of the IP range to my current IP address, so that only machines with the current IP Address can access SQL azure server, no one except me can connect.

Then we can see the created firewall rules.

6. After clicking "finish", we can see the previously created SQL azure server in the subscription.

We found that the SQL azure server name is 1kxk... (I have hidden some names). This name is random and cannot be modified.

In this server, there is a default database called Master.

 

In this way, the SQL azure server creation process is complete.

The following is a summary: