[New portal] windows azure Virtual Machine (4) Configure Virtual Machine SQL Server database and firewall rules windows azure PLA

Windows azure platform articles

This chapter describes how to configure a virtual machine database. The default data storage path for SQL 2012 of virtual machine is in disk C.

As I introduced in the previous chapter, disk C can only support a maximum of 127 GB. disk C is very valuable for us. Therefore, for other non-system data, it is reasonable to save it to another drive letter (not a drive D.

1. First we log onto the Windows azure management interface https://manage.windowsazure.com/

2. Select "virtual machines" in the list, find the created sql2012vm1, and log on to the VM using the Remote Desktop Connection.

3. On the Remote Desktop of the VM, choose Start> All prpgrams> Microsoft SQL Server 2012> SQL Server Management studio.

4. Click Connect to log on to SSMs.

5. Click the SQL server instance of the VM and select Properties in the email.

6. In the displayed server properties, click sercurity and select SQL Server and Windows Authentication mode as the Server Authentication mode.

7. In the pop-up server properties, click Database settings. I have observed that data, log, and backup are stored in "C: \ Program Files \ Microsoft SQL Server" by default. Modify the path to the path of the created disk as follows:

8. Create the following folders on the VM Disk: F: \ data, G: \ logs and G: \ Backups

9. Restart the SQL Server service.

10. In SSMs, expand security --> logins --> Find the SA account, right-click, and select Properties

11. In login properties, modify the SA password. Remove the Enforce Password Policy check box.

12. Select status in the list on the left and enabled login.

13. The preceding steps are used to configure the SQL server.

14. Configure Firewall Rules. Because the previousWindows azure platform (2008) uses Windows azure connect to connect cloud applications to a local SQL Server R2 DatabaseThis section describes how to set SQL Server TCP/IP rules. Key steps:

15. In SQL Server Configuration Manager, set the status of TCP/IP to enabled.

16. add firewall rules in the control panel.

17. Add inbound rules

18. Create an inbound rule

19. Allow connection

20. Set the rule name to sqlserverrule and save it.