能否无需Azure VM直接将MSDN订阅的SQL Server 2016镜像下载至Azure文件存储？

Absolutely, you can skip the local download step and transfer the SQL Server 2016 Developer ISO straight to your Azure File Share without spinning up an Azure VM. Here are two reliable, straightforward methods to get this done:

Method 1: Use AzCopy (Recommended for Large Files) #

AzCopy is Azure's high-performance command-line transfer tool, and it’s ideal for this scenario—it supports direct cross-service transfers, handles large files seamlessly, and includes built-in retry logic for interruptions.

Steps: #

1. Grab the direct MSDN download URL:

   • Log into your MSDN subscription portal, navigate to the SQL Server 2016 Developer download page.
   • Instead of clicking "Download", right-click the download button (or use your browser’s developer tools to capture the actual download request URL) and copy the direct link. Note: MSDN download links are temporary, so copy it right before running the command.

2. Run the AzCopy transfer command:
   Replace the placeholders below with your actual values:

   azcopy copy "https://msdn-direct-download-url-here.iso" "https://your-storage-account.file.core.windows.net/your-file-share/SQLServer2016Developer.iso" --recursive=false
   

3. Handle authenticated MSDN links (if needed):
   Some MSDN download links require session cookies to validate your subscription. If you hit an access error, capture the relevant cookies from your browser (via the Network tab in developer tools) and add the --cookie parameter:

   azcopy copy "https://msdn-direct-download-url-here.iso" "https://your-storage-account.file.core.windows.net/your-file-share/SQLServer2016Developer.iso" --recursive=false --cookie "MSDN-Session-Cookie=YourCookieValue; AnotherCookie=Value"
   

Method 2: Use PowerShell (For Scripting Workflows) #

If you prefer PowerShell, you can combine Invoke-WebRequest with Azure PowerShell modules to stream the file directly to Azure Files. This works well for scripting, though it’s better suited if you have enough system memory to handle the ISO temporarily.

Steps: #

1. Log into your Azure account:

   Connect-AzAccount
   

2. Run the transfer script:
   Replace the placeholders with your specific details:

   # Define your variables
   $msdnDownloadUrl = "https://msdn-direct-download-url-here.iso"
   $storageAccountName = "your-storage-account-name"
   $fileShareName = "your-target-file-share"
   $destinationFileName = "SQLServer2016Developer.iso"
   
   # Get the storage account context
   $storageContext = (Get-AzStorageAccount -Name $storageAccountName).Context
   
   # Stream the download directly to Azure Files
   $webResponse = Invoke-WebRequest -Uri $msdnDownloadUrl -UseBasicParsing
   Set-AzStorageFileContent -Context $storageContext -ShareName $fileShareName -Source $webResponse.Content -Path $destinationFileName
   

Key Notes: #

• Link Expiry: MSDN download links usually expire within minutes to hours, so execute the transfer immediately after copying the URL.
• Permissions: Ensure your Azure account has the Storage File Data Contributor role (or higher) on the target storage account to upload files.
• Storage Quota: Verify your Azure File Share has enough space—SQL Server 2016 Developer ISO is around 6GB.

内容的提问来源于stack exchange，提问作者mark