Configure the SQL Server database and firewall rules for virtual machine
In this chapter I will show you how to configure the database for virtual machine. Virtual machine's SQL 2012 default data save path is in the C disk.
I introduced the previous chapter, C disk can only support the largest 127g,c disk space for us is very valuable, so, for other non-system data, save to other disk characters (can not be D disk) is a more reasonable solution.
1. First we login to Windows Azure management interface https://manage.windowsazure.com/
2. Select "Virtual machines" in the list and locate the previously created SQL2012VM1 and log on to the VM using Remote Desktop Connection.
3. In the remote desktop of the VM, select Start--> all prpgrams--> Microsoft SQL Server--> SQL Server Management Studio
4. Direct Click Connect, login SSMs.
5. Click on the VM's SQL Server instance to select Properties for the message.
6. In the pop-up server properties, click Sercurity to select Server Authentication as SQL Server and Windows authentication mode
7. In the pop-up server properties, click Database Settings. I observed that data, log, and backup are saved by default in "C:\Program Files\Microsoft SQL Server". We modified the path to the disk path we created earlier, as follows:
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Servers/cloud-computing/