Why can't I login to my SQL Server database on Azure, and how do I correct this? No one in our company has changed the password of our Azure SQL Server database administrator user, yet I'm getting the error noted below when I use SQL Server Management Studio 2017 on my local PC and try to connect to my Azure database as I always have:
为什么我无法登录Azure上的SQL Server数据库，如何更正？我们公司中没有人更改了我们的Azure SQL Server数据库管理员用户的密码，但是当我在本地PC上使用SQL Server Management Studio 2017并尝试连接到我的Azure数据库时，我收到了下面提到的错误有：
Server Name: XXXX.database.windows.net Error Number: 18456 Severity: 14 State: 1 Line Number: 65536
服务器名称：XXXX.database.windows.net错误号码：18456严重性：14状态：1行号：65536
According to Microsoft (https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error?view=sql-server-2017), Error 18456 is a logon failure. I'm not sure what the Severity value means. But as for the State value of 1, it means, "Error information is not available. This state usually means you do not have permission to receive the error details. Contact your SQL Server administrator for more information."
根据Microsoft（https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error?view=sql-server-2017），错误18456是登录失败。我不确定Severity值意味着什么。但是对于状态值1，它表示“错误信息不可用。此状态通常意味着您无权接收错误详细信息。请联系您的SQL Server管理员以获取更多信息。”
Unfortunately, the Azure support website is down so I can't investigate further.
不幸的是，Azure支持网站已关闭，因此我无法进一步调查。
2 个解决方案
#1
3
Azure is having a pretty major outage right now!
Azure现在正在进行相当大的停机！
Microsoft has warned that a "subset of customers in South Central US" may experience Azure problems today after cooling issues sent the servers scurrying for the shutdown button.
微软警告说，在冷却问题导致服务器急停关机按钮后，“美国中南部的一部分客户”可能会遇到Azure问题。
The warning was first raised by Microsoft at 09:29 UTC as pretty much everything in the South Central US region went offline thanks to a temperature spike that caused servers to automatically shut down to avoid damage.
该警告最初是由微软于美国中部时间09:29提出的，因为温度飙升导致服务器自动关闭以避免损坏，因此美国中南部地区几乎所有东西都下线了。
I'd suggest following @AzureSupport to stay updated.
我建议关注@AzureSupport以保持更新。
Unfortunately, the Azure support website is down so I can't investigate further.
不幸的是，Azure支持网站已关闭，因此我无法进一步调查。
Is a pretty good clue as to what's going on.
关于发生了什么是一个非常好的线索。
#2
0
Thanks for the heads up on the Microsoft Azure outage! However, I also went a bit further and visited https://portal.azure.com and clicked "SQL databases" on the navigation bar at left. Under the Subscription column at far right of the table that subsequently appeared, I saw a link titled "(Disabled) Free Trial". Clicking on that led to a Subscription Preview screen that stated that, "This account is on a deprecated billing system. Ask the Account Admin, @, to contact Support to move it to the new system." Thus, it seems the problem stems from the fact that the Azure account was started using a company credit card that was recently canceled (the account owner just left the company). We just have to correct that situation by switching the account admin (see https://docs.microsoft.com/en-us/azure/billing/billing-subscription-transfer). Other folks in the organization are handling that. I'll post here shortly whether that in fact corrects the issue or not.
感谢Microsoft Azure停机！但是，我也进一步访问了https://portal.azure.com并点击了左侧导航栏上的“SQL数据库”。在随后出现的表格最右侧的订阅列下，我看到一个标题为“（已禁用）免费试用”的链接。单击它会导致订阅预览屏幕显示“此帐户位于已弃用的计费系统上。请求帐户管理员@与联系支持人员联系以将其移至新系统。”因此，似乎问题源于Azure帐户是使用最近取消的公司信用卡（帐户所有者刚刚离开公司）启动的。我们只需通过切换帐户管理员来纠正这种情况（请参阅https://docs.microsoft.com/en-us/azure/billing/billing-subscription-transfer）。组织中的其他人正在处理这个问题。我很快就会在这里发布是否实际纠正了这个问题。
#1
3
Azure is having a pretty major outage right now!
Azure现在正在进行相当大的停机！
Microsoft has warned that a "subset of customers in South Central US" may experience Azure problems today after cooling issues sent the servers scurrying for the shutdown button.
微软警告说，在冷却问题导致服务器急停关机按钮后，“美国中南部的一部分客户”可能会遇到Azure问题。
The warning was first raised by Microsoft at 09:29 UTC as pretty much everything in the South Central US region went offline thanks to a temperature spike that caused servers to automatically shut down to avoid damage.
该警告最初是由微软于美国中部时间09:29提出的，因为温度飙升导致服务器自动关闭以避免损坏，因此美国中南部地区几乎所有东西都下线了。
I'd suggest following @AzureSupport to stay updated.
我建议关注@AzureSupport以保持更新。
Unfortunately, the Azure support website is down so I can't investigate further.
不幸的是，Azure支持网站已关闭，因此我无法进一步调查。
Is a pretty good clue as to what's going on.
关于发生了什么是一个非常好的线索。
#2
0
Thanks for the heads up on the Microsoft Azure outage! However, I also went a bit further and visited https://portal.azure.com and clicked "SQL databases" on the navigation bar at left. Under the Subscription column at far right of the table that subsequently appeared, I saw a link titled "(Disabled) Free Trial". Clicking on that led to a Subscription Preview screen that stated that, "This account is on a deprecated billing system. Ask the Account Admin, @, to contact Support to move it to the new system." Thus, it seems the problem stems from the fact that the Azure account was started using a company credit card that was recently canceled (the account owner just left the company). We just have to correct that situation by switching the account admin (see https://docs.microsoft.com/en-us/azure/billing/billing-subscription-transfer). Other folks in the organization are handling that. I'll post here shortly whether that in fact corrects the issue or not.
感谢Microsoft Azure停机！但是，我也进一步访问了https://portal.azure.com并点击了左侧导航栏上的“SQL数据库”。在随后出现的表格最右侧的订阅列下，我看到一个标题为“（已禁用）免费试用”的链接。单击它会导致订阅预览屏幕显示“此帐户位于已弃用的计费系统上。请求帐户管理员@与联系支持人员联系以将其移至新系统。”因此，似乎问题源于Azure帐户是使用最近取消的公司信用卡（帐户所有者刚刚离开公司）启动的。我们只需通过切换帐户管理员来纠正这种情况（请参阅https://docs.microsoft.com/en-us/azure/billing/billing-subscription-transfer）。组织中的其他人正在处理这个问题。我很快就会在这里发布是否实际纠正了这个问题。