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

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.