http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-provision-sql-server/

Provisioning a SQL Server Virtual Machine on Azure

The Azure virtual machine gallery includes several images that contain Microsoft SQL Server. You can select one of the virtual machine images from the gallery and with a few clicks you can provision the virtual machine to your Azure environment.

In this tutorial, you will:

Connect to the Azure management portal and provision a virtual machine from the gallery

1. Log in to the using your account. If you do not have an Azure account, visit .

2. On the Azure Management Portal, at the bottom left of the web page, click +NEW, click COMPUTE, click VIRTUAL MACHINE, and then click FROM GALLERY.

3. On the Create a Virtual Machine page, select a virtual machine image containing SQL Server, and then click the next arrow at the bottom right of the page. For the most up-to-date information on the supported SQL Server images on Azure, see topic in the documentation set.

   NOTE:

   If you have a virtual machine created by using the platform image SQL Server Evaluation edition, you cannot upgrade it to a per-minute paid edition image in the gallery. You can choose one of the following two options:

   • You can create a new virtual machine by using the per-minute paid SQL Server edition from the gallery and migrate your database files to this new virtual machine by following the steps at . Or,

   • You can upgrade an existing instance of SQL Server Evaluation edition to a different edition of SQL Server under the agreement by following the steps at . For information on how to purchase the licensed copy of SQL Server, see .

4. On the Virtual Machine Configuration page, provide the following information:

   • Provide a VIRTUAL MACHINE NAME.
   • In the NEW USER NAME box, type unique user name for the VM local administrator account.
   • In the NEW PASSWORD box, type a strong password. For more information, see .
   • In the CONFIRM PASSWORD box, retype the password.
   • Select the appropriate SIZE from the drop down list.

   NOTE:

   The size of the virtual machine is specified during provisioning: A2 is the smallest size recommended for production workloads. The minimum recommended size for a virtual machine is A3 when using SQL Server Enterprise Edition. Select A3 or higher when using SQL Server Enterprise Edition. Select A6 when using SQL Server 2012 Enterprise for Data Warehousing image. Select A7 when using SQL Server 2014 for Data Warehousing image. The size selected limits the number of data disks you can configure. For most up-to-date information on available virtual machine sizes and the number of data disks that you can attach to a virtual machine, see .

   Click the next arrow on the bottom right to continue.

   

Connecting to the Database Engine from your application

If you can connect to an instance of SQL Server running on an Azure virtual machine by using Management Studio, you should be able to connect by using a connection string similar to the following.

connectionString="Server=<DNS_Name>;Integrated Security=false;User ID=<login_name>;Password=<your_password>;"providerName="System.Data.SqlClient"

For more information, see .

Next Steps

You‘ve seen how to create and configure a SQL Server on an Azure virtual machine using the platform image. When using SQL Server in Azure Virtual Machines, we recommend that you follow the detailed guidance given in the documentation in the library. This documentation set includes a series of articles and tutorials that provide detailed guidance. The series includes the following sections:

• How to migrate SQL Server database files and schema between virtual machines in Azure using data disks

• How to copy SQL Server data and setup files in a data disk from on-premises to Azure using CSUpload
• How to create a base virtual machine on-premises using Hyper-V
• How to create a SQL Server virtual machine in Azure using the existing on-premises SQL Server disk
• How to create a SQL Server virtual machine in Azure using the existing on-premises SQL Server virtual machine
• How to use PowerShell to set up a SQL Server virtual machine in Azure
• How to Use Attached Data Disk to Store Database Files

• Tutorial: Connect to SQL Server in the same cloud service
• Tutorial: Connect to SQL Server in a different cloud service
• Tutorial: Connect ASP.NET application to SQL Server in Azure via Virtual Network

• Tutorial: AlwaysOn Availability Groups in Azure (GUI)
• Tutorial: AlwaysOn Availability Groups in Azure (PowerShell)
• Tutorial: AlwaysOn Availability Groups in Hybrid IT (PowerShell)
• Tutorial: Listener Configuration for AlwaysOn Availability Groups in Azure
• Tutorial: Listener Configuration for AlwaysOn Availability Groups in HybridIT
• Tutorial: Database Mirroring for Disaster Recovery in Azure
• Tutorial: Database Mirroring for Disaster Recovery in Hybrid IT
• Tutorial: Database Mirroring for High Availability in Azure
• Tutorial: Log Shipping for Disaster Recovery in Hybrid IT
• Troubleshooting Availability Group Listener in Azure

• Use PowerShell to Create an Azure VM With SQL Server BI and SharePoint 2010
• Use PowerShell to Create an Azure VM With SQL Server BI and SharePoint 2013
• Use PowerShell to Create an Azure VM With a Native Mode Report Server

[SQL in Azure] Provisioning a SQL Server Virtual Machine on Azure,布布扣,bubuko.com