如何创建新防火墙规则访问服务器及解决Azure服务器无订阅问题

Hi Sami, let's walk through this to resolve your access problem step by step:

1. Verify the Server's Subscription & Account Permissions #

The error message "The server specified doesn't exist in any subscription" usually points to one of two scenarios:

• You’re logged into an Azure account that lacks permissions to access the subscription hosting your server.
• The server lives in a subscription you haven’t selected or aren’t authorized to view in the Azure portal.

To fix this:

• Head to the Azure portal, click your profile icon in the top-right corner, then select Switch directory to confirm you’re in the correct Azure AD tenant where the target subscription resides.
• Use the Azure CLI to list all subscriptions your account can access (run this in a terminal):

  az account list --output table
  

  If the subscription with your server isn’t listed, reach out to your Azure administrator to grant you at least Reader or Contributor permissions on that subscription.

2. Locate the Server & Configure Firewall Rules #

Once you’ve confirmed access to the right subscription:

• Search for your server in the Azure portal (e.g., if it’s an Azure SQL Server, search for "SQL servers" and select the relevant instance).
• Navigate to the Firewalls and virtual networks section (names vary by service: for VMs, look for Network security groups; for Storage Accounts, it’s also Firewalls and virtual networks).
• Add a new firewall rule:
  • Name it something descriptive (e.g., "My Workstation IP").
  • Input your current public IP address (find this by searching "what's my IP" in your browser).
  • Set the end IP to match the start IP if you have a static IP, or use a small range if your IP is dynamic.
  • For services like Azure SQL Server, toggle on Allow Azure services and resources to access this server if you need access from other Azure resources.
• Save the changes after adding the rule.

3. Validate Access & Troubleshoot Further #

• Try accessing your server/data right after saving the firewall rule.
• If you still can’t connect:
  • Check if your public IP changed (some ISPs use dynamic IPs) — update the firewall rule with your new IP if needed.
  • Confirm your account has specific access permissions on the server itself (e.g., a SQL login with database access, or VM SSH/RDP credentials).

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